Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VimP2-00084p-6E for pgsql-admin@arkaria.postgresql.org; Tue, 19 Nov 2013 14:35:44 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1VimP1-0002lc-AD for pgsql-admin@arkaria.postgresql.org; Tue, 19 Nov 2013 14:35:43 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VimOz-0002i6-2Z for pgsql-admin@postgresql.org; Tue, 19 Nov 2013 14:35:41 +0000 Received: from proofpoint1.mail.rice.edu ([128.42.201.100] helo=pp1.rice.edu) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VimOr-000115-94 for pgsql-admin@postgresql.org; Tue, 19 Nov 2013 14:35:40 +0000 Received: from pps.filterd (pp1.rice.edu [127.0.0.1]) by pp1.rice.edu (8.14.5/8.14.5) with SMTP id rAJEWPpZ027615; Tue, 19 Nov 2013 08:35:30 -0600 Received: from mh1.mail.rice.edu (mh1.mail.rice.edu [128.42.201.20]) by pp1.rice.edu with ESMTP id 1g53xa1yth-1; Tue, 19 Nov 2013 08:35:30 -0600 X-Virus-Scanned: by amavis-2.7.0 at mh1.mail.rice.edu, auth channel X-SMTP-Auth: no X-SMTP-Auth: no X-SMTP-Auth: no Received: from aart.rice.edu (aart.rice.edu [168.7.56.48]) by mh1.mail.rice.edu (Postfix) with ESMTP id E754B46025A; Tue, 19 Nov 2013 08:35:29 -0600 (CST) Received: by aart.rice.edu (Postfix, from userid 18612) id DC44C1002D0; Tue, 19 Nov 2013 08:35:29 -0600 (CST) Date: Tue, 19 Nov 2013 08:35:29 -0600 From: "ktm@rice.edu" To: bricklen Cc: Gary Stainburn , "pgsql-admin@postgresql.org" Subject: Re: Postgresql not accessible, recovering Message-ID: <20131119143529.GP28440@aart.rice.edu> References: <201311191108.18620.gary.stainburn@ringways.co.uk> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.20 (2009-12-10) X-Proofpoint-Spam-Details: rule=notspam policy=default score=0 kscore.is_bulkscore=0 kscore.compositescore=0 circleOfTrustscore=0 compositescore=0.951343242354756 urlsuspect_oldscore=0.951343242354756 suspectscore=0 recipient_domain_to_sender_totalscore=0 phishscore=0 bulkscore=0 kscore.is_spamscore=0 recipient_to_sender_totalscore=0 recipient_domain_to_sender_domain_totalscore=498 rbsscore=0.951343242354756 spamscore=0 recipient_to_sender_domain_totalscore=0 urlsuspectscore=0.9 adultscore=0 classifier=spam adjust=0 reason=mlx scancount=1 engine=7.0.1-1305240000 definitions=main-1311190069 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 Tue, Nov 19, 2013 at 06:25:44AM -0800, bricklen wrote: > On Tue, Nov 19, 2013 at 3:08 AM, Gary Stainburn < > gary.stainburn@ringways.co.uk> wrote: > > > > > Doing a 'ps ax' found the following output. Can anyone help on what I > > need to > > do next as Google only returns posts relating to replication which I don't > > use. > > > > -bash-4.2$ ps ax|grep post > > > > 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? Hi Gary, I had something similar happen when a recovery.conf file was mistakenly set up on the master. It hit after a "simple" restart of the DB. It was a silly problem, but I had not seen it before and it was not on my problem check list -- something to check. Regards, Ken -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin