Re: Restore a database

Поиск
Список
Период
Сортировка
От Raymond O'Donnell
Тема Re: Restore a database
Дата
Msg-id 472E3FFD.3050708@iol.ie
обсуждение исходный текст
Ответ на Restore a database  (Jesus Arocho <jesus_arocho@comcast.net>)
Список 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@iol.ie
---------------------------------------------------------------

В списке pgsql-general по дате отправления:

Предыдущее
От: Jesus Arocho
Дата:
Сообщение: Restore a database
Следующее
От: "Merlin Moncure"
Дата:
Сообщение: Re: What makes a Postgres DBA?