posgres-7.1.3 hpux-11.00 posmaster died

From: bk226157(at)skynet(dot)be (pierre)
To: pgsql-general(at)postgresql(dot)org
Subject: posgres-7.1.3 hpux-11.00 posmaster died
Date: 2002-01-01 16:43:47
Message-ID: 4d7a913b.0201010843.7a7700cb@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

This morning I saw my database had no new record added since
yesterday.
And my db should be updated on the 15 min with hundreds of records !!

I tried first to connect to my db but I got the following answer:

>psql tkgdb1240
psql: connectDBStart() -- connect() failed: No such file or directory
Is the postmaster running locally
and accepting connections on Unix socket '/tmp/.s.PGSQL.5432'?

I wanted to restart postmaster with:

nohup /opt/postgres/bin/postmaster -i -D /db1240/data
1>>/home/postgres/server.log 2>&1 &

but I got this in my server.log:

Lock file "/db1240/data/postmaster.pid" already exists.
Is another postmaster (pid 6089) running in "/db1240/data"?

I displayed the process:

>ps -ef | grep post
postgres 6089 1 0 Dec 27 pts/ta 0:47
/opt/postgres/bin/postmaster -i -D /db1240/data
idxxxxxx 21087 3390 0 16:32:57 pts/ta 0:00 grep post
postgres 20590 20580 0 16:20:06 pts/tf 0:00 -ksh
idxxxxxx>

I started a top but saw nothing special. No hanging process.
No vacuum, no psql session, .... and 90 % of free resources.

What I see in my server.log is:

DEBUG: copy: line 70, XLogWrite: new log file created - consider
increasing WAL
_FILES
DEBUG: MoveOfflineLogs: remove 00000003000000BB

But I don't understand what it means :-(

Now I will kill the posmaster and start it again.
Any help greatly appreciated to understand what's happened.

Happy New Years from Belgium.
Pierre.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Bryan 2002-01-01 17:11:04 Access to Postgresql Utility
Previous Message Andreas 2002-01-01 14:48:09 problems using mod_auth_pgsql