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 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
445
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
360
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
306
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
255
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
236
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
2061
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
388
views
asked 7 months agolg...
Hello,
does anyone have insight on Aurora Postgres disk throughput / read throughput? We have been thinking of migrating RDS postgres to Aurora but benchmarking our case produced results that are...
0
answers
0
votes
66
views
asked 7 months agolg...