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 ve created a rds postgres instance and AWS managed in the same VPC . created the user in AD and RDS. when i try to connect to RDS via Kerberos authentcation from the domin joined EC2, am getting the...
0
answers
0
votes
91
views
asked 6 months agolg...
Hello everyone,
I've received an unexpected charge on my AWS account. The charge was made under "Relational Database Service".
Is this because I've connected my EC2 to my RDS upon creation of my RDS...
1
answers
0
votes
223
views
asked 6 months agolg...
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
1658
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
263
views
asked 7 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
389
views
asked 7 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 7 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
407
views
asked 7 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
435
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
193
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
361
views
asked 7 months agolg...