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.