PostgreSQL is integrated in Server.app available through the App Store in Mac OS X v10.8 (Mountain Lion). PostgreSQL was most likely installed via Homebrew, Fink, MacPorts or the EnterpriseDB installer.Ĭheck the output of the following commands to determine which package manager it was installed with: brew & brew list|grep postgres Make sure tcp localhost connections are enabled in pg_hba.conf: # IPv4 local connections:Ĭheck the listen_addresses and port in nf:Įgrep 'listen|port' /usr/local/var/postgres/nf #listen_addresses = 'localhost' # What IP address(es) to listen on What is the result of pg_ctl -D /usr/local/var/postgres status?Īre there any error messages in the server.log? What is the result of pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log start? "To have launchd start postgresql now and restart at login:" Pg_ctl -D /usr/local/var/postgres stop Start automatically Pg_ctl -D /usr/local/var/postgres start Stop manually For more information, run brew info postgres. The Homebrew package manager includes launchctl plists to start automatically. I am still getting the same "Is the server running?" message. > cp /usr/share/postgresql/ /usr/share/postgresql/nf So I tried this: > cp /usr/local/Cellar/postgresql/9.0.4/share/postgresql/ /usr/local/Cellar/postgresql/9.0.4/share/postgresql/nf #listen_addresses = 'localhost' # what IP address(es) to listen on So I did this: egrep 'listen|port' /usr/local/Cellar/postgresql/9.0.4/share/postgresql/ usr/local/Cellar/postgresql/9.0.4/share/postgresql/ Though, I did do this: >sudo find / -name "*nf*" This seems odd: > egrep 'listen|port' /usr/local/var/postgres/nfĮgrep: /usr/local/var/postgres/nf: No such file or directory Please log in (using, e.g., "su") as the (unprivileged) user that will own the server process.
CREATE ROOT USER POSTGRESQL MAC UPDATE
Update 5: sudo pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log start
> pg_ctl -D /usr/local/var/postgres status Here are the contents: # IPv4 local connections:īut I don't understand this: > pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log start I found that there wasn't any pg_hba.conf file (only file pg_), so I modified the sample and renamed it (to remover the. Update 3: > pg_ctl -D /usr/local/var/postgres status Is the server running on host "localhost" and accepting The touch was not successful, so I did this instead: > mkdir /usr/local/var/postgresīut when I try to start the Ruby on Rails server, I still see this: Sh: /usr/local/var/postgres/server.log: No such file or directory Update: > pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log start
I see that postgres is not running > ps auxwww | grep postgres I had forgotten to run the initdb command.īy running this command ps auxwww | grep postgres
0 kommentar(er)
