pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgresql service starts and stops immediately
5+ messages / 5 participants
[nested] [flat]
* Postgresql service starts and stops immediately
@ 2018-02-27 05:00 ragini vyas <vyas.ragini@gmail.com>
2018-02-27 12:06 ` Re: Postgresql service starts and stops immediately Samed YILDIRIM <samed@reddoc.net>
2018-02-27 13:28 ` Re: Postgresql service starts and stops immediately Ray Stell <stellr@vt.edu>
2018-02-27 14:24 ` Re: Postgresql service starts and stops immediately Shreeyansh Dba <shreeyansh2014@gmail.com>
0 siblings, 3 replies; 5+ messages in thread
From: ragini vyas @ 2018-02-27 05:00 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Postgresql service starts and stops immediately
2018-02-27 05:00 Postgresql service starts and stops immediately ragini vyas <vyas.ragini@gmail.com>
@ 2018-02-27 12:06 ` Samed YILDIRIM <samed@reddoc.net>
2 siblings, 0 replies; 5+ messages in thread
From: Samed YILDIRIM @ 2018-02-27 12:06 UTC (permalink / raw)
To: ragini vyas <vyas.ragini@gmail.com>; pgsql-admin
<div>Hi Ragini,</div><div> </div><div>Are you using systemctl or /etc/init.d scripts to start PostgreSQL? If yes, could you please try using pg_ctl. pg_ctl command usage and path of it is like following.</div><div> </div><div> </div><div>On Centos 7 (wiith repo installation):</div><div>/usr/pgsql-9.3/bin/pg_ctl -D /var/lib/pgctl/9.3/data start</div><div> </div><div>On Debian 8 (with repo installation):</div><div>/usr/lib/postgresql/9.3/bin/pg_ctl -D /var/lib/postgresql/9.3/data/ -c config_file=/etc/postgresql/9.3/main/postgresql.conf start</div><div> </div><div>Best regards.</div><div> </div><div>İyi çalışmalar.</div><div>Samed YILDIRIM</div><div> </div><div> </div><div> </div><div>27.02.2018, 11:42, "ragini vyas" <vyas.ragini@gmail.com>:</div><blockquote type="cite"><div>Hi,<div> </div><div>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".</div><div> </div><div>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. </div><div> </div><div>Please help.</div><div> </div><div> <div><div><div><div><div><div><div>Regards</div><div>Ragini Vyas</div><div><span>7507-999-299</span></div></div></div></div></div></div></div></div></div></blockquote>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Postgresql service starts and stops immediately
2018-02-27 05:00 Postgresql service starts and stops immediately ragini vyas <vyas.ragini@gmail.com>
@ 2018-02-27 13:28 ` Ray Stell <stellr@vt.edu>
2018-02-27 13:52 ` Re: Postgresql service starts and stops immediately Ramesh <ramesh4f@gmail.com>
2 siblings, 1 reply; 5+ messages in thread
From: Ray Stell @ 2018-02-27 13:28 UTC (permalink / raw)
To: ragini vyas <vyas.ragini@gmail.com>; pgsql-admin
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.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Postgresql service starts and stops immediately
2018-02-27 05:00 Postgresql service starts and stops immediately ragini vyas <vyas.ragini@gmail.com>
2018-02-27 13:28 ` Re: Postgresql service starts and stops immediately Ray Stell <stellr@vt.edu>
@ 2018-02-27 13:52 ` Ramesh <ramesh4f@gmail.com>
0 siblings, 0 replies; 5+ messages in thread
From: Ramesh @ 2018-02-27 13:52 UTC (permalink / raw)
To: Ray Stell <stellr@vt.edu>; +Cc: ragini vyas <vyas.ragini@gmail.com>; pgsql-admin
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.
>
>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Postgresql service starts and stops immediately
2018-02-27 05:00 Postgresql service starts and stops immediately ragini vyas <vyas.ragini@gmail.com>
@ 2018-02-27 14:24 ` Shreeyansh Dba <shreeyansh2014@gmail.com>
2 siblings, 0 replies; 5+ messages in thread
From: Shreeyansh Dba @ 2018-02-27 14:24 UTC (permalink / raw)
To: ragini vyas <vyas.ragini@gmail.com>; +Cc: pgsql-admin
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.
<http://www.shreeyansh.com;
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
>
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2018-02-27 14:24 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2018-02-27 05:00 Postgresql service starts and stops immediately ragini vyas <vyas.ragini@gmail.com>
2018-02-27 12:06 ` Samed YILDIRIM <samed@reddoc.net>
2018-02-27 13:28 ` Ray Stell <stellr@vt.edu>
2018-02-27 13:52 ` Ramesh <ramesh4f@gmail.com>
2018-02-27 14:24 ` Shreeyansh Dba <shreeyansh2014@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox