3

I am using AWS RDS Postgres's and RDS's logical replication support

(Edit: Note, this is not the same as the logical replication featurein PostgreSQL 10. It's AWS RDS functionality based on the same underlying logical decoding feature.)

I'm replicating Postgres -> Postgres . Basically consolidation a lot of DB's into one db.

The problem i have is when no activity in a database for some time disk is filling up . I want to control how much storage can be used by WAL . I adjusted the wal_segments to keep. Still disk is filling up . Rather than doing some dummy update to a table , are there any parameters i can set to control the disk usage . Current parameters are

wal_keep_segments =4 
wal_max_size =128 
wal_min_size 16 

Murali

  • 1
    How about archive_mode, and archive_command parameters? – Sahap Asci May 11 '17 at 8:11
  • @SahapAsci This is AWS RDS, they don't have access to that. – Craig Ringer May 11 '17 at 11:44
  • @Murali, can you please run SHOW shared_preload_libraries on an instance and paste the result here? – Craig Ringer May 11 '17 at 11:48
  • rdsutils that is only one shows up. – Murali May 11 '17 at 21:27
  • 1
    Does AWS RDS has archive_timeout? – Sahap Asci May 21 '17 at 10:16

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.