[ADMIN] pg_stop_backup is not archiving latest transaction log from pg_xlog directory

2013-06-19 Thread girish R G peetle
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

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

2013-06-19 Thread Raghavendra
On Wed, Jun 19, 2013 at 2:02 PM, girish R G peetle giri.anami...@gmail.comwrote: 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

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

2013-06-19 Thread Simon Riggs
On 19 June 2013 09:32, girish R G peetle giri.anami...@gmail.com wrote: Is there a way to switch the current transaction log file in Postgres 8.0 ? No, that was an addition to 8.2 Suggest that you send more data until the WAL file switches. You should upgrade with some urgency. -- Simon

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

2013-06-19 Thread girish R G peetle
On Wed, Jun 19, 2013 at 4:32 PM, Albe Laurenz laurenz.a...@wien.gv.atwrote: girish R G peetle wrote: @Albe Even I was thinking to backup the transaction log files under pg_xlog directory. But my concern is, will it lead some kind of error or inconsistency ? No. During recovery,

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

2013-06-19 Thread Albe Laurenz
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

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

2013-06-19 Thread girish R G peetle
Thanks a lot Laurenz Albe. On Wed, Jun 19, 2013 at 6:16 PM, Albe Laurenz laurenz.a...@wien.gv.atwrote: 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