Re: lost database

Поиск
Список
Период
Сортировка
От Joe Conway
Тема Re: lost database
Дата
Msg-id 3FD60426.5040306@joeconway.com
обсуждение исходный текст
Ответ на 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. 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.

Restore the entire $PGDATA directory. If this is a default Red Hat
system that would be something like /var/lib/pgsql/data

HTH,

Joe



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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: lost database
Следующее
От: Teodor Sigaev
Дата:
Сообщение: Re: Full textsearch & gist (fwd)