Re: Restore a database - Mailing list pgsql-general

From Raymond O'Donnell
Subject Re: Restore a database
Date
Msg-id 472E3FFD.3050708@iol.ie
Whole thread Raw
In response to Restore a database  (Jesus Arocho <jesus_arocho@comcast.net>)
List pgsql-general
On 04/11/2007 20:52, Jesus Arocho wrote:
> Ok, I committed the worst mistake in db admin.  I upgraded to 8.1 on my debian
> server but forgot to backup one of the databases.  The 7.1 directory is still
> there.  I would like a list of options.  I am not sure that temporarily
> reinstalling 7.1 will allow access immediately or must I have to rebuild
> something.

You ought to be able to reinstall 7.1 and have it listen on a different
port - then you can do a pg_dump ... | psql ... to transfer the
database. I did that once on Windows (using the Cygwin build), and it
worked fine.

Ray.


---------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
---------------------------------------------------------------

pgsql-general by date:

Previous
From: Jesus Arocho
Date:
Subject: Restore a database
Next
From: "Merlin Moncure"
Date:
Subject: Re: What makes a Postgres DBA?