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'm looking for recommendations on how much "Free Storage Space" we should maintain on our RDS Postgres Instances.
1
answers
0
votes
441
views
asked 3 months agolg...
This is a related question for AWS Aurora PostgreSQL: https://repost.aws/questions/QUF12RpagpTey5vszbg4Fm9w/pg-ivm-plugin-for-aurora-postgresql
1
answers
5
votes
513
views
asked 3 months agolg...
We've been using aws_s3.table_import_from_s3 for about 15 months with great success to load thousands of s3 files. About a month ago we started seeing a few calls to aws_s3.table_import_from_s3 that...
1
answers
1
votes
443
views
asked 3 months agolg...
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
381
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
184
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
165
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
1400
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
290
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
167
views
asked 4 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
176
views
asked 4 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
133
views
asked 4 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
167
views
asked 4 months agolg...