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 have a Postgre RDS instance running in a t3.medium. I am running a code that reads a csv in 250k chunks abd my issue is that after I bulk insert this 250k rows in a table, the database seems to get...
1
answers
0
votes
261
views
asked 6 months agolg...
I am trying to set up a Glue Job that automatically crawls a source Aurora RDS Postgres instance and writes it another instance in a different cluster.
I was able to perform an initial copy/load via...
1
answers
0
votes
383
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...
I created connections to RDS and Redshift in AWS Glue connections. Both connections worked when running Test Connection and Crawler. I see that once in a while RDS connection test fails throwing a...
2
answers
1
votes
403
views
asked 6 months agolg...
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
423
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
188
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
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...
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
351
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
262
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
441
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
357
views
asked 7 months agolg...