Re: Restore a database

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: Jesus Arocho <jesus_arocho(at)comcast(dot)net>
Cc: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Restore a database
Date: 2007-11-05 16:58:07
Message-ID: 20071105165807.GB17512@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sun, Nov 04, 2007 at 03:52:51PM -0500, 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.

The debian packages tend to leave behind old versions of pg_dump and
such to help with situations like this, though 7.1 is from quite a
while ago...

Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent revolution inevitable.
> -- John F Kennedy

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2007-11-05 16:58:13 Re: Restore a database
Previous Message Kynn Jones 2007-11-05 16:50:47 How to temporarily disable a table's FK constraints?