Skip site navigation (1) Skip section navigation (2)

Starting postgres server on mac os x 10.6.8

From: Andrew Barinov <abarinov(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Starting postgres server on mac os x 10.6.8
Date: 2012-02-05 04:50:34
Message-ID: CAGrueTOf_jw75+F6re_wnxvXkHeWSEtswySo2qpafWWimAXOGw@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
Hello,

I'm having trouble restarting the postgres server on my mac. The error I am
getting when I try to run PG is:

could not connect to server: No such file or directory Is the server
running locally and accepting connections on Unix domain socket
"/tmp/.s.PGSQL.5432"?

Here's the command that I tried:

sudo su postgres

bash-3.2$ /Library/PostgreSQL/9.1/bin/pg_ctl -D
/Library/PostgreSQL/9.1/data restart
pg_ctl: PID file "/Library/PostgreSQL/9.1/data/postmaster.pid" does not
exist
Is server running?
starting server anyway
server starting

then I checked the server status:

bash-3.2$ /Library/PostgreSQL/9.1/bin/pg_ctl -D
/Library/PostgreSQL/9.1/data status
pg_ctl: no server running

I verified that the pg_ctl and pg_conf files were in place.

I then went ahead and tried this:

bash-3.2$ /Library/PostgreSQL/9.1/bin/pg_ctl -D
/Library/PostgreSQL/9.1/data start
server starting

then I checked the server status:

bash-3.2$ /Library/PostgreSQL/9.1/bin/pg_ctl -D
/Library/PostgreSQL/9.1/data status
pg_ctl: no server running

Why is the postgres not starting? I am doing all this under the postgres
superuser, so I should not have any issue with user privileges.

Thanks,

Andrew

Responses

pgsql-admin by date

Next:From: Kevin GrittnerDate: 2012-02-05 05:11:35
Subject: Re: overcoming a recursive relationship in a sql statement
Previous:From: Kevin DuffyDate: 2012-02-05 00:48:34
Subject: Add tablefunc modules to Postgresql 9.1

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group