Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VimTD-0008Es-KC for pgsql-admin@arkaria.postgresql.org; Tue, 19 Nov 2013 14:40:03 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1VimTD-0005zs-48 for pgsql-admin@arkaria.postgresql.org; Tue, 19 Nov 2013 14:40:03 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VimTC-0005zg-CA for pgsql-admin@postgresql.org; Tue, 19 Nov 2013 14:40:02 +0000 Received: from hub.ringways.co.uk ([88.211.105.30] helo=mail.ringways.co.uk) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VimTA-00012T-2c for pgsql-admin@postgresql.org; Tue, 19 Nov 2013 14:40:02 +0000 Received: from eddie.ringways.co.uk ([10.1.1.115]) by mail.ringways.co.uk with esmtp (Exim 4.69) (envelope-from ) id 1VimT9-0007gU-Hd for pgsql-admin@postgresql.org; Tue, 19 Nov 2013 14:39:59 +0000 From: Gary Stainburn Organization: Ringways Garages Ltd To: pgsql-admin@postgresql.org Subject: Re: Postgresql not accessible, recovering Date: Tue, 19 Nov 2013 14:39:59 +0000 User-Agent: KMail/1.9.10 References: <201311191108.18620.gary.stainburn@ringways.co.uk> In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <201311191439.59390.gary.stainburn@ringways.co.uk> X-Pg-Spam-Score: -2.4 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org 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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin