Questions tagged with PostgreSQL
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 have two Postgres RDS instances (Not Aurora). One is the Primary and the other is a Read Replica to that Primary. I currently use PGBouncer as a Proxy Pool for both the Primary and Replica. I note...
1
answers
0
votes
305
views
asked 3 months agolg...
I have a Postgres RDS instance that is producing very strange behavior regarding system snapshots. Basically, when I manually create a snapshot and then restore it I am always able to connect to it...
1
answers
0
votes
165
views
asked 3 months agolg...
![Error Message](/media/postImages/original/IM4IXQHpFwSMu3pOpFkapqWw)
I simply cannot figure out how to access my RDS database through pgAdmin4.
More info:
1. The database is available;
2. The...
1
answers
0
votes
145
views
asked 3 months agolg...
Hi,
1. What is cost for Data Transfer -> Global-DataTransfer-Regional-Bytes. As I can see it's within Free Tier but only for 1.0 GB. What is the price for 1GB after we exceed free tier limit.
2. Is it...
1
answers
0
votes
1377
views
asked 3 months agolg...
HI, I am able to create the DMS instance (**Postgress to S3 migration**) through the YAML file[full-load-and-cdc]. It is successfully creating Replication instance, Source and Target end points and...
2
answers
0
votes
261
views
asked 3 months agolg...
Is there any formula to set the max_connection value in a PostgreSQL 12 EC2 instance with 64 CPUs, 500 GB RAM, and 150k IOPS? Additionally, what other parameters need to be changed for a mixed...
1
answers
0
votes
145
views
asked 3 months agolg...
Hi all!
We're encountering difficulties upgrading our RDS PostgreSQL instance from version 11 to 12 due to the presence of tables declared WITH OIDS, which is not supported in the upgrade...
1
answers
0
votes
152
views
asked 3 months agolg...
I had a database which got to a Full-Storage status. I tried creating an emergency restore with a bigger plan but everytime I'm getting status "Incompatible Restore" and I can not use the restored...
1
answers
0
votes
115
views
asked 3 months agolg...
I'm confused on what the right service/tool to use to migrate my Aurora Serverless v1 PG to Aurora Serverless MySQL, I tried DMS but I found that I should do schema migration first. but DMS schema...
1
answers
0
votes
138
views
asked 3 months agolg...
I have a PostgreSQL RDS v 11.22 on a db.t2.medium. I have to upgrade the database version and the instance type and the cert. I'm trying to do this but I'm getting the following error. I have gone...
2
answers
0
votes
206
views
asked 3 months agolg...
Hi All,
i have multiple databases setup in my RDS(i.e postgresql) i have a requirement that i have to implement database active monitoring for my this databases , need some help on how can i implement...
1
answers
0
votes
269
views
asked 3 months agolg...
How to create cross-account and cross-region read replicas for Amazon Aurora PostgreSQL?
Any reference to documentation or a blog will be helpful.
Thanks
2
answers
0
votes
451
views
asked 3 months agolg...