On Tuesday 19 November 2013 14:25:44 bricklen wrote: > On Tue, Nov 19, 2013 at 3:08 AM, Gary Stainburn < > > 29448 ? Ds 0:07 postgres: startup process recovering > > 000000010000000C000000FD > > What do the contents of your Postgresql logs look like? Anything to > indicate why it is recovering? Are there any errors in the logs? It now says 29448 ? Ds 1:16 postgres: startup process recovering 000000010000000C000000FE so it is doing something. Today's log file (/var/lib/pgsql/data/pg_log/postgresql-Tue.log) contains ERROR: table "delcandidates" does not exist STATEMENT: DROP TABLE DelCandidates ERROR: table "delcandidates" does not exist STATEMENT: DROP TABLE DelCandidates ERROR: table "delcandidates" does not exist STATEMENT: DROP TABLE DelCandidates ERROR: table "delcandidates" does not exist STATEMENT: DROP TABLE DelCandidates ERROR: table "delcandidates" does not exist STATEMENT: DROP TABLE DelCandidates ERROR: table "delcandidates" does not exist STATEMENT: DROP TABLE DelCandidates ERROR: table "delcandidates" does not exist STATEMENT: DROP TABLE DelCandidates ERROR: table "delcandidates" does not exist STATEMENT: DROP TABLE DelCandidates ERROR: table "delcandidates" does not exist STATEMENT: DROP TABLE DelCandidates ERROR: table "delcandidates" does not exist STATEMENT: DROP TABLE DelCandidates LOG: unexpected EOF on client connection ERROR: table "delcandidates" does not exist STATEMENT: DROP TABLE DelCandidates ERROR: table "delcandidates" does not exist STATEMENT: DROP TABLE DelCandidates ERROR: table "delcandidates" does not exist STATEMENT: DROP TABLE DelCandidates ERROR: table "delcandidates" does not exist STATEMENT: DROP TABLE DelCandidates ERROR: table "delcandidates" does not exist STATEMENT: DROP TABLE DelCandidates ERROR: table "delcandidates" does not exist STATEMENT: DROP TABLE DelCandidates ERROR: table "delcandidates" does not exist STATEMENT: DROP TABLE DelCandidates LOG: could not receive data from client: Connection reset by peer LOG: unexpected EOF on client connection ERROR: table "delcandidates" does not exist STATEMENT: DROP TABLE DelCandidates LOG: database system was shut down in recovery at 2013-11-18 13:32:50 GMT LOG: database system was not properly shut down; automatic recovery in progress LOG: redo starts at C/FD360978 FATAL: the database system is starting up FATAL: the database system is starting up [snip] FATAL: the database system is starting up FATAL: the database system is starting up FATAL: the database system is starting up FATAL: the database system is starting up LOG: received smart shutdown request LOG: shutting down LOG: database system is shut down LOG: database system was shut down in recovery at 2013-11-19 10:22:59 GMT LOG: database system was not properly shut down; automatic recovery in progress LOG: redo starts at C/FD360978 -- Gary Stainburn Group I.T. Manager Ringways Garages http://www.ringways.co.uk -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
