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 0000 in log segment 000000010000000000000002, offset 0 LOG: invalid primary checkpoint record LOG: invalid magic number 0000 in log segment 000000010000000000000002, offset 0 LOG: invalid secondary checkpoint record PANIC: could not locate a valid checkpoint record LOG: startup process (PID 2529) was terminated by signal 6: Aborted LOG: aborting startup due to startup process failure in the location "/var/lib/pgsql/9.3/data/pg_xlog", I see 3 files 000000010000000000000002, 000000010000000000000003 and an empty directoy archive_status. When I tried to restart the Postgres, I am getting the same error. How to start the Postgres now? How to avoid this problem without happening in future? Thanks. Let me know incase if more information is needed. -- View this message in context: http://postgresql.nabble.com/Postgresql-9-3-not-coming-up-after-restart-in-centos-tp5880435.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
