Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id DB1E89FB313 for ; Fri, 27 Jul 2007 22:22:17 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 55127-07 for ; Fri, 27 Jul 2007 22:22:09 -0300 (ADT) X-Greylist: delayed 00:06:06.255807 by SQLgrey-1.7.5 Received: from rv-out-0910.google.com (rv-out-0910.google.com [209.85.198.189]) by postgresql.org (Postfix) with ESMTP id 9E5359FA223 for ; Fri, 27 Jul 2007 22:22:14 -0300 (ADT) Received: by rv-out-0910.google.com with SMTP id f1so118240rvb for ; Fri, 27 Jul 2007 18:22:12 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=Ei5IgYPktf72/NBeyrVUlcns5cnt4ZxHD2AWihsmrfCWM5Nc4aWtQzB6AocuAl9Z6IaEP33rxKkFJfPUrjs6vKZGVWUCz88uXsjQB4uB0geODcpiWBjyapaup8z0oRvORuz41Fu4/LzqgCV2/zF74jogUu1DV5AiO9Gm3knK/aA= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=NaVig3xasWBzr2GqV/Ll39hRydvf5BvipJTdVvVwMU7hXcMzwQGHer539maE2/KzIcL3c3Huy5yI6h1SbTsQfBD4l98Ycb6O6MYVAtnapVxZEo261tlpia8zaWjUrVF6vTOZbp5kWn+aCbEdg+G2PmZzIfTDLHLFLP5eSRxIzk4= Received: by 10.141.172.6 with SMTP id z6mr1118783rvo.1185585366611; Fri, 27 Jul 2007 18:16:06 -0700 (PDT) Received: by 10.141.98.12 with HTTP; Fri, 27 Jul 2007 18:16:06 -0700 (PDT) Message-ID: Date: Fri, 27 Jul 2007 20:16:06 -0500 From: "Scott Marlowe" To: "Tena Sakai" Subject: Re: my postgres is dead. need help! Cc: pgsql-admin@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/321 X-Sequence-Number: 26302 On 7/27/07, Tena Sakai wrote: > My postgres (v 7.1.4, I think) did not come up upon reboot. > I have tried to use startup script called postgresql in > /etc/rc.d/init.d directory, but it reports FATAL when I > try to stop postmaster. PostgreSQL versions that old WILL EAT YOUR DATA. Not if, just when. If it comes back up, get a good backup and start planning your migration to something newer, prefereably 8.2.4 > LOG: redo starts at 1F8/D6060064 > FATAL: the database system is starting up This is normal. Let it finish recovery. If it logs something more fatal messages saying it couldn't startup, then it's time to restore from backups. P.s. How old is the system you're running this on? I'm guessing from around the RedHat 5 era?