Re: pg_stop_backup is not archiving latest transaction log from pg_xlog directory

Поиск
Список
Период
Сортировка
От Raghavendra
Тема Re: pg_stop_backup is not archiving latest transaction log from pg_xlog directory
Дата
Msg-id CA+h6AhiGmDNyUV-GFGDZ36sPeGMpiKFkbQSr+LvwMpdJDuZVvQ@mail.gmail.com
обсуждение исходный текст
Ответ на pg_stop_backup is not archiving latest transaction log from pg_xlog directory  (girish R G peetle <giri.anamika0@gmail.com>)
Список pgsql-admin
On Wed, Jun 19, 2013 at 2:02 PM, girish R G peetle <giri.anamika0@gmail.com> wrote:
Hi 
The question is regrading PostgreSQL 8.0.26 version on Linux platform. I know that 8.0 version is no longer supported. But one of our customer is using this version. 
We are using File System based backup method to protect PostgreSQL server. 

In PostgreSQL 8.2 and above versions, I can see that latest transaction log will be archived when pg_stop_backup is executed. 

But in PostgreSQL 8.0 version this is not happening. A transaction log file gets archived only when it is completely filled. 
Due to this behavior, the changes made to the server during pg_start_backup and pg_stop_backup won't be captured in the archived transaction log.  
Is there a way to switch the current transaction log file in Postgres 8.0 ? 

Thanks
Girish

Can you try CHECKPOINT before pg_stop_backup() and see whether it meets your requirement ?

 
---
Regards,
Raghavendra
EnterpriseDB Corporation

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

Предыдущее
От: girish R G peetle
Дата:
Сообщение: pg_stop_backup is not archiving latest transaction log from pg_xlog directory
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: pg_stop_backup is not archiving latest transaction log from pg_xlog directory