backups and WAL

Поиск
Список
Период
Сортировка
От pablobarbachano@yahoo.es
Тема backups and WAL
Дата
Msg-id 20040827080307.GA7494@vayven.info
обсуждение исходный текст
Ответы Re: backups and WAL  (Gaetano Mendola <mendola@bigfoot.com>)
Re: backups and WAL  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
Hi, first of all thanks for postgresql, it has never given a problem
and is performing great.

Now my question: my employer wants to do backups every 12 hours, and
save the logs evry 2 hours to... Can I simply save the logs
(cp pg_xlog/* ...) or do I need something more elaborate?

Now in a restore situation ... I restore the database, and then what?
put the saved files back in the pg_xlog/ dir, then start postmaster
and magically all starts working? Am I correct or completely insane?
The documentation is not clear in that aspect...

Thanks in advance,
Pablo.

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: regression database
Следующее
От: Gaetano Mendola
Дата:
Сообщение: Re: backups and WAL