Re: reconstructing database

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: akanksha kulkarni <akanksha_kul(at)yahoo(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: reconstructing database
Date: 2004-09-30 16:30:09
Message-ID: 17871.1096561809@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

akanksha kulkarni <akanksha_kul(at)yahoo(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Mike Darretta 2004-09-30 16:43:12 Re: Data Partition is Growing
Previous Message JEDIDIAH 2004-09-30 15:54:50 Re: [HACKERS] Point in Time Recovery