DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:user-agent:mime-version:to:subject:references
	:in-reply-to:content-type:content-transfer-encoding;
	b=oNLDd9nCgChjle9V4W12dg2qsa1XCEHSAQ5+zeO4PGDiohDY5QwAeSqtqMYCBrwzmW
	ODqfq0B0M0+7AegnVQrRc3tIqoVit7JnzaVT0/vW+2wVjlSTylJaxYGQnQ7xDEHLTWOO
	RvSR/DgbmAm+Bfl/AN0SGeCdDA61sR2+KtjyM=
Message-ID: <4B806560.2000104@gmail.com>
Date: Sat, 20 Feb 2010 23:42:40 +0100
From: Andrzej Zawadzki <zawadaa@gmail.com>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US;
	rv:1.9.1.7) Gecko/20100215 Lightning/1.0b1 Icedove/3.0.1
MIME-Version: 1.0
To: pgsql-admin@postgresql.org
Subject: Re: upgrading, but learned about pg_dumpall too late
References: <4B805376.80705@FastMail.fm>
In-Reply-To: <4B805376.80705@FastMail.fm>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

On 20.02.2010 22:26, Richard O. Hammer wrote:
> Hello,
>
Hi!
> I hope someone can tell me how to recover my database tables.  I
> recently upgraded to a new Linux server.  First I saved a copy of my
> /var/lib/pgsql/data/*, which was created with PG version 7.4.  On the
> new Linux server I have PG version 8.1.11.
>
> But now, trying use my old tables, I discover that I should have saved
> the tables with the pg_dumpall command before I abandoned the
> version-7.4 Postgres server.  Unfortunately I did not know about
> pg_dumpall.
>
> So now I'm wondering if there is a way I can read and update my
> version-7.4 data directory with my version-8.1 postmaster.
>
> Here is one thing I've tried:
>  bash-3.2$ pg_ctl start -D /var/lib/pgsql/old/data
>  FATAL:  database files are incompatible with server
>  DETAIL:  The data directory was initialized by PostgreSQL version
> 7.4, which is not compatible with this version 8.1.1
>
> Any suggestions will be appreciated.
>
Downgrade to 7.4
Dump
Upgrade
Restore

-- 
Andrzej Zawadzki