On Wed, Jan 6, 2016 at 2:08 PM, balajishanmugam@xxxxxxx <balajishanmugam@xxxxxxx> 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 can check whether data is flushed, if not flush it manually or any > other better way to avoid this issue. As Adrian mentioned, by the time you go for a startup of pgsql, the damage is already done during the previous shut down. The real issue here is that a properly operating server should be able to have the power plug pulled, and on boot up postgres should be able to come back up. When pgsql can't come back up, it's usually due to an unreliable storage subsystem. So what are you using for storage? -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
