http://exponential.io/blog/2015/02/21/install-postgresql-on-mac-os-x-via-brew/
To have launchd start postgresql now and restart at login:
brew services start postgresql
Or, if you don't want/need a background service you can just run:
postgres -D /usr/local/var/postgres
https://marcinkubala.wordpress.com/2013/11/11/postgresql-on-os-x-mavericks/
*******************************************************
http://stackoverflow.com/questions/7975556/how-to-start-postgresql-server-on-mac-os-x
Starting and stopping server
The Homebrew package manager includes launchctl plists to start automatically. For more information run
brew info postgres.
Start manually:
pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log start
Stop manually:
pg_ctl -D /usr/local/var/postgres stop -s -m fast
What is the result of
pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log start?
What is the result of
pg_ctl -D /usr/local/var/postgres status?
Are there any error messages in the server.log?
Make sure tcp localhost connections are enabled in pg_hba.conf:
# IPv4 local connections:
host all all 127.0.0.1/32 trust
Check the listen_addresses and port in postgresql.conf:
egrep 'listen|port' /usr/local/var/postgres/postgresql.conf#listen_addresses = 'localhost' # what IP address(es) to listen on;
#port = 5432 # (change requires restart)
Cleaning up
Check the output of the following commands to determine which package manager it was installed with:
brew && brew list|grep postgres
fink && fink list|grep postgres
port && port installed|grep postgres
No comments:
Post a Comment