The cleanest way by far to start/stop/restart PostgreSQL if you have installed it through brew is to simply unload and/or load the launchd configuration file that comes with the installation: launchctl unload ~/Library/LaunchAgents/ alias rver='sudo -u postgres pg_ctl -D /Library/PostgreSQL/9.2/data'Īnd then? You can start/stop your PostgreSQL server with this: rver start bash_profile (my PostgreSQL version is 9.2.4, and the database path is /Library/PostgreSQL/9.2/data). Here my two cents: I made an alias for postgres pg_ctl and put it in file. To start PostgreSQL: lunchy start postgresįor further information, refer to: 'How to Install PostgreSQL on a Mac With Homebrew and Lunchy' Tail -f /usr/local/var/ /server.logĪnother approach is using the lunchy gem (a wrapper for launchctl): brew install postgresql You can verify this by looking at the logs of Postgres to see what might be going on: tail -f /usr/local/var/postgres/server.logįor specific version:- tail -f /usr/local/var/ /server.log You may want to start PG server but it was not.įirst, you have to delete the file /usr/local/var/postgres/postmaster.pid Then you can restart the service using one of the many other mentioned methods depending on your install. This was also the solution for me, but I didn't see that anyone posted it here, so for those who are looking for it: initdb /usr/local/var/postgres -E utf8 I had almost the exact same issue, and you cited the initdb command as being the fix.

If you have a specific version, make sure to suffix the version. If you want to manually start and stop PostgreSQL (installed via Homebrew), the easiest way is: brew services start postgresql 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.

Start sql on mac