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.
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
184
views
asked 6 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
181
views
asked 6 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
121
views
asked 6 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
332
views
asked 6 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
253
views
asked 6 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
428
views
asked 6 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
342
views
asked 6 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
133
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
387
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
155
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
84
views
asked 7 months agolg...
Hello all,
We are planning to use aurora Postgres and mysql for few applications. But wanted some guidance on which instance, class type should we use for lower environment/non prod like...
2
answers
0
votes
298
views
asked 7 months agolg...