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.
Hi there,
I'm checking what usage in AWS is not tagged with the 3 tags I usually have (Env, Role, State) and I see the following.
Could you help me to get from where it's coming since I've all of my...
1
answers
0
votes
396
views
asked 3 months agolg...
I'm looking for recommendations on how much "Free Storage Space" we should maintain on our RDS Postgres Instances.
1
answers
0
votes
443
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
517
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
445
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
383
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
166
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
1401
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
292
views
asked 4 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
168
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
178
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...