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@xxxxxx --------------------------------------------------------------- ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend