Hi
Postges 9.0 WAL SEGEMENT SIZE is set as 128 GB for default server
configuration. But the WAL Segment files are of 16MB only. This issue is
not there in 9.1AS or any other non-advanced Postgres server versions. Is
it a bug in 9.0 AS ?
Thanks
Girish
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 l
iving
transaction log files from pg_xlog directory after pg_stop_backup) ?
Thanks
Girish
On Wed, Jun 19, 2013 at 3:01 PM, Simon Riggs wrote:
> On 19 June 2013 09:32, girish R G peetle wrote:
>
> > Is there a way to switch the current transaction log file in Postgres
> 8.0 ?
On Wed, Jun 19, 2013 at 4:32 PM, Albe Laurenz wrote:
> 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.
> Du
Thanks a lot Laurenz Albe.
On Wed, Jun 19, 2013 at 6:16 PM, Albe Laurenz wrote:
> 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
> ref
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
Line ID extracted from
backup_label to formulate the transaction log file from the output of
pg_stop_backup also.
On Tue, Jun 25, 2013 at 3:15 PM, Albe Laurenz wrote:
> girish R G peetle wrote:
> > On PostgreSQL 8.0, I need to convert output of pg_start_backup /
> pg_stop_backup to