From: | "balajishanmugam(at)live(dot)in" <balajishanmugam(at)live(dot)in> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Postgresql 9.3 not coming up after restart in centos |
Date: | 2016-01-05 19:18:12 |
Message-ID: | 1452021492260-5880435.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2016-01-05 19:47:30 | Re: Unique constraints and indexes. |
Previous Message | Roland van Laar | 2016-01-05 19:08:25 | Re: Code of Conduct: Is it time? |