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

[Raghavendra <raghavendra.rao@xxxxxxxxxxxxxxxx>]

On Wed, Jun 19, 2013 at 2:02 PM, girish R G peetle <giri.anamika0@xxxxxxxxx> 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 ?

http://www.postgresql.org/docs/8.0/static/sql-checkpoint.html

 

---

Regards,

Raghavendra

EnterpriseDB Corporation

Blog: http://raghavt.blogspot.com/