Re: [ADMIN] pg_xlogfile_name for PostgreSQL 8.0

2013-06-25 Thread Albe Laurenz
girish R G peetle wrote: > backup_label (after execting pg_start_backup) will have the start > transaction log file information, I > can this use this file to extract the current time line ID. > Also I guess the time line ID will be changed only when server is recovered. > So, I can safely use t

Re: [ADMIN] pg_xlogfile_name for PostgreSQL 8.0

2013-06-25 Thread girish R G peetle
Thanks Laurenz Albe. backup_label (after execting pg_start_backup) will have the start transaction log file information, I can this use this file to extract the current time line ID. Also I guess the time line ID will be changed only when server is recovered. So, I can safely use the same Time Lin

Re: [ADMIN] pg_xlogfile_name for PostgreSQL 8.0

2013-06-25 Thread Albe Laurenz
girish R G peetle wrote: > On PostgreSQL 8.0, I need to convert output of pg_start_backup / > pg_stop_backup to transaction log > file name. In the the latest versions we have pg_xlogfile_name function to do > this, but 8.0 there is > not function to achieve this. > > Is it possible to export pg

[ADMIN] pg_xlogfile_name for PostgreSQL 8.0

2013-06-25 Thread girish R G peetle
Hi , On PostgreSQL 8.0, I need to convert output of pg_start_backup / pg_stop_backup to transaction log file name. In the the latest versions we have pg_xlogfile_name function to do this, but 8.0 there is not function to achieve this. Is it possible to export pg_xlogfile_name function from the lat