Questions tagged with PostgreSQL

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...

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...

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...

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...

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...

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...

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...

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...

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...

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?

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...

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...