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,
I am interested in using CLI's for our Aurora PostgreSQL. When using through Interface if I restore a snapshot it creates cluster & DB instance.I understand when using CLI's first I need to...
1
answers
0
votes
203
views
asked 4 months agolg...
Hello,
Its db.r7g.8xlarge aurora postgres 32VCPU, 256GB RAM instance. PG version 15.4.
A non-partitioned table having ~4.8 billion rows in it and is having data size as ~1.4TB, row size as ~313 bytes...
0
answers
0
votes
239
views
asked 4 months agolg...
I'm trying to setup a blue/green deployment of my Postgres 14.10 database.
On the database, I can see the following settings.
| name | setting |
| --- | --- |
| max_logical_replication_workers | 4...
0
answers
0
votes
278
views
asked 4 months agolg...
Hi,
I have a use case for comparing two DB snapshot engine versions. From https://docs.aws.amazon.com/sdkfornet/latest/apidocs/items/TRDSDBSnapshotNET45.html, Engine Versions come as strings. Engine...
2
answers
0
votes
285
views
asked 4 months agolg...
Hi Folks,
Is it possible to Migration Azure CosmosDB postgres to Aurora Postgres?
could not find any clear indication if it is possible with DMS.
1
answers
0
votes
305
views
asked 4 months agolg...
I've just checked RDS recommendation with Postgresql Extended Support to be applied on Feb 2024. I wonder how would the price of instance and support would be. I want to know how much it would cost to...
1
answers
0
votes
854
views
asked 4 months agolg...
Hey guys. I have the following issues.
During normal operation and after initial load, once a day, pglogical crashes on the destination side, which is RDS aurora PGSQL 14.8 using pglogical....
0
answers
0
votes
358
views
asked 4 months agolg...
Hi,
We've been using the AWS Query Editor with no issues up until today for both our Aurora Serverless v1 clsuters and RDS Clusters with Aurora Serveless v2 instances.
The dropdown for "Database...
2
answers
4
votes
440
views
asked 5 months agolg...
I want to start using the "Application" tag so I can start segmenting my postgres cluster metrics.
My guess is that the way to do this is by setting the application_name para in the posgtres...
1
answers
0
votes
270
views
asked 5 months agolg...
I used SCT to convert the DDL below from DB2 to Aurora PostGreSQL.
DB2:
CREATE SEQUENCE XX_SCHEMA.SEQ_NO AS DECIMAL(9) START WITH 1 INCREMENT BY 1 MAXVALUE 9999999999 CYCLE;
then I got this DDL as...
0
answers
0
votes
175
views
asked 5 months agolg...
Currently, we are using the Aurora PostgreSQL instance class db.r5.large in our production environment. Due to performance-related issues, we are planning to upgrade the instance class to...
1
answers
0
votes
356
views
asked 5 months agolg...
We are using a RDS Postgres 15 and have a use case that requires disabling specific indexes using pg_index table but all attempts result in ERROR: permission denied for table pg_index .
We've tried...
1
answers
0
votes
445
views
asked 5 months agolg...