Re: [HACKERS] replication slots replicated to standbys?

2016-08-21 Thread Craig Ringer
On 22 August 2016 at 10:31, Michael Paquier wrote: > On Sun, Aug 21, 2016 at 1:24 PM, Craig Ringer > wrote: > > On 21 Aug 2016 12:36 AM, "Bruce Momjian" wrote: > >> Seems like another good idea to use pg_basebackup rather than manually > >> doing base backups; Magnus has been saying this for a

Re: [HACKERS] replication slots replicated to standbys?

2016-08-21 Thread Michael Paquier
On Sun, Aug 21, 2016 at 1:35 AM, Bruce Momjian wrote: > On Sat, Aug 20, 2016 at 01:43:42PM +0900, Michael Paquier wrote: >> Note as well that pg_basebackup omits its content and creates an empty >> directory. > > Are there any other error-prone things copied from the master? The contents of pg_sn

Re: [HACKERS] replication slots replicated to standbys?

2016-08-21 Thread Michael Paquier
On Sun, Aug 21, 2016 at 1:24 PM, Craig Ringer wrote: > On 21 Aug 2016 12:36 AM, "Bruce Momjian" wrote: >> Seems like another good idea to use pg_basebackup rather than manually >> doing base backups; Magnus has been saying this for a while. > > The main time that's an issue is when you're rsync'

Re: [HACKERS] replication slots replicated to standbys?

2016-08-20 Thread Craig Ringer
On 21 Aug 2016 12:36 AM, "Bruce Momjian" wrote: > > On Sat, Aug 20, 2016 at 01:43:42PM +0900, Michael Paquier wrote: > > On Sat, Aug 20, 2016 at 1:39 PM, Bruce Momjian wrote: > > > Someone reported that a replication slot that existed at the time a base > > > backup was done on the master was cop

Re: [HACKERS] replication slots replicated to standbys?

2016-08-20 Thread Bruce Momjian
On Sat, Aug 20, 2016 at 01:43:42PM +0900, Michael Paquier wrote: > On Sat, Aug 20, 2016 at 1:39 PM, Bruce Momjian wrote: > > Someone reported that a replication slot that existed at the time a base > > backup was done on the master was copied to the standby. Because they > > didn't realize it, th

Re: [HACKERS] replication slots replicated to standbys?

2016-08-19 Thread Michael Paquier
On Sat, Aug 20, 2016 at 1:39 PM, Bruce Momjian wrote: > Someone reported that a replication slot that existed at the time a base > backup was done on the master was copied to the standby. Because they > didn't realize it, their WAL was not being recycled on the standby. > > Is that possible? Is