pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Barry Moore <barry.moore@genetics.utah.edu>
To: pgsql-admin@postgresql.org
Subject: Trouble starting server
Date: Thu, 16 Feb 2006 11:23:21 -0700
Message-ID: <3DAF6869-77A4-4B3F-ADCF-DBF36ACA5E41@genetics.utah.edu> (raw)

I have a PostgreSQL 7.4.8 installation running on RedHat Enterprise 4  
that I've been using for some time now, and haven't had any trouble  
with.  Recently the system went down, and now I can't seem to restart  
it.  I've tried running these commands as postgres user:

nohup postmaster -D /var/lib/pgsql/data > /var/lib/pgsql/logfile 2>&1 &
and
pg_ctl start -D /var/lib/pgsql/data -l /var/lib/pgsql/logfile

and they both reply that the 'postmaster successfully started', but  
then in the logfile I find 'FATAL:  could not create lock file "/ 
tmp/.s.PGSQL.5432.lock": Permission denied'.  And if I try to run  
psql I get:

psql: 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"?

So with my minimal system admin skills I'm guessing that '/ 
tmp/.s.PGSQL.5432' is lock file where the system puts a lock on port  
5432 for postmaster to listen, but the pg_ctl and postmaster commands  
can't create that file because /tmp is writeable only by root (drwxr- 
xr-x   11 root root  4096 Feb 16 11:06 tmp).  Of course I can't start  
the postmaster as root, so I'm a bit perplexed as to what to do, and  
why I never had this problem before.

Any suggestions.

Barry



view thread (3+ messages)  latest in thread

Message-ID: <3DAF6869-77A4-4B3F-ADCF-DBF36ACA5E41@genetics.utah.edu>
Permalink:  ../3DAF6869-77A4-4B3F-ADCF-DBF36ACA5E41@genetics.utah.edu/
Also on:    postgresql.org/message-id/3DAF6869-77A4-4B3F-ADCF-DBF36ACA5E41@genetics.utah.edu

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: barry.moore@genetics.utah.edu
  Subject: Re: Trouble starting server
  In-Reply-To: <3DAF6869-77A4-4B3F-ADCF-DBF36ACA5E41@genetics.utah.edu>
  References: <3DAF6869-77A4-4B3F-ADCF-DBF36ACA5E41@genetics.utah.edu>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox