Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group