AWS RDS PostgreSQL Set Up

AWS RDS PostgreSQL is a popular database choice, known for its user-friendly setup and global adoption, making it easy for new users to establish an instance in minutes. The text details the process of setting up a new AWS RDS PostgreSQL instance and configuring it for compatibility with Streamkap by enabling Change Data Capture (CDC) functionality. Users must ensure they have the necessary IAM permissions and follow a structured approach to create and modify parameter groups, adjusting settings like `rds.logical_replication` and `wal_sender_timeout` to enable sub-second latency streaming. For existing instances, the text outlines tests and configurations to determine and achieve CDC compatibility, including creating or modifying parameter groups to meet the required settings. Additionally, it emphasizes the importance of testing these configurations using tools like DBeaver to ensure successful implementation, with guidance on troubleshooting common issues like security group settings to permit local machine access.