From: | Chris Fjell <cfjell(at)bcgsc(dot)ca> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | restoring a database from a file copy |
Date: | 2004-06-18 23:42:18 |
Message-ID: | 40D37DDA.5010400@bcgsc.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Can a database system be restored just from the data under the
installation directory?
I backed-up my database using "rsync /var/lib/pgsql <dest_directory>"
Then I upgraded my rpms from 7.3.4 to 7.4. Then I tried to start the
server as usual and it complained about version conflict (of course).
I removed the 7.4 rpms and went back to 7.3.4 and restared server.
My data are gone - only the template tables are listed.
I copied back from my file backup and this, much to my horror, did not
restore my database - it's as if the tables are all gone, but the file
sizes indicate the data are there.
Any way to recreate a catalog (or whatever) from the data?
The server seemed to be down when I copied - can't see what I could have
done to corrupt the files under /var/lib/pgsql/data/
I couldn't do a pg_dump due to bad OIDs - this was the motivation for
the upgrade - so I seem to have lost everything.
Any thoughts?
--
Chris Fjell
From | Date | Subject | |
---|---|---|---|
Next Message | Adam Smith | 2004-06-19 12:12:25 | How do I clean up a site from an old version to install anew |
Previous Message | Tom Lane | 2004-06-18 23:36:17 | Re: bad data with Foreign Key constraint |