Re: Slot issues

Hi,

As I just wrote:
> On Mon, 15 Oct 2018 at 02:40, Andres Freund <andres@anarazel.de> wrote:
> > Please try to quote properly.

On 2018-10-15 02:45:51 +0530, bhargav kamineni wrote:
> Yeah i have used rsync , Got it now will increase the max_replication_slots
> to high enough , Thank you Andres Freund :-)

You probably afterwards want to drop those slots from the new standby.
See the following section from the docs:

https://www.postgresql.org/docs/current/static/continuous-archiving.html#BACKUP-LOWLEVEL-BASE-BACKUP-DATA
"It is often a good idea to also omit from the backup the files within the cluster's pg_replslot/ directory, so that
replicationslots that exist on the master do not become part of the backup. Otherwise, the subsequent use of the backup
tocreate a standby may result in indefinite retention of WAL files on the standby, and possibly bloat on the master if
hotstandby feedback is enabled, because the clients that are using those replication slots will still be connecting to
andupdating the slots on the master, not the standby. Even if the backup is only intended for use in creating a new
master,copying the replication slots isn't expected to be particularly useful, since the contents of those slots will
likelybe badly out of date by the time the new master comes on line."
 

Greetings,

Andres Freund