Questions tagged with PostgreSQL
Amazon RDS makes it easy to set up, operate, and scale PostgreSQL deployments in the cloud.
Content language: English
Select up to 5 tags to filter
Sort by most recent
Browse through the questions and answers listed below or filter and sort to narrow down your results.
I’m using Next.js with Prisma ORM, hosting the application on AWS Amplify, and I have a PostgreSQL database on RDS that I need to connect to. However, I’ve read that making the database publicly...
We just received an ultimatum to upgrade our Aurora Serverless Postgres from version 11 due to end-of-life. I tried to upgrade to version 13, which fails:
`Database cluster is in a state that cannot...
Hi Team,
I have an Aurora PostgreSQL instance running version **14.9** on a **db.r6g.2xlarge ** instance type (Memory-optimized). Recently, the server's CPU usage has increased to around **99.5%**. I...
HI,
I have a dms replication task to replicate tables from one rds postgres instance to another. I have created a scheduler to run the replication task for every 6 hour and stop after 30 ...
I have ECS cluster with EC2 instances. My purpose is to deploy Postgres and Backend services so `backend` could connect to `postgres`. I don't want to use RDS for developing purposes, so I've created...
Hi,
I created a postgres RDS database which I configured and was able to connect via pgAdmin. However when I try to connect to the db via code, I get timeout error
For context my vpc security group...
I have an RDS PostgreSQL db which I just upgraded to 16.4. It uses the PostGIS extension. It's working fine after the upgrade;
```
SELECT extname, extversion from pg_extension;
SELECT...
We have two Aurora PostgreSQL databases that were upgraded from version 16.2 to version 16.3 on August 9th. Today they both ran out of disk space on the local storage volume where as prior to the...
Hello,
Since the pg_cron version 1.5.0 there's the possibility of using a timezone instead of the default UTC timezone. The pg_cron documentation allows for a **cron.timezone** settings in the...
Hi Team,
I have databases running on Oracle 10.2.0.4, 11.2.0.4, 12.1.0.2, 12.2.0.1 and want to migrate them either on PostgreSQL or aurora PostgreSQL.
I just wanted to check if DMS/SCT is compatible...
I have a Postgres database hosted by Heroku that I dumped and restored via an EC2 instance to an AWS RDS database. I am able to confirm the tables were properly transferred by querying in postgres via...
Hi
After upgrading an existing Postgres 16.1 instance on RDS to 16.4 the postgres extension stopped working. Queries on tables using the extension just fails with this error.
```
ERROR: could not...