pg_stop_backup is not archiving latest transaction log from pg_xlog directory

From: girish R G peetle <giri(dot)anamika0(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: pg_stop_backup is not archiving latest transaction log from pg_xlog directory
Date: 2013-06-19 08:32:16
Message-ID: CAKKd066y9ubTwd8c2e9cgqN+PZ0g_EunkNyoi1Z9YDDb1d_wGA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Raghavendra 2013-06-19 09:04:48 Re: pg_stop_backup is not archiving latest transaction log from pg_xlog directory
Previous Message Albe Laurenz 2013-06-19 07:41:05 Re: WAL scenario valid?