----- Original Message -----
Sent: Friday, July 22, 2005 2:30 AM
Subject: [BUGS] Postmaster already
running !!!
Hi,
I am running PostgreSQL version 8.0 in Solaris 8.
I am starting the
postmaster when the system is coming up.
I am facing the following problem
:
FATAL: lock file "/data/ALAsm/PGSQL/data/postmaster.pid" already
exists
HINT: Is another postmaster (PID 448) running in data
directory "/data/ALAsm/PGSQL/data"?
is coming, eventhough postmaster wasn't running and postmaster fail to
start, which makes my system to go down (due to my script).
I have to manually clean up the postmaster.pid from the directory
/data/ALAsm/PGSQL/data (from where I have initialized the database using
initdb and running the postmaster).
Can anyone help what is the problem here ?.
Also, I got another problem.
LOG: could not bind IPv6 socket: Cannot assign requested address
HINT: Is another postmaster already running on port 5432? If not,
wait a few seconds and
retry.
LOG: could not bind socket for
statistics collector: Cannot assign requested address
LOG: database
system was interrupted at 2005-07-21 15:05:15 CDT
LOG: checkpoint
record is at 0/E06260
LOG: redo record is at 0/E06260; undo record
is at 0/0; shutdown TRUE
LOG: next transaction ID: 174106; next OID:
25721
LOG: database system was not properly shut down; automatic
recovery in progress
LOG: record with zero length at 0/E062A0
LOG: redo is not required
PANIC: could not access status
of transaction 174106
DETAIL: could not read from file
"/data/ALAsm/PGSQL/data/pg_clog/0000" at offset 40960: Error 0
LOG:
startup process (PID 501) was terminated by signal 6
LOG: aborting
startup due to startup process failure
After this, postmaster is not running and the system got rebooted
continuously.
In this case, I have to manually cleanup all the database
and run initdb again to setup the database.
Can any one help, what is the problem?.
Thanks
Siva
--
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
