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.
We have a RDS - PostgreSQL db.
Auto snapshots are taken every day. Would like to change the frequency to once every week. I did not see a way to do it. Looks like I can only control the backup...
2
answers
0
votes
444
views
asked 7 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
190
views
asked 7 months agolg...
I need to provide a custom list of stop words to my postgres DB. To do this I need to update the stopwords file in $SHAREDIR/tsearch_data/.
Is it possible to do upload a file to an AWS rds instance?
1
answers
0
votes
200
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
126
views
asked 7 months agolg...
Hello community,
After we've setting up green deployment we noticed that parameter "default_transaction_read_only" in the DB parameter groups didn't work properly (we have disabled this parameter, but...
2
answers
0
votes
369
views
asked 7 months agolg...
We need to scale down the gp3 storage of our RDS instance (PostgreSQL) using DMS. Can anyone provide a tutorial video or general steps on how to do it?
2
answers
0
votes
270
views
asked 7 months agolg...
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
456
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
366
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
138
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
408
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
160
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...