Thread: Restore a database
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. Thanks.
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 ---------------------------------------------------------------
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@svana.org> http://svana.org/kleptog/ > Those who make peaceful revolution impossible will make violent revolution inevitable. > -- John F Kennedy
Attachment
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. > > Thanks. > > ---------------------------(end of broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq -- Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/ > Those who make peaceful revolution impossible will make violent revolution inevitable. > -- John F Kennedy