Postgres Pro
Downloads
Home   >   mailing lists

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

From Albe Laurenz
Subject Re: pg_stop_backup is not archiving latest transaction log from pg_xlog directory
Date
Msg-id A737B7A37273E048B164557ADEF4A58B17BB4633@ntex2010a.host.magwien.gv.at
Whole thread Raw
In response to Re: pg_stop_backup is not archiving latest transaction log from pg_xlog directory  (girish R G peetle <giri.anamika0@gmail.com>)
Responses Re: pg_stop_backup is not archiving latest transaction log from pg_xlog directory  (girish R G peetle <giri.anamika0@gmail.com>)
List pgsql-admin
Tree view 
girish R G peetle wrote:
> I was wondering if I can use the modified version of your solution.
> 
>  1. Convert output of pg_stop_backup to transaction log file name. (This refers to the latest active
> transaction log file)
>  2. If we are able to see this file under archive(WAL) directory, backup this file from this
> directory.
>  3. If the file is not found under archive(WAL) directory, backup this file form pg_xlog directory.

That should work just fine.

Yours,
Laurenz Albe

pgsql-admin by date:

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