pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Chris Fjell <cfjell@bcgsc.ca>
To: pgsql-admin@postgresql.org
Subject: restoring a database from a file copy
Date: Fri, 18 Jun 2004 16:42:18 -0700
Message-ID: <40D37DDA.5010400@bcgsc.ca> (raw)

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





view thread (2+ messages)  latest in thread

Message-ID: <40D37DDA.5010400@bcgsc.ca>
Permalink:  ../40D37DDA.5010400@bcgsc.ca/
Also on:    postgresql.org/message-id/40D37DDA.5010400@bcgsc.ca

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: cfjell@bcgsc.ca
  Subject: Re: restoring a database from a file copy
  In-Reply-To: <40D37DDA.5010400@bcgsc.ca>
  References: <40D37DDA.5010400@bcgsc.ca>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox