PostgreSQL on a Mac

From Wildsong
Jump to navigationJump to search

Where to get it

I installed using the StackBuilder after downloading this image from Enterprise DB. I am not sure what I agreed to when I clicked "I agree" but I think this is an eval only license. No worries as I am only evaluating it right now.

How to start and stop it

pg_ctl is not on my path right now so... this works:

/Library/PostgreSQL/9.2/bin/pg_ctl -D /Library/PostgreSQL/9.2/data start

or of course I can also do "stop".

It must have prompted me for a password when I installed because it asks for one that I knew! Whew.

Using psql

It's in /usr/bin so no worries on the path.

Now back to PostgreSQL or maybe Wavemaker?