Re: Restore a database

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
---------------------------------------------------------------