Thread: Postgresql service starts and stops immediately
Hi,
I have Postgresql version 9.3.13 installed. After an unexpected reboot, postgresql service doesn't start. I get the error messgae "Postgresql service started and stopped immediately".
I deleted postmaster.pid and postmaster.opts files and tried starting the service. When I do this, service takes some time and then gives the same error.
Please help.
Regards
Ragini Vyas
7507-999-299
On 2/27/18 12:00 AM, ragini vyas wrote: > Hi, > > I have Postgresql version 9.3.13 installed. After an unexpected > reboot, postgresql service doesn't start. I get the error messgae > "Postgresql service started and stopped immediately". > Look at the postmaster log contents. It will provide valuable debugging information.
Adding one more hint with Ray comment, In case the log didn't enabled, configure the log collector, in the configuration file. And then debug.
On Tue, Feb 27, 2018 at 6:58 PM, Ray Stell <stellr@vt.edu> wrote:
On 2/27/18 12:00 AM, ragini vyas wrote:Hi,Look at the postmaster log contents. It will provide valuable debugging information.
I have Postgresql version 9.3.13 installed. After an unexpected reboot, postgresql service doesn't start. I get the error messgae "Postgresql service started and stopped immediately".
Hi Ragini,
We are suspecting & assuming it as a windows OS where there might be possibilities on moving of data directory or postgresql.conf into some other location that failing starting of PostgreSQL service during this unexpected reboot.Verify its existence in respective correct locations & diagnose for more details from database server logs.
We are suspecting & assuming it as a windows OS where there might be possibilities on moving of data directory or postgresql.conf into some other location that failing starting of PostgreSQL service during this unexpected reboot.Verify its existence in respective correct locations & diagnose for more details from database server logs.
On Tue, Feb 27, 2018 at 10:30 AM, ragini vyas <vyas.ragini@gmail.com> wrote:
Hi,I have Postgresql version 9.3.13 installed. After an unexpected reboot, postgresql service doesn't start. I get the error messgae "Postgresql service started and stopped immediately".I deleted postmaster.pid and postmaster.opts files and tried starting the service. When I do this, service takes some time and then gives the same error.Please help.RegardsRagini Vyas7507-999-299
Von: Shreeyansh Dba [mailto:shreeyansh2014@gmail.com]
Gesendet: Dienstag, 27. Februar 2018 15:24.org>
Betreff: Re: Postgresql service starts and stops immediately
Hi Ragini,
We are suspecting & assuming it as a windows OS where there might be possibilities on moving of data directory or postgresql.conf into some other location that failing starting of PostgreSQL service during this unexpected reboot.Verify its existence in respective correct locations & diagnose for more details from database server logs.
And – in addition - check the Windows event log.
Regards, Klaus