| From: | Raymond O'Donnell <rod(at)iol(dot)ie> |
|---|---|
| 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-04 21:56:13 |
| Message-ID: | 472E3FFD.3050708@iol.ie |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)iol(dot)ie
---------------------------------------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Merlin Moncure | 2007-11-05 01:04:24 | Re: What makes a Postgres DBA? |
| Previous Message | Jesus Arocho | 2007-11-04 20:52:51 | Restore a database |