Re: [GENERAL] Postgresql 9.3 not coming up after restart in centos
Hi, For storage I am using a 2.5inch SATA 3 SSD hard disk. It is about 60 GB. I am yet to get the log. I will post the Postgres log once I have it. Thanks! -- View this message in context: http://postgresql.nabble.com/Postgresql-9-3-not-coming-up-after-restart-in-centos-tp5880435p5880957.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] Postgresql 9.3 not coming up after restart in centos
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 in log segment 00010002, offset 0 LOG: invalid primary checkpoint record LOG: invalid magic number in log segment 00010002, 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 00010002, 00010003 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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Postgresql 9.3 not coming up after restart in centos
By application I mean centOS. We are starting and stopping Postgres using systemd service. We have a service file called postgresql9.3.service which is used to start or stop Postgres. Excerpts of postgresql9.3.service ExecStartPre=/usr/pgsql-9.3/bin/postgresql93-check-db-dir ${PGDATA} ExecStart=/usr/pgsql-9.3/bin/pg_ctl start -D ${PGDATA} -s -w -t 300 ExecStop=/usr/pgsql-9.3/bin/pg_ctl stop -D ${PGDATA} -s -m fast ExecReload=/usr/pgsql-9.3/bin/pg_ctl reload -D ${PGDATA} -s -- View this message in context: http://postgresql.nabble.com/Postgresql-9-3-not-coming-up-after-restart-in-centos-tp5880435p5880677.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Postgresql 9.3 not coming up after restart in centos
Most of the time I will be restarting centOS by issuing reboot command. Which will do the orderly shutdown of all the service and sometimes just pull the plug. But the issue appears to be random. Is there a way that before Postgres starts we can check whether data is flushed, if not flush it manually or any other better way to avoid this issue. Thank you! -- View this message in context: http://postgresql.nabble.com/Postgresql-9-3-not-coming-up-after-restart-in-centos-tp5880435p5880690.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general