DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type:content-transfer-encoding;
	b=TUgnrZS+9LC0YlBBfdKjkQPewNtvsFJH9u4J2UCr441ycZWqvdcubMYjYUAaszMEgy
	43P00yUBgo7pjjMbkgJJBGer5/h+7/udRO7fihPc/Zmk8F68xkUoLAZcjsFPvsvjBnnI
	+tSmovn+TxUdCjbc3LhanjFNWIUhy+QJzB0UI=
MIME-Version: 1.0
In-Reply-To: 
 <FA20D4C4FEBFD148B1C0CB09913825FC01EBD52E65@XCH-SW-06V.sw.nos.boeing.com>
References: <29452.1265140359@sss.pgh.pa.us>
	<FA20D4C4FEBFD148B1C0CB09913825FC01EBD52D8E@XCH-SW-06V.sw.nos.boeing.com>
	<29816.1265141665@sss.pgh.pa.us>
	<FA20D4C4FEBFD148B1C0CB09913825FC01EBD52E65@XCH-SW-06V.sw.nos.boeing.com>
Date: Tue, 2 Feb 2010 16:17:07 -0700
Message-ID: <dcc563d11002021517g50824974r21bb271845c8682a@mail.gmail.com>
Subject: Re: Startup proc 30595 exited with status 512 - abort and
	FATAL 2: XLogFlush
From: Scott Marlowe <scott.marlowe@gmail.com>
To: "Wang, Mary Y" <mary.y.wang@boeing.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>,
	"pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

On Tue, Feb 2, 2010 at 3:29 PM, Wang, Mary Y <mary.y.wang@boeing.com> wrote=
:
> Thanks Tom.
>
> After talking to my co-worker, we decided to go to the last backup (we us=
ed the pg_dumpall -c command).
> However, when I did enter "psql -f /usr/pgsql/backups/31.bak template1" t=
o restore the database, I got "
> psql: connectDBStart() -- connect() failed: No such file or directory
> =A0 =A0 =A0 =A0Is the postmaster running locally
> =A0 =A0 =A0 =A0and accepting connections on Unix socket '/tmp/.s.PGSQL.54=
32'?
> ".
> I can't start my postmaster. =A0So how would I restore my last good backu=
p?

The normal way is to drop the old cluster and create a new one.  I'm
not entirely sure how to do that on something as old as RHEL 2.1.  The
normal way would be to mv or rm -rf the /var/lib/pgsql/data dir and
run initdb again.  something like:

sudo /etc/init.d/pgsql stop
sudo rm -rf /var/lib/pgsql/data/*
sudo -u postgres initdb -D /var/lib/pgsql/data
sudo /etc/init.d/pgsql start

or something like that.