Postmaster already running !!!
От | Sivaraman K.G |
---|---|
Тема | Postmaster already running !!! |
Дата | |
Msg-id | 42E0929C.66C09F29@alcatel.com обсуждение исходный текст |
Список | pgsql-bugs |
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
В списке pgsql-bugs по дате отправления: