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

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 <mailto:mania...@gmail.com>> 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: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 <mailto:mania...@gmail.com>> 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,

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 <mailto:mania...@gmail.com>> wrote: Hi everyone, Questions about pg_xlogs again... I have two Postgresql 9.1 servers in a master/slave stream replication (hot_standby). Psql01 (m

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 <mailto:mania...@gmail.com>> wrote: Hi everyone, Questions about pg_xlogs again... I have two Postgresql 9.1 servers in a master/slave stream replication (hot_standby). Psql0

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 <mailto:mania...@gmail.com>>: 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

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 a

[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