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.
Hi,
In a Aurora PostgreSQL table, we would like to setup TTL (Time-to-live) kind of thing, where rows will expire or will be deleted automatically after few hours/days.
What is the best way to do...
1
answers
0
votes
1429
views
asked 6 months agolg...
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
249
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
354
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
97
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
366
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
385
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
182
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
176
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
119
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
321
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
246
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
419
views
asked 6 months agolg...