Re: Convert v7.0.2-2c1 DB

From: "Patrick S(dot) Riedel" <priedel(at)asllc(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Convert v7.0.2-2c1 DB
Date: 2003-02-12 07:29:40
Message-ID: 1045034979.30841.194.camel@DELTA
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Tue, 2003-02-11 at 23:11, Tom Lane wrote:
> Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> writes:
> > On Tue, 2003-02-11 at 17:27, Patrick S. Riedel wrote:
> >> I have a client with a v7.0.2-2c1 database stored on media. The
> >> database files were stored raw, not dumped. Their current pgsql version
> >> is 7.1; they do not have v7.0.2-2c1 installed anywhere.
>
> > Lordy, that's a fine mess you've got there.
>
> Yup...
>
> > As far as what version of 7.0.x to use, I don't recognize that release
> > so it could very well be a release candidate version, but might also be
> > a vendor/rpm/debian style version tag.
>
> Any released 7.0.* version should be disk-level-compatible. Given that
> this is a 7.0.2-something and not a 7.0-something I don't think you need
> to worry that it might be a 7.0 prerelease. So as long as you have the
> complete $PGDATA directory tree (not a subset that omits pg_log, for
> example) I think you should be able to compile any 7.0.* release and
> fire it up against that directory tree. Then pg_dump and away you go.
>
> > In any/all cases, always copy the data over, never do anything on the
> > original files.
>
> Check, always keep a pristine copy until you *know* you have a working,
> cross-checked, backed-up database in a later version...
>
> regards, tom lane

Thanks for the replies!

I was able to find ye ol' v7.0.2-2c1 and installed on a test machine.
Dumped db, all is well.

--
Patrick S. Riedel
ANALYTICAL SERVICES, LLC
970.481.1963

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2003-02-12 08:04:07 Re: server won't shutdown
Previous Message Oliver Elphick 2003-02-12 06:47:52 Re: Create Perl Support