Обсуждение: Trouble starting server

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

On Thu, 16 Feb 2006, Barry Moore wrote:

> 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.

You need to change the permissions on /tmp.  I'd be curious to know how it got
this way.  Has anyone done chmods on /tmp?  It should be 1777/drwxrwxrwt, so a
chmod 1777 /tmp should fix it
for you.


--
Jeff Frost, Owner     <jeff@frostconsultingllc.com>
Frost Consulting, LLC     http://www.frostconsultingllc.com/
Phone: 650-780-7908    FAX: 650-649-1954

Thanks.  I wasn't sure that I should do that since I didn't change
those permissions since I hadn't done anything with it.  There is a
new user who is taking over admin of this machine, so I'll have to
ask if the did anything to affect this.

Barry

On Feb 16, 2006, at 11:30 AM, Jeff Frost wrote:

> On Thu, 16 Feb 2006, Barry Moore wrote:
>
>> 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.
>
> You need to change the permissions on /tmp.  I'd be curious to know
> how it got this way.  Has anyone done chmods on /tmp?  It should be
> 1777/drwxrwxrwt, so a chmod 1777 /tmp should fix it for you.
>
>
> --
> Jeff Frost, Owner     <jeff@frostconsultingllc.com>
> Frost Consulting, LLC     http://www.frostconsultingllc.com/
> Phone: 650-780-7908    FAX: 650-649-1954