Postgresql 9.3 not coming up after restart in centos

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.

Responses

Browse pgsql-general by date

  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?