Re: reconstructing database - Mailing list pgsql-admin

From Tom Lane
Subject Re: reconstructing database
Date
Msg-id 17871.1096561809@sss.pgh.pa.us
Whole thread Raw
In response to reconstructing database  (akanksha kulkarni <akanksha_kul@yahoo.com>)
List pgsql-admin
akanksha kulkarni <akanksha_kul@yahoo.com> writes:
> Is there any way to reconstruct database from data
> files that are present in
> /var/lib/pgsql/data/<database oid folders>

> Actually I upgraded to new version of postgres (7.4)
> but again reverted back to older version (7.2) after
> uninstalling new version.

That alone would not have broken your data, because the new version
would have refused to start in an older data directory, and so it would
not have modified the existing files.  I think you are neglecting to
tell us what you actually did.

            regards, tom lane

pgsql-admin by date:

Previous
From: akanksha kulkarni
Date:
Subject: reconstructing database
Next
From: Mike Darretta
Date:
Subject: Re: Data Partition is Growing