<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<p>I am running PostgreSQL version 8.0 in Solaris 8.
<br>I am starting the postmaster when the system is coming up.
<br>I am facing the following problem :
<p>FATAL: lock file "/data/ALAsm/PGSQL/data/postmaster.pid" already
<br>HINT: Is another postmaster (PID 448) running in data directory
<p>is coming, eventhough postmaster wasn't running and postmaster fail
to start, which makes my system to go down (due to my script).
<p>I have to manually clean up the postmaster.pid from the directory /data/ALAsm/PGSQL/data
(from where I have initialized the database using
<br>initdb and running the postmaster).
<p>Can anyone help what is the problem here ?.
<p>Also, I got another problem.
<p>LOG: could not bind IPv6 socket: Cannot assign requested address
<br>HINT: Is another postmaster already running on port 5432? If
not, wait a few seconds and
<br>LOG: could not bind socket for statistics collector: Cannot assign
<br>LOG: database system was interrupted at 2005-07-21 15:05:15 CDT
<br>LOG: checkpoint record is at 0/E06260
<br>LOG: redo record is at 0/E06260; undo record is at 0/0; shutdown
<br>LOG: next transaction ID: 174106; next OID: 25721
<br>LOG: database system was not properly shut down; automatic recovery
<br>LOG: record with zero length at 0/E062A0
<br>LOG: redo is not required
<br>PANIC: could not access status of transaction 174106
<br>DETAIL: could not read from file "/data/ALAsm/PGSQL/data/pg_clog/0000"
at offset 40960: Error 0
<br>LOG: startup process (PID 501) was terminated by signal 6
<br>LOG: aborting startup due to startup process failure
<p>After this, postmaster is not running and the system got rebooted continuously.
<br>In this case, I have to manually cleanup all the database and run initdb
again to setup the database.
<p>Can any one help, what is the problem?.
K.G.Sivaraman, Axes Technologies (I) Pvt Ltd
"The only SERVICE to be done for our lower classes is to give them
EDUCATION, to develop their lost individuality" - Swami Vivekananda</pre>
pgsql-bugs by date
|Next:||From: Andrus Adamchik||Date: 2005-07-22 08:45:46|
|Subject: BUG #1780: JDBC driver "setNull" throws for BLOB and CLOB columns|
|Previous:||From: jw||Date: 2005-07-22 05:47:36|
|Subject: abstime bug|