cannot restart postgres on mac os x

Question

I cannot restart the postgres server on Mac OS X. How can I fix this?

Tried two ways:

pg_ctl restart returns:

pg_ctl: PID file "usr/local/var/postgres:/postmaster.pid" does not exist
Is server running?
starting server anyway
pg_ctl: could not read file "usr/local/var/postgres:/postmaster.opts"

The server does not restart

pg_ctl -D /usr/local/var/postgres restart results in:

   pg_ctl: PID file "/usr/local/var/postgres/postmaster.pid" does not exist
   Is server running?
   starting server anyway
   server starting
   LOG:  could not bind IPv4 socket: Address already in use
   HINT:  Is another postmaster already running on port 5432? If not, wait a few seconds and retry.
   LOG:  could not bind IPv6 socket: Address already in use
   HINT:  Is another postmaster already running on port 5432? If not, wait a few seconds and retry.
   WARNING:  could not create listen socket for "*"
   FATAL:  could not create any TCP/IP sockets

OMG .. yet another one... http://stackoverflow.com/a/8482546/905902 — wildplasser, Oct 02 '13 at 21:21
Check for bogey running processes with `ps aux | grep postgres`, kill them and then try starting your server — Hedde van der Heide, Oct 02 '13 at 21:24

Mingyu · Accepted Answer · 2013-10-06T04:50:20.130

13

1 - Your data directory might be wrong. Make sure you use the right path.

2 - If you install more than one postgres, you need to specify which pg_ctl to use.

I installed postgres 9.2 manually, here's how I start it:

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

I installed postgres 9.1 via HomeBrew, here's how it gets started:

/usr/local/Cellar/postgresql/9.1.5/bin/pg_ctl -D /usr/local/var/postgres-9.1.5 start

edited Oct 06 '13 at 04:50

answered Oct 02 '13 at 21:28

Mingyu

31,751
14
55
60

1

But it needs postgresql user permission to run the first command [if install manually] – Dhiraj Aug 31 '20 at 13:01

cannot restart postgres on mac os x

1 Answers1

Linked