I've installed it. I see it running. I just can't figure out how to stop it. Or start it again.
Any good references on the net? All I've found is admin apps I have to pay for.
migrated from stackoverflow.com Jan 18 '10 at 0:09
This question came from our site for professional and enthusiast programmers.
I'm going to assume you installed it using macports. Something like sudo port install postgresql84-server
Typically, to "activate" the server, you'd need to run something like
to create the database directory. Then use
To turn it off permantently, use
Typically after it finishes building and installing, macports will tell you these things.
Finally, to use it, you'll typically want to put it into your path:
Then you use be able to use normal commands, like
pgadminIII is a good administration tool. It's freely available.
It doesn't allow you to start and stop the server, but it is a great way to get started without having to know DDL statements. It's also very good for viewing data and running ad-hoc queries.