Questions tagged with PostgreSQL

after setting the rds.logical_replication to 1, wal_level is not setting to logical

We did premigration test on our Data Migration Task, it shows 2 errors as below 1. Validate if wal_level is set to logical on the source database I searched for the help on this, and got info like if...

Hello! I'm trying to connect a [Permify](https://permify.co/) pod to an RDS PostgreSQL instance through a RDS Proxy. Unfortunately, the application crash after a while with the error...

i have provisioned AWS database lightsail with postgresql 16.3, but i when the instance is created, when monitoring free-storage metrics, the storage keep decreasing, but i am not having any database...

Hello All, My team has recently been shifted to using (MIT) Kerberos for authentication to our PostgreSQL database. We are able to successfully authenticate in dBeaver Lite, however we are not able...

Hi everyone, I wanted to know, when you create a new Role using `CREATE ROLE` command or when you install a new extension using `CREATE EXTENSION` using one of the instances write endpoint in the...

I need to connect to an RDS Posgresql which has SSL enabled and downloaded latest PgAdmin. I followed Using SSL with a PostgreSQL DB instance - Amazon Relational Database Service. I verified the...

I have 2 VPCs, one for my EKS cluster and another for the RDS. I have established a VPC peering between them, but I still receive errors from my application "connection timed out on port 5432". It's...

Hi I have crawler engine that run on 1st and 15th every month, I noticed there is spike on checkpoint lag and CPU utilization. Currently using: db.t3.medium instance Checkpoint lag: from100-140 ->...

I am trying to set up a Drupal project using Apache and I am using PostgreSQL for my database. I have set up my EC2 and RDS instances and I have checked my configurations several times, but I keep...

Hi everyone, We are using pg_cron extension with postgres with AWS RDS and would love to use the 'cron.timezone' option which is offered by the extension but not by AWS parameter...

The [PostgreSQL Anonymizer](https://postgresql-anonymizer.readthedocs.io/en/stable/) is a popular extension for masking data on query results. This is unfortunately not yet supported on RDS. One...