Re: Restoring a database from a file system snapshot

Поиск
Список
Период
Сортировка
От Joao Ferreira gmail
Тема Re: Restoring a database from a file system snapshot
Дата
Msg-id 1219860503.22189.6.camel@jmf-ubuntu
обсуждение исходный текст
Ответ на Restoring a database from a file system snapshot  (William Garrison <postgres@mobydisk.com>)
Список pgsql-general
> Any suggestions?  Is my procedure correct?  Would I need to also copy
> the transaction logs or something like that?

the 'by the book' procedure for this operation is to use

pg_dumpall ......... > dump_file.sql

and later

psql -f dump_file.sql postgres



pg_dumpall gives you a transaction aware dump.

I'm not sure how you'dd do about that old snapshot, sorry.

joao


>


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

Предыдущее
От: William Garrison
Дата:
Сообщение: Restoring a database from a file system snapshot
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Restoring a database from a file system snapshot