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.
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
161
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
167
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
124
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
153
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
242
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
301
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
508
views
asked 3 months agolg...
RDS keep costing even if I delete all instances, it cost $0.01 per day,
![Enter image description here](/media/postImages/original/IMCccr4e1STU-tuRjFcMFW4Q)
![Enter image description...
1
answers
0
votes
105
views
asked 3 months agolg...
We want to use DMS homogenous migration to scale down our RDS instance's (PostgreSQL) gp3 storage. I saw in the AWS documentation (see below) that PostgreSQL 15.x is not supported as a source data...
1
answers
0
votes
137
views
asked 3 months agolg...
If you do not specify a database name, Amazon RDS does not create a database.
The above line was mentioned under db name in RDS. But I am able to create a RDS instance of any db type like mysql,...
1
answers
0
votes
152
views
asked 3 months agolg...
We have RDS instance that works on 14.10 version. We used it to export data to s3 bucket with help of https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/postgresql-s3-export.html .
We migrated to...
1
answers
1
votes
231
views
asked 4 months agolg...
Hi all, we recently had an incident where our PostgreSQL DB server in RDS was upgraded to 12.17 from 12.14 (through routine RDS maintenance). At the time it was running the PostGIS extension version...
2
answers
1
votes
130
views
asked 4 months agolg...