Unanswered 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.
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...
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
357
views
asked 4 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
172
views
asked 4 months agolg...
The situation is I have a RDS cluster running with RDS instance in it. Sometimes when we update the stack for RDS cluster it deletes the physical resource and re creates it. But as the RDS instance is...
0
answers
0
votes
114
views
asked 5 months agolg...
Hello,
On my DEV env, the type public.geometry is missing, the postgis extension is already exists and in use by other schema (i can't drop and create because of that), and if i am trying to create...
0
answers
0
votes
131
views
asked 5 months agolg...
I am having a hard time connecting my RDS DB to Tableau for a dashboard I need to build. I am looking for guidance how what to do. Anything helps! It is set as publicly available and we have also set...
0
answers
0
votes
149
views
asked 6 months agolg...
i ve created a rds postgres instance and AWS managed in the same VPC . created the user in AD and RDS. when i try to connect to RDS via Kerberos authentcation from the domin joined EC2, am getting the...
0
answers
0
votes
89
views
asked 6 months agolg...
Is it possible to provision a Redis cache specifically for a single schema on an AWS PostgreSQL RDS, and what strategies can be employed to ensure data consistency between the Redis cache and the...
0
answers
0
votes
104
views
asked 6 months agolg...
The documentation for PostgreSQL RDS mentions an extension `rds_tools`, and there are at least 2 functions in it (`rds_version()` and `role_password_extension_type()` ) that are mentioned in passing...
0
answers
0
votes
188
views
asked 7 months agolg...
I have implemented a AWS DMS task to replicate RDS PostgreSQL (source) changes to Kinesis Data Streams (target). At the moment, the task is responsible for only replicating a single table, which is a...
0
answers
0
votes
125
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...