Re: Slot issues
> On 14 Oct 2018, at 23:10 , Andres Freund wrote: > > If you created the new basebackup using rsync, and didn't exclude > pg_replication_slot, it'll have copied the slots from the primary. And > thus needs a high enough max_replication_slots to work with them. Thanks for pointing this out, after I’ve cleared the pg_replslot/ on the cascaded standby, it just “works” ;) signature.asc Description: Message signed with OpenPGP
Re: [External] Re: Slot issues
What was the whole point of this divergence :) We use replication slots and it is for this reason we are able to scale our applications by redirecting reads and writes backed by haproxy and pgbouncer. with the health check of replication lag. It works awesome and at a much much lower cost to what aws used to charge us for. (1 master, 3 slaves .. that goes to 7-8 during peak days) With the use of logical replication we were able to create a multimaster mesh that allowed the writes to certain tables across the ocean and all regions subscribed to it. As a result, at any given time all 5 availability. Zones had same data and we would sustain an occasional WAN outage between two DCs. We use around 300 Postgres servers, everything managed via puppet and foreman. And I have not seen any single issue w r t the one reported for any of our setups. So I guess it is generalising just based out of some threads :) I do not use db2 but there has never been a need for one in my company as we have multiple design patterns of Postgres architecture based of requirements. On Mon, 15 Oct 2018 at 3:46 AM Ravi Krishna wrote: > > > > You're not forced to use slots. Their purpose is to allow to force the > > primary to keep necessary resources around. Which also allows to get rid > > of the archive in some setups. > > Thanks. > > Disclaimer: We don't use replication as we piggy back on AWS HA. > > The reason why I posted this is because majority of replication related > messages in this forum > is about slots :-) -- Regards, Vijay
Re: Slot issues
> > You're not forced to use slots. Their purpose is to allow to force the > primary to keep necessary resources around. Which also allows to get rid > of the archive in some setups. Thanks. Disclaimer: We don't use replication as we piggy back on AWS HA. The reason why I posted this is because majority of replication related messages in this forum is about slots :-)
Re: Slot issues
Hi, On 2018-10-14 17:52:30 -0400, Ravi Krishna wrote: > The best part in Db2 HADR is that when the standby is catching up with the > master after a long time, it will > start from the last LSN and fetch it from the primary WAL directory (active > logs ). If not found, it will look for it > in the archived logs and start applying from there until the current > point. Uh, it works precisely the same in postgres. > No rep slot business. You're not forced to use slots. Their purpose is to allow to force the primary to keep necessary resources around. Which also allows to get rid of the archive in some setups. Greetings, Andres Freund
Re: Slot issues
Hi, On 2018-10-15 03:18:35 +0530, bhargav kamineni wrote: > > 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 replication slots that exist on > the master do not become part of the backup. Otherwise, the subsequent use > of the backup to create a standby may result in indefinite retention of WAL > files on the standby, and possibly bloat on the master if hot standby > feedback is enabled, because the clients that are using those replication > slots will still be connecting to and updating 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 likely be badly out of date > by the time the new master comes on line." > > Since i already synced the pg_repslot to standby ,Is it okay if i remove > the pg_repslot directory befor starting postgresql service ? You can do that, but the nicer way probably is to just remove them via sql once started. Something like SELECT pg_drop_replication_slot(slot_name) FROM pg_replication_slots; Greetings, Andres Freund
Re: Slot issues
The best part in Db2 HADR is that when the standby is catching up with the master after a long time, it will start from the last LSN and fetch it from the primary WAL directory (active logs ). If not found, it will look for it in the archived logs and start applying from there until the current point. No rep slot business.
Re: Slot issues
When I read all such posts related to replication I realize how backward is PG's replication architecture specially when compared to DB2. This is how it is done in Db2 to set up replication. 1. take a full backup on the primary. 2. restore the backup on the other machine (aka standby) 3. start the instance on the standby machine as a standby and point to primary as the master 4. that's it. Db2 will fetch the relevant WAL (active) logs and start applying the logs to catch up. 5. Once it has caught up with the primary, it is in PEER mode. To failover from master to slave On the standby issue db2 takeover database dbname that's it. it will flip master and standby and reverse their roles. [ I am aware that why it is impossible in PG to reverse roles like this ] Long time back I use to work in SQL Server and the setup of mirroring was as simple as DB2. Negative of db2 replication: In DB2 replication, lot of restriction on standby to be used as a read-only. One DDL statement or stats collection in the primary will put the standby in replay only mode where it will kick out all sessions on standby until DDL/stats is applied on standby also. Note: My knowledge of db2 replication is bit dated as I have not worked on it since 2014. I love PG, but definitely replication management can be better.
Re: Slot issues
> 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 replication slots that exist on the master do not become part of the backup. Otherwise, the subsequent use of the backup to create a standby may result in indefinite retention of WAL files on the standby, and possibly bloat on the master if hot standby feedback is enabled, because the clients that are using those replication slots will still be connecting to and updating 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 likely be badly out of date by the time the new master comes on line." Since i already synced the pg_repslot to standby ,Is it okay if i remove the pg_repslot directory befor starting postgresql service ? On Mon, 15 Oct 2018 at 02:54, Andres Freund wrote: > Hi, > > As I just wrote: > > On Mon, 15 Oct 2018 at 02:40, Andres Freund 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 replication slots that exist on > the master do not become part of the backup. Otherwise, the subsequent use > of the backup to create a standby may result in indefinite retention of WAL > files on the standby, and possibly bloat on the master if hot standby > feedback is enabled, because the clients that are using those replication > slots will still be connecting to and updating 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 likely be badly out of date > by the time the new master comes on line." > > Greetings, > > Andres Freund >
Re: Slot issues
Hi, As I just wrote: > On Mon, 15 Oct 2018 at 02:40, Andres Freund 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 replication slots that exist on the master do not become part of the backup. Otherwise, the subsequent use of the backup to create a standby may result in indefinite retention of WAL files on the standby, and possibly bloat on the master if hot standby feedback is enabled, because the clients that are using those replication slots will still be connecting to and updating 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 likely be badly out of date by the time the new master comes on line." Greetings, Andres Freund
Re: [External] Re: Slot issues
ah that explains. Thanks andres. I do not use rsync, hence was not able to reproduce i guess :) Regards, Vijay On Mon, Oct 15, 2018 at 2:46 AM bhargav kamineni wrote: > Yeah i have used rsync , Got it now will increase the > max_replication_slots to high enough , Thank you Andres Freund :-) > > On Mon, 15 Oct 2018 at 02:40, Andres Freund wrote: > >> Hi, >> >> Please try to quote properly. >> >> On 2018-10-15 01:57:53 +0530, bhargav kamineni wrote: >> > I got his on standby, could you please explain in detail about >> > --*but that *on the standby* haven't set max_replication_slots high >> enough* >> > . >> >> What is max_replication_slots set to on the new standby? >> >> If you created the new basebackup using rsync, and didn't exclude >> pg_replication_slot, it'll have copied the slots from the primary. And >> thus needs a high enough max_replication_slots to work with them. >> >> - Andres >> >
Re: [External] Re: Slot issues
Sorry Bhargav. I tried to simulate the scenarios, 3 node cluster 1primary, 2hot standby given: max_replication_slots = 2 on primary, and i try to create 2 hot standby -> runs fine. max_replication_slots = 1 on primary, and i try to create 2 hot standby -> gives PANIC, increase replication slots. (the standby only cries with replication slot does not exist, not increase number of replication slots) max_replication_slots = 2 on primary, and max_replication_slots=1 on hot standby, delete recovery.conf and recover from pg_baseback works fine. max_replication_slots = 2 on primary, on standby i try to use a replication_slot already existing, it gives correct error of slot in use and not increase replication slot error. my pg_replslot folder is consistent of the replication slots i have on the master. so i guess, i'll leave it to the experts. but i still do not understand why would you get that error on standby, unless you are doing cascading replication. I'll watch this thread to see how this is resolved. Thanks, Vijay Regards, Vijay On Mon, Oct 15, 2018 at 2:41 AM Andres Freund wrote: > Hi, > > Please try to quote properly. > > On 2018-10-15 01:57:53 +0530, bhargav kamineni wrote: > > I got his on standby, could you please explain in detail about > > --*but that *on the standby* haven't set max_replication_slots high > enough* > > . > > What is max_replication_slots set to on the new standby? > > If you created the new basebackup using rsync, and didn't exclude > pg_replication_slot, it'll have copied the slots from the primary. And > thus needs a high enough max_replication_slots to work with them. > > - Andres > >
Re: Slot issues
Yeah i have used rsync , Got it now will increase the max_replication_slots to high enough , Thank you Andres Freund :-) On Mon, 15 Oct 2018 at 02:40, Andres Freund wrote: > Hi, > > Please try to quote properly. > > On 2018-10-15 01:57:53 +0530, bhargav kamineni wrote: > > I got his on standby, could you please explain in detail about > > --*but that *on the standby* haven't set max_replication_slots high > enough* > > . > > What is max_replication_slots set to on the new standby? > > If you created the new basebackup using rsync, and didn't exclude > pg_replication_slot, it'll have copied the slots from the primary. And > thus needs a high enough max_replication_slots to work with them. > > - Andres >
Re: Slot issues
Hi, Please try to quote properly. On 2018-10-15 01:57:53 +0530, bhargav kamineni wrote: > I got his on standby, could you please explain in detail about > --*but that *on the standby* haven't set max_replication_slots high enough* > . What is max_replication_slots set to on the new standby? If you created the new basebackup using rsync, and didn't exclude pg_replication_slot, it'll have copied the slots from the primary. And thus needs a high enough max_replication_slots to work with them. - Andres
Re: [External] Re: Slot issues
pg_replslot # ls -lrth total 4.0K drwx-- 2 postgres postgres 4.0K Oct 14 14:55 replication_slot On Mon, 15 Oct 2018 at 02:11, Vijaykumar Jain wrote: > ok wait, you data directory path may be different :) > i mean wherever your pg data dir is, from there find pg_replslot folder > and list the contents of it. > > Regards, > Vijay > > > On Mon, Oct 15, 2018 at 2:10 AM Vijaykumar Jain > wrote: > >> i guess he is trying to confirm if the value of max_replication_slot is >> the same on all the master and the standby nodes. >> >> also, >> >> I am trying to shoot in the dark. >> >> can you give the output of (on master) >> ls /var/lib/postgresql//main/pg_replslot/* >> >> also the value of max_replication_slot on the master and all the >> standby's. >> also, how are you creating the replication slot? >> >> can you share the query? >> >> also pls share the content of the recovery.conf on the standby nodes >> (both currently running and currently not running). >> you can scribble company secret stuff. >> >> >> Regards, >> Vijay >> >> >> On Mon, Oct 15, 2018 at 1:58 AM bhargav kamineni < >> bhargavpostg...@gmail.com> wrote: >> >>> I got his on standby, could you please explain in detail about >>> --*but that *on the standby* haven't set max_replication_slots high >>> enough*. >>> >>> Thanks, >>> Bhargav >>> >>> On Mon, 15 Oct 2018 at 01:50, Andres Freund wrote: >>> Hi, On 2018-10-15 00:15:53 +0530, bhargav kamineni wrote: > Hi Team, > > I am getting this ERROR while starting my second slave server > > PANIC: too many replication slots active before shutdown > HINT: Increase max_replication_slots and try again. > > max_replication_slots on my master is 2 and one of them is already active > for another slave, > do i need to increase this parameter for the need of working of another > slave ? if so whats the reason ? You're getting that error on the standby, not the primary, right? In all likelihood the problem is that you copied over replication slots to your standby server, but that *on the standby* haven't set max_replication_slots high enough. Greetings, Andres Freund >>>
Re: [External] Re: Slot issues
ok wait, you data directory path may be different :) i mean wherever your pg data dir is, from there find pg_replslot folder and list the contents of it. Regards, Vijay On Mon, Oct 15, 2018 at 2:10 AM Vijaykumar Jain wrote: > i guess he is trying to confirm if the value of max_replication_slot is > the same on all the master and the standby nodes. > > also, > > I am trying to shoot in the dark. > > can you give the output of (on master) > ls /var/lib/postgresql//main/pg_replslot/* > > also the value of max_replication_slot on the master and all the standby's. > also, how are you creating the replication slot? > > can you share the query? > > also pls share the content of the recovery.conf on the standby nodes (both > currently running and currently not running). > you can scribble company secret stuff. > > > Regards, > Vijay > > > On Mon, Oct 15, 2018 at 1:58 AM bhargav kamineni < > bhargavpostg...@gmail.com> wrote: > >> I got his on standby, could you please explain in detail about >> --*but that *on the standby* haven't set max_replication_slots high >> enough*. >> >> Thanks, >> Bhargav >> >> On Mon, 15 Oct 2018 at 01:50, Andres Freund wrote: >> >>> Hi, >>> >>> On 2018-10-15 00:15:53 +0530, bhargav kamineni wrote: >>> > Hi Team, >>> > >>> > I am getting this ERROR while starting my second slave server >>> > >>> > PANIC: too many replication slots active before shutdown >>> > HINT: Increase max_replication_slots and try again. >>> > >>> > max_replication_slots on my master is 2 and one of them is already >>> active >>> > for another slave, >>> > do i need to increase this parameter for the need of working of another >>> > slave ? if so whats the reason ? >>> >>> You're getting that error on the standby, not the primary, right? In >>> all likelihood the problem is that you copied over replication slots to >>> your standby server, but that *on the standby* haven't set >>> max_replication_slots high enough. >>> >>> Greetings, >>> >>> Andres Freund >>> >>
Re: [External] Re: Slot issues
i guess he is trying to confirm if the value of max_replication_slot is the same on all the master and the standby nodes. also, I am trying to shoot in the dark. can you give the output of (on master) ls /var/lib/postgresql//main/pg_replslot/* also the value of max_replication_slot on the master and all the standby's. also, how are you creating the replication slot? can you share the query? also pls share the content of the recovery.conf on the standby nodes (both currently running and currently not running). you can scribble company secret stuff. Regards, Vijay On Mon, Oct 15, 2018 at 1:58 AM bhargav kamineni wrote: > I got his on standby, could you please explain in detail about > --*but that *on the standby* haven't set max_replication_slots high > enough*. > > Thanks, > Bhargav > > On Mon, 15 Oct 2018 at 01:50, Andres Freund wrote: > >> Hi, >> >> On 2018-10-15 00:15:53 +0530, bhargav kamineni wrote: >> > Hi Team, >> > >> > I am getting this ERROR while starting my second slave server >> > >> > PANIC: too many replication slots active before shutdown >> > HINT: Increase max_replication_slots and try again. >> > >> > max_replication_slots on my master is 2 and one of them is already >> active >> > for another slave, >> > do i need to increase this parameter for the need of working of another >> > slave ? if so whats the reason ? >> >> You're getting that error on the standby, not the primary, right? In >> all likelihood the problem is that you copied over replication slots to >> your standby server, but that *on the standby* haven't set >> max_replication_slots high enough. >> >> Greetings, >> >> Andres Freund >> >
Re: Slot issues
I got his on standby, could you please explain in detail about --*but that *on the standby* haven't set max_replication_slots high enough* . Thanks, Bhargav On Mon, 15 Oct 2018 at 01:50, Andres Freund wrote: > Hi, > > On 2018-10-15 00:15:53 +0530, bhargav kamineni wrote: > > Hi Team, > > > > I am getting this ERROR while starting my second slave server > > > > PANIC: too many replication slots active before shutdown > > HINT: Increase max_replication_slots and try again. > > > > max_replication_slots on my master is 2 and one of them is already active > > for another slave, > > do i need to increase this parameter for the need of working of another > > slave ? if so whats the reason ? > > You're getting that error on the standby, not the primary, right? In > all likelihood the problem is that you copied over replication slots to > your standby server, but that *on the standby* haven't set > max_replication_slots high enough. > > Greetings, > > Andres Freund >
Re: Slot issues
Hi, On 2018-10-15 00:15:53 +0530, bhargav kamineni wrote: > Hi Team, > > I am getting this ERROR while starting my second slave server > > PANIC: too many replication slots active before shutdown > HINT: Increase max_replication_slots and try again. > > max_replication_slots on my master is 2 and one of them is already active > for another slave, > do i need to increase this parameter for the need of working of another > slave ? if so whats the reason ? You're getting that error on the standby, not the primary, right? In all likelihood the problem is that you copied over replication slots to your standby server, but that *on the standby* haven't set max_replication_slots high enough. Greetings, Andres Freund
Re: [External] Slot issues
postgres=# select * from pg_replication_slots ; slot_name | plugin | slot_type | datoid | database | active | active_pid | xmin | catalog_xmin | restart_lsn --++---++--+++--+--+--- replication_slot || physical || | t | 23185 | | | 7642/B07AC830 (1 row) On Mon, 15 Oct 2018 at 01:34, Vijaykumar Jain wrote: > from your master, can you give us the output of > > select * from pg_replication_slots; > > maybe some stray slot exists that you may not be aware of ? > > Regards, > Vijay > > > On Mon, Oct 15, 2018 at 1:08 AM Vijaykumar Jain > wrote: > >> ok my bad. >> >> i just set one of the 9.6.9 versions to have max_replication_slots =2 and >> still i had to slots active. >> >> ostgres=# table pg_replication_slots; >> slot_name| plugin | slot_type | datoid | database | >> active | active_pid | xmin | catalog_xmin | restart_lsn | >> confirmed_flush_lsn >> >> -++---++--+++--+--+-+- >> a02 || physical || | t | 13719 | >> | | 2/D3D0 | >> a03 || physical || | t | 13720 | >> | | 2/D3D0 | >> (2 rows) >> >> postgres=# show max_replication_slots; >> max_replication_slots >> --- >> 2 >> (1 row) >> >> >> yep it should work with 2. >> Regards, >> Vijay >> >> >> On Mon, Oct 15, 2018 at 1:02 AM Vijaykumar Jain >> wrote: >> >>> I guess max_replication_slots has to be greater than active replication >>> slots. >>> maybe you need to increase max_replication_slots to 3 to have 2 active >>> slots. >>> >>> Regards, >>> Vijay >>> >>> >>> On Mon, Oct 15, 2018 at 12:54 AM bhargav kamineni < >>> bhargavpostg...@gmail.com> wrote: >>> for 9.x. Default was 0. we have set max_replication_slot =2 , one is already being used , postgres should use second slot for another server but dono why its throwing error On Mon, 15 Oct 2018 at 00:32, Vijaykumar Jain wrote: > I guess max_replication_slots has to > current total slots in use. > (and not >= ) > > > https://www.postgresql.org/docs/10/static/runtime-config-replication.html > > https://github.com/postgres/postgres/blob/d6e98ebe375e115c29028f9bd090f0f7e07e2527/src/backend/replication/slot.c#L1506 > > from the doc, it says defaults are 10, any reason why you have set it > to 2. You need to set it at a value higher than number of slots active. > also, i guess changing this parameter would require a server restart. > > > > > Regards, > Vijay > > > On Mon, Oct 15, 2018 at 12:16 AM bhargav kamineni < > bhargavpostg...@gmail.com> wrote: > >> Hi Team, >> >> I am getting this ERROR while starting my second slave server >> >> PANIC: too many replication slots active before shutdown >> HINT: Increase max_replication_slots and try again. >> >> max_replication_slots on my master is 2 and one of them is already >> active for another slave, >> do i need to increase this parameter for the need of working of >> another slave ? if so whats the reason ? >> >> >> >> Thanks >> Bhargav K >> >
Re: [External] Slot issues
from your master, can you give us the output of select * from pg_replication_slots; maybe some stray slot exists that you may not be aware of ? Regards, Vijay On Mon, Oct 15, 2018 at 1:08 AM Vijaykumar Jain wrote: > ok my bad. > > i just set one of the 9.6.9 versions to have max_replication_slots =2 and > still i had to slots active. > > ostgres=# table pg_replication_slots; > slot_name| plugin | slot_type | datoid | database | active > | active_pid | xmin | catalog_xmin | restart_lsn | confirmed_flush_lsn > > -++---++--+++--+--+-+- > a02 || physical || | t | 13719 | > | | 2/D3D0 | > a03 || physical || | t | 13720 | > | | 2/D3D0 | > (2 rows) > > postgres=# show max_replication_slots; > max_replication_slots > --- > 2 > (1 row) > > > yep it should work with 2. > Regards, > Vijay > > > On Mon, Oct 15, 2018 at 1:02 AM Vijaykumar Jain > wrote: > >> I guess max_replication_slots has to be greater than active replication >> slots. >> maybe you need to increase max_replication_slots to 3 to have 2 active >> slots. >> >> Regards, >> Vijay >> >> >> On Mon, Oct 15, 2018 at 12:54 AM bhargav kamineni < >> bhargavpostg...@gmail.com> wrote: >> >>> for 9.x. Default was 0. we have set max_replication_slot =2 , one is >>> already being used , postgres should use second slot for another server >>> but dono why its throwing error >>> >>> On Mon, 15 Oct 2018 at 00:32, Vijaykumar Jain >>> wrote: >>> I guess max_replication_slots has to > current total slots in use. (and not >= ) https://www.postgresql.org/docs/10/static/runtime-config-replication.html https://github.com/postgres/postgres/blob/d6e98ebe375e115c29028f9bd090f0f7e07e2527/src/backend/replication/slot.c#L1506 from the doc, it says defaults are 10, any reason why you have set it to 2. You need to set it at a value higher than number of slots active. also, i guess changing this parameter would require a server restart. Regards, Vijay On Mon, Oct 15, 2018 at 12:16 AM bhargav kamineni < bhargavpostg...@gmail.com> wrote: > Hi Team, > > I am getting this ERROR while starting my second slave server > > PANIC: too many replication slots active before shutdown > HINT: Increase max_replication_slots and try again. > > max_replication_slots on my master is 2 and one of them is already > active for another slave, > do i need to increase this parameter for the need of working of > another slave ? if so whats the reason ? > > > > Thanks > Bhargav K >
Re: [External] Slot issues
ok my bad. i just set one of the 9.6.9 versions to have max_replication_slots =2 and still i had to slots active. ostgres=# table pg_replication_slots; slot_name| plugin | slot_type | datoid | database | active | active_pid | xmin | catalog_xmin | restart_lsn | confirmed_flush_lsn -++---++--+++--+--+-+- a02 || physical || | t | 13719 | | | 2/D3D0 | a03 || physical || | t | 13720 | | | 2/D3D0 | (2 rows) postgres=# show max_replication_slots; max_replication_slots --- 2 (1 row) yep it should work with 2. Regards, Vijay On Mon, Oct 15, 2018 at 1:02 AM Vijaykumar Jain wrote: > I guess max_replication_slots has to be greater than active replication > slots. > maybe you need to increase max_replication_slots to 3 to have 2 active > slots. > > Regards, > Vijay > > > On Mon, Oct 15, 2018 at 12:54 AM bhargav kamineni < > bhargavpostg...@gmail.com> wrote: > >> for 9.x. Default was 0. we have set max_replication_slot =2 , one is >> already being used , postgres should use second slot for another server >> but dono why its throwing error >> >> On Mon, 15 Oct 2018 at 00:32, Vijaykumar Jain >> wrote: >> >>> I guess max_replication_slots has to > current total slots in use. (and >>> not >= ) >>> >>> https://www.postgresql.org/docs/10/static/runtime-config-replication.html >>> >>> https://github.com/postgres/postgres/blob/d6e98ebe375e115c29028f9bd090f0f7e07e2527/src/backend/replication/slot.c#L1506 >>> >>> from the doc, it says defaults are 10, any reason why you have set it to >>> 2. You need to set it at a value higher than number of slots active. >>> also, i guess changing this parameter would require a server restart. >>> >>> >>> >>> >>> Regards, >>> Vijay >>> >>> >>> On Mon, Oct 15, 2018 at 12:16 AM bhargav kamineni < >>> bhargavpostg...@gmail.com> wrote: >>> Hi Team, I am getting this ERROR while starting my second slave server PANIC: too many replication slots active before shutdown HINT: Increase max_replication_slots and try again. max_replication_slots on my master is 2 and one of them is already active for another slave, do i need to increase this parameter for the need of working of another slave ? if so whats the reason ? Thanks Bhargav K >>>
Re: Slot issues
Am 14.10.2018 um 21:07 schrieb bhargav kamineni: Postgres version is 9.5.14 , currently only one slot is there and it is active that's strange. Please check if this setting is active (select from pg_settings). Please check also max_wal_senders. no futher ideas at the moment :-( Regards, Andreas -- 2ndQuadrant - The PostgreSQL Support Company. www.2ndQuadrant.com
Re: [External] Slot issues
Am 14.10.2018 um 21:02 schrieb Vijaykumar Jain: from the doc, it says defaults are 10, that's only valid for version 10, not for 9.x. Default was 0. Regards, Andreas -- 2ndQuadrant - The PostgreSQL Support Company. www.2ndQuadrant.com
Re: Slot issues
Am 14.10.2018 um 20:45 schrieb bhargav kamineni: I am getting this ERROR while starting my second slave server PANIC: too many replication slots active before shutdown HINT: Increase max_replication_slots and try again. max_replication_slots on my master is 2 and one of them is already active for another slave, do i need to increase this parameter for the need of working of another slave ? if so whats the reason ? please check on the master how many slots are in use: select * from pg_replication_slots ; please also tell us the exact version you are using. Regards, Andreas -- 2ndQuadrant - The PostgreSQL Support Company. www.2ndQuadrant.com
Re: [External] Slot issues
I guess max_replication_slots has to > current total slots in use. (and not >= ) https://www.postgresql.org/docs/10/static/runtime-config-replication.html https://github.com/postgres/postgres/blob/d6e98ebe375e115c29028f9bd090f0f7e07e2527/src/backend/replication/slot.c#L1506 from the doc, it says defaults are 10, any reason why you have set it to 2. You need to set it at a value higher than number of slots active. also, i guess changing this parameter would require a server restart. Regards, Vijay On Mon, Oct 15, 2018 at 12:16 AM bhargav kamineni wrote: > Hi Team, > > I am getting this ERROR while starting my second slave server > > PANIC: too many replication slots active before shutdown > HINT: Increase max_replication_slots and try again. > > max_replication_slots on my master is 2 and one of them is already active > for another slave, > do i need to increase this parameter for the need of working of another > slave ? if so whats the reason ? > > > > Thanks > Bhargav K >
Slot issues
Hi Team, I am getting this ERROR while starting my second slave server PANIC: too many replication slots active before shutdown HINT: Increase max_replication_slots and try again. max_replication_slots on my master is 2 and one of them is already active for another slave, do i need to increase this parameter for the need of working of another slave ? if so whats the reason ? Thanks Bhargav K