Re: [GENERAL] pg_xlog on a hot_stanby slave

2015-06-29 Thread Xavier 12
On 29/06/2015 11:38, Stéphane Schildknecht wrote: On 16/06/2015 10:55, Xavier 12 wrote: Hi everyone, Questions about pg_xlogs again... I have two Postgresql 9.1 servers in a master/slave stream replication (hot_standby). Psql01 (master) is backuped with Barman and pg_xlogs is correctly purge

Re: [GENERAL] pg_xlog on a hot_stanby slave

2015-06-29 Thread Stéphane Schildknecht
On 16/06/2015 10:55, Xavier 12 wrote: > Hi everyone, > > Questions about pg_xlogs again... > I have two Postgresql 9.1 servers in a master/slave stream replication > (hot_standby). > > Psql01 (master) is backuped with Barman and pg_xlogs is correctly > purged (archive_command is used). > > Hower

Re: [GENERAL] pg_xlog on a hot_stanby slave

2015-06-29 Thread Xavier 12
On 19/06/2015 03:31, Sameer Kumar wrote: On Thu, 18 Jun 2015 15:17 Xavier 12 > wrote: On 18/06/2015 04:00, Sameer Kumar wrote: On Wed, 17 Jun 2015 15:24 Xavier 12 mailto:mania...@gmail.com>> wrote: On 17/06/2015 03:17, Sameer Kumar wrot

Re: [GENERAL] pg_xlog on a hot_stanby slave

2015-06-18 Thread Sameer Kumar
On Thu, 18 Jun 2015 15:17 Xavier 12 wrote: On 18/06/2015 04:00, Sameer Kumar wrote: On Wed, 17 Jun 2015 15:24 Xavier 12 wrote: On 17/06/2015 03:17, Sameer Kumar wrote: On Tue, 16 Jun 2015 16:55 Xavier 12 wrote: Hi everyone, Questions about pg_xlogs again... I have two Postgresql 9.1

Re: [GENERAL] pg_xlog on a hot_stanby slave

2015-06-18 Thread Xavier 12
On 18/06/2015 04:00, Sameer Kumar wrote: On Wed, 17 Jun 2015 15:24 Xavier 12 > wrote: On 17/06/2015 03:17, Sameer Kumar wrote: On Tue, 16 Jun 2015 16:55 Xavier 12 mailto:mania...@gmail.com>> wrote: Hi everyone, Questions abo

Re: [GENERAL] pg_xlog on a hot_stanby slave

2015-06-17 Thread Sameer Kumar
On Wed, 17 Jun 2015 15:24 Xavier 12 wrote: On 17/06/2015 03:17, Sameer Kumar wrote: On Tue, 16 Jun 2015 16:55 Xavier 12 wrote: Hi everyone, Questions about pg_xlogs again... I have two Postgresql 9.1 servers in a master/slave stream replication (hot_standby). Psql01 (master) is backuped w

Re: [GENERAL] pg_xlog on a hot_stanby slave

2015-06-17 Thread Xavier 12
On 17/06/2015 03:17, Sameer Kumar wrote: On Tue, 16 Jun 2015 16:55 Xavier 12 > wrote: Hi everyone, Questions about pg_xlogs again... I have two Postgresql 9.1 servers in a master/slave stream replication (hot_standby). Psql01 (master) is back

Re: [GENERAL] pg_xlog on a hot_stanby slave

2015-06-17 Thread Xavier 12
On 17/06/2015 02:44, Venkata Balaji N wrote: On Tue, Jun 16, 2015 at 6:55 PM, Xavier 12 > wrote: Hi everyone, Questions about pg_xlogs again... I have two Postgresql 9.1 servers in a master/slave stream replication (hot_standby). Psql01 (master)

Re: [GENERAL] pg_xlog on a hot_stanby slave

2015-06-17 Thread Xavier 12
On 16/06/2015 22:28, Guillaume Lelarge wrote: 2015-06-16 15:55 GMT+02:00 Xavier 12 >: I don't think so. There is no archive_command and the master doesn't ship its wal here. But how can I check that ? What's the complete path to the directory on the sal

Re: [GENERAL] pg_xlog on a hot_stanby slave

2015-06-16 Thread Sameer Kumar
On Tue, 16 Jun 2015 16:55 Xavier 12 wrote: Hi everyone, Questions about pg_xlogs again... I have two Postgresql 9.1 servers in a master/slave stream replication (hot_standby). Psql01 (master) is backuped with Barman and pg_xlogs is correctly purged (archive_command is used). Hower, Psql02 (sl

Re: [GENERAL] pg_xlog on a hot_stanby slave

2015-06-16 Thread Venkata Balaji N
On Tue, Jun 16, 2015 at 6:55 PM, Xavier 12 wrote: > Hi everyone, > > Questions about pg_xlogs again... > I have two Postgresql 9.1 servers in a master/slave stream replication > (hot_standby). > > Psql01 (master) is backuped with Barman and pg_xlogs is correctly > purged (archive_command is used)

Re: [GENERAL] pg_xlog on a hot_stanby slave

2015-06-16 Thread Guillaume Lelarge
2015-06-16 15:55 GMT+02:00 Xavier 12 : > I don't think so. There is no archive_command and the master doesn't > ship its wal here. > But how can I check that ? > > What's the complete path to the directory on the salve that contains 951 files? what does PostgreSQL say on its log files? 2015-06-16

Re: [GENERAL] pg_xlog on a hot_stanby slave

2015-06-16 Thread Xavier 12
I don't think so. There is no archive_command and the master doesn't ship its wal here. But how can I check that ? 2015-06-16 12:41 GMT+02:00 Guillaume Lelarge : > Le 16 juin 2015 10:57 AM, "Xavier 12" a écrit : >> >> Hi everyone, >> >> Questions about pg_xlogs again... >> I have two Postgresql 9

Re: [GENERAL] pg_xlog on a hot_stanby slave

2015-06-16 Thread Guillaume Lelarge
Le 16 juin 2015 10:57 AM, "Xavier 12" a écrit : > > Hi everyone, > > Questions about pg_xlogs again... > I have two Postgresql 9.1 servers in a master/slave stream replication > (hot_standby). > > Psql01 (master) is backuped with Barman and pg_xlogs is correctly > purged (archive_command is used).

[GENERAL] pg_xlog on a hot_stanby slave

2015-06-16 Thread Xavier 12
Hi everyone, Questions about pg_xlogs again... I have two Postgresql 9.1 servers in a master/slave stream replication (hot_standby). Psql01 (master) is backuped with Barman and pg_xlogs is correctly purged (archive_command is used). Hower, Psql02 (slave) has a huge pg_xlog (951 files, 15G for 7