All Content tagged with PostgreSQL

I have a huge set of tables that I want to load onto an RDS postgres DB. I "bulk-load" this data by deliberately switching off Indexing (including using db_index=False). Then I "switch on" the...

I am facing an issue when taking a PostgreSQL dump from an AWS RDS instance to an EC2 instance in the same region using the pg_dump command. The dump process runs smoothly for about 30 minutes and...

- When manual snapshot is taken, its consistency with what point in time? Start of the snapshot or end? - Does RDS Snapshots underlying use EBS snapshots? How does it guarantee consistency? what...

Hello team, We are working on multi-tenant environment where each tenant having dedicated Database but all the tenants DBs are part of single Postgresql server of size **db.m6i.2xlarge**. We have...

Since postgreSQL 11.21 has reached EOL, we are trying to upgrade it to 13.12. Initially the upgrade was failing at the `precheck` stage due to postgis. Resolved that, the upgrade is proceeding past...

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...