Re: pg_stop_backup is not archiving latest transaction log from pg_xlog directory - Mailing list pgsql-admin

From Raghavendra
Subject Re: pg_stop_backup is not archiving latest transaction log from pg_xlog directory
Date
Msg-id CA+h6AhiGmDNyUV-GFGDZ36sPeGMpiKFkbQSr+LvwMpdJDuZVvQ@mail.gmail.com
Whole thread Raw
In response to pg_stop_backup is not archiving latest transaction log from pg_xlog directory  (girish R G peetle <giri.anamika0@gmail.com>)
List 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 by date:

Previous
From: girish R G peetle
Date:
Subject: pg_stop_backup is not archiving latest transaction log from pg_xlog directory
Next
From: Simon Riggs
Date:
Subject: Re: pg_stop_backup is not archiving latest transaction log from pg_xlog directory