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.
I'm trying to write a script to upgrade an RDS PostgreSQL instance from version x to version y. Since RDS only supports direct upgrades to certain versions, the script uses multiple "hops" to upgrade,...
0
answers
0
votes
63
views
asked 11 days agolg...
This is a related question for AWS Aurora PostgreSQL: https://repost.aws/questions/QUF12RpagpTey5vszbg4Fm9w/pg-ivm-plugin-for-aurora-postgresql
0
answers
2
votes
363
views
asked 21 days agolg...
I have an Aurora PostgreSQL regional cluster database (version 15.5), with one writer instance and two reader instances. This database has a large partitioned table with 97 partitions of varying...
0
answers
0
votes
47
views
asked a month agolg...
I am trying out DMS as a proof of concept from postgres RDS to postgres RDS - when migrating a databse containing only 1 table no problem is encountered however when attempting to migrate a larger...
0
answers
1
votes
77
views
asked 2 months agolg...
In a new pipeline we are adding to our product, we are collecting a bunch of data from different sources with something similar to keywords. The collected data is mainly text with associated metadata....
0
answers
0
votes
116
views
asked 2 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
211
views
asked 2 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
251
views
asked 2 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
325
views
asked 2 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
131
views
asked 2 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
97
views
asked 3 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
111
views
asked 3 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
137
views
asked 4 months agolg...