On 01/05/2016 11:18 AM, balajishanmugam@xxxxxxx wrote:
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
Not sure what you are talking about when you say CentOS application. Are you saying when CentOS starts, or an application that you wrote starts? How did you install Postgres? Can you show the init script that is starting/stopping Postgres? If such a thing does not exist, how do you start/stop Postgres?
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.
-- Adrian Klaver adrian.klaver@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
