Re: lost database

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: lost database
Дата
Msg-id 200312091818.55401.peter_e@gmx.net
обсуждение исходный текст
Ответ на Re: lost database  (Jodi Kanter <jkanter@virginia.edu>)
Список pgsql-admin
Jodi Kanter wrote:
> I am not sure I understand your question. why does the type of backup
> matter? It is a tape backup and it includes the entire /var directory
> where the pgsql directory exists.

That was the missing piece of information.

> I am trying to determine what
> particular files need to be retrieved in order to restore the
> database as it existed yesterday. Is this possible?
> Thanks for the assistance.

Shut down the server if still running, put back the entire data
directory (probably /var/lib/pgsql in your case), and start the server.
Partial restoration is not possibly from file system backup.


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

Предыдущее
От: Joe Conway
Дата:
Сообщение: Re: Postgres grabbing an old shared object
Следующее
От: Joe Conway
Дата:
Сообщение: Re: lost database