Hi Alex , While testing I bring down the replica which broke the replication and also verified the status with the help of catalog view pg_stat_replication - return 0 record pg_replication_slot - show slot is inactive . After that I have inserted data to check. Also,In the database logs there is no nothing as such.
... View more
Hello , I am testing one senerio releated to replication slot(Which i need to implement on PROD) I tried to configure streaming replication with replication slot. My-configuration - Master - Server-side configuration --> archive_mode=on archive_command='/bin/true' wal_level=replica max_wal_senders = 10 max_replication_slots=10 wal_keep_segments = 10 And Created replication slot "SELECT * FROM pg_create_physical_replication_slot('test1');" Slave-side configuration --> primary_slot_name='test1' standby_mode = 'on' primary_conninfo = 'user=postgres port=5432 sslmode=prefer sslcompression=1 krbsrvname=postgres target_session_attrs=any' Issues - When i bring down replica and insterted near about 300MB data to check will server keep transaction files in <PGDATA>/pg_wal till replication slot become active .But files get removed when replication slot is in inactive state,Can you please explain if this is the expected ? PG-Version - psql (PostgreSQL) 10.10
... View more