Re: [GENERAL] Postgresql 9.3 not coming up after restart in centos

2016-01-07 Thread John R Pierce
On 1/7/2016 12:41 PM, balajishanmu...@live.in wrote: For storage I am using a 2.5inch SATA 3 SSD hard disk. It is about 60 GB. I am yet to get the log. I will post the Postgres log once I have it. is this an enterprise grade SSD with supercap backup? or is it a consumer desktop/notebook class

Re: [GENERAL] Postgresql 9.3 not coming up after restart in centos

2016-01-07 Thread Scott Marlowe
On Thu, Jan 7, 2016 at 1:41 PM, balajishanmu...@live.in wrote: > Hi, > > For storage I am using a 2.5inch SATA 3 SSD hard disk. It is about 60 GB. I > am yet to get the log. I will post the Postgres log once I have it. > > Thanks! Yeah a lot of cheaper consumer grade SSDs don't fsync safely. Ther

Re: [GENERAL] Postgresql 9.3 not coming up after restart in centos

2016-01-07 Thread balajishanmu...@live.in
Hi, For storage I am using a 2.5inch SATA 3 SSD hard disk. It is about 60 GB. I am yet to get the log. I will post the Postgres log once I have it. Thanks! -- View this message in context: http://postgresql.nabble.com/Postgresql-9-3-not-coming-up-after-restart-in-centos-tp5880435p5880957.htm

Re: [GENERAL] Postgresql 9.3 not coming up after restart in centos

2016-01-07 Thread Scott Marlowe
On Wed, Jan 6, 2016 at 2:08 PM, balajishanmu...@live.in wrote: > Most of the time I will be restarting centOS by issuing reboot command. Which > will do the orderly shutdown of all the service and sometimes just pull the > plug. > > But the issue appears to be random. Is there a way that before Po

Re: [GENERAL] Postgresql 9.3 not coming up after restart in centos

2016-01-06 Thread Adrian Klaver
On 01/06/2016 01:08 PM, balajishanmu...@live.in wrote: Most of the time I will be restarting centOS by issuing reboot command. Which will do the orderly shutdown of all the service and sometimes just pull the plug. But the issue appears to be random. Is there a way that before Postgres starts we

Re: [GENERAL] Postgresql 9.3 not coming up after restart in centos

2016-01-06 Thread balajishanmu...@live.in
Most of the time I will be restarting centOS by issuing reboot command. Which will do the orderly shutdown of all the service and sometimes just pull the plug. But the issue appears to be random. Is there a way that before Postgres starts we can check whether data is flushed, if not flush it manua

Re: [GENERAL] Postgresql 9.3 not coming up after restart in centos

2016-01-06 Thread Scott Marlowe
On Wed, Jan 6, 2016 at 12:36 PM, balajishanmu...@live.in wrote: > By application I mean centOS. > > We are starting and stopping Postgres using systemd service. We have a > service file called postgresql9.3.service which is used to start or stop > Postgres. > > Excerpts of postgresql9.3.service >

Re: [GENERAL] Postgresql 9.3 not coming up after restart in centos

2016-01-06 Thread balajishanmu...@live.in
By application I mean centOS. We are starting and stopping Postgres using systemd service. We have a service file called postgresql9.3.service which is used to start or stop Postgres. Excerpts of postgresql9.3.service ExecStartPre=/usr/pgsql-9.3/bin/postgresql93-check-db-dir ${PGDATA} ExecStart=

Re: [GENERAL] Postgresql 9.3 not coming up after restart in centos

2016-01-06 Thread Adrian Klaver
On 01/05/2016 11:18 AM, balajishanmu...@live.in wrote: Hi I have installed postgresql-9.3 in my centos application. When the application starts for first-time Postgres starts without any issue most of Not sure what you are talking about when you say CentOS application. Are you saying when Cen

[GENERAL] Postgresql 9.3 not coming up after restart in centos

2016-01-06 Thread balajishanmu...@live.in
Hi I have installed postgresql-9.3 in my centos application. When the application starts for first-time Postgres starts without any issue most of the time. But when I reboot the centOs, Postgres is not getting started on subsequent boot and I am getting the error, LOG: invalid magic number