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.
We need to scale down the gp3 storage of our RDS instance (PostgreSQL) using DMS. Can anyone provide a tutorial video or general steps on how to do it?
2
answers
0
votes
265
views
asked 7 months agolg...
I have a Multi-AZ DB cluster with the Postgres engine; it is not an Aurora cluster but a new Multi-AZ DB cluster that has one writer instance and two reader instances. Currently, it uses rds-ca-2019;...
2
answers
2
votes
448
views
asked 7 months agolg...
I'm unable to take a snapshot, or upgrade postgres version basically everything because the cluster for some unknown reason is stuck at stopping stage.
I only get this error when I try to make...
2
answers
0
votes
361
views
asked 7 months agolg...
Babelfish upgrade errors from Aurora 13.8 with Babelfish 1.4.0 to Aurora 14.6 with Babelfish 2.3.0lg...
Customer is receiving these errors while attempting to upgrade their database - this is an in-place upgrade where everything is currently working under version Aurora 13.8 with Babelfish 1.4.0
**Some...
0
answers
0
votes
137
views
asked 7 months agolg...
Database running stable on PostgreSQL 15.3.1, started importing large table into it from S3 using table_import_from_s3, import runs fine for a couple of minutes then the DB writer instance restarts...
1
answers
0
votes
403
views
asked 7 months agolg...
I am attempting to upgrade my Aurora Postgres Cluster from 11.18 to 13.9 (only valid upgrade path) and I instantly receive an error notification on the console. The error does not have any details and...
0
answers
0
votes
158
views
asked 7 months agolg...
I'm trying to set up a blue/green upgrade of a PostgreSQL cluster from 11.21 to 15.4. During the process I've had several incompatible parameter issues, which I was able to fix by updating the...
0
answers
0
votes
89
views
asked 7 months agolg...
Hello all,
We are planning to use aurora Postgres and mysql for few applications. But wanted some guidance on which instance, class type should we use for lower environment/non prod like...
2
answers
0
votes
307
views
asked 7 months agolg...
Hello,
I'm importing data from S3 to RDS (Postgre) by using aws_s3.table_import_from_s3 extension. Unfortunatelly I'm getting error "Semicolon is not allowed in options". Is semicolon allowed...
1
answers
0
votes
256
views
asked 7 months agolg...
Hello Team,
I created an RDS Postgres 15.2 instance with a predefined user. When I try to connect to this instance from the EKS pod with psql (version 14.9) I received:
`/ # psql...
1
answers
0
votes
238
views
asked 7 months agolg...
I made AWS RDS instance made, Publicly accessible "Yes", have default VPC security group, have two imbound rules one default one and one custom rule as below
Name : blank, Security group rule ID :...
1
answers
0
votes
2065
views
asked 7 months agolg...
I'm attempting to migrate an RDS MySql db to a RDS Postgres db. I've made a new postgres db to copy to, the source db is live - website is accessible and works with database requests. I'm using the...
1
answers
0
votes
389
views
asked 7 months agolg...