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.
MSSQL RDS is migrated to Postgres RDS Aurora using Babelfish.
This migrated db works fine with direct endpoint of RDs Aurora Instance.
But fails to recognize Old MSSQL queries , Stored procedures...
0
answers
0
votes
187
views
asked 8 months agolg...
I have a db instance that contains multiples databases. I want to create one user to each database where the user can only access that database. I am using Prisma ORM, that requires that the user can...
1
answers
0
votes
674
views
asked 8 months agolg...
I have an RDS PostgresSql database and an aurora postgres database set up currently and am trying to weigh how to merge them together.
For background info they are two different databases currently...
1
answers
0
votes
382
views
asked 8 months agolg...
> Multi-AZ DB clusters don't support the following features:
Amazon RDS Proxy
So how can I work with RDS Proxy if I use the multi az cluster structure? Do I need to add proxies to instances in...
2
answers
0
votes
486
views
asked 8 months agolg...
When will blue/green deployment be available for Postgresql?
What's the roadmap?
2
answers
0
votes
476
views
asked 8 months agolg...
Hello,
I (my organization) have AWS account where RDS Postgres instance is running. This instance has several databases. These databases are used by ERP application which hosted in EC2 ubuntu server....
1
answers
0
votes
281
views
asked 8 months agolg...
I am using the "RDS export snapshot to S3" feature to extract some tables from our Postgres RDS cluster.
The largest table in the export has
* 12 billion rows
* 35 columns
* 3TB in Postgres (not...
1
answers
0
votes
713
views
asked 8 months agolg...
We are currently in the process of migrating a Postgresql database from RDS to an S3 data lake. During our data migration, we noticed an important aspect related to transaction order preservation that...
1
answers
0
votes
740
views
asked 8 months agolg...
I'm trying to use the `aws_s3.table_import_from_s3` functionality and believe I have set everything up correctly according to:...
1
answers
0
votes
638
views
asked 8 months agolg...
Now and then I experience a performance/stability problem on our postgres RDS, which seems to be caused by a query from the ***rdsadmin ***user, on the ***rdsadmin ***database.
The query in question...
3
answers
0
votes
898
views
asked 8 months agolg...
Hello,
I'm trying to modify my RDS PostgreSQL instance class from "db.t3.2xlarge" to "db.m5.2xlarge".
I make the change using the portal and check the option to apply immediately. The status is shown...
1
answers
0
votes
185
views
asked 8 months agolg...
In Version 15.3 of Aurora PostgreSQL, log_checkpoints is on by default, It was off in Version 14.
There parameter is not visible in the Cluster Parameter Group and it is causing a lot of writing to...
0
answers
0
votes
91
views
asked 8 months agolg...