Обсуждение: Postgresql service starts and stops immediately

Поиск
Список
Период
Сортировка

Postgresql service starts and stops immediately

От
ragini vyas
Дата:
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

Re: Postgresql service starts and stops immediately

От
Ray Stell
Дата:
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.

Re: Postgresql service starts and stops immediately

От
Ramesh
Дата:
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,

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.


Re: Postgresql service starts and stops immediately

От
Shreeyansh Dba
Дата:
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.




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.


Regards
Ragini Vyas
7507-999-299

WG: Postgresql service starts and stops immediately

От
"Klaus"
Дата:

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