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