Search Postgresql Archives

Re: [External] Slot issues

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 <vjain@xxxxxxxxxxxxx> 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 <vjain@xxxxxxxxxxxxx> 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/D30000D0  |
a03 |        | physical  |        |          | t      |      13720 |      |              | 2/D30000D0  |
(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 <vjain@xxxxxxxxxxxxx> 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 <bhargavpostgres@xxxxxxxxx> 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 <vjain@xxxxxxxxxxxxx> wrote:
I guess max_replication_slots has to >  current total slots in use. (and not >= ) 


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 <bhargavpostgres@xxxxxxxxx> 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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux