All Content tagged with Database

We have one RDS and We are operating two EC2s in different regions. However, because it is in a different region, the connection speed and query speed are very slow. So I want to try `Direct...

Do we need to set the pg_audit value at the database level? or can we set them in the parameter group commonly

I am doing a major version upgrade from postgres (with postgis extension) from version 15.7 to version 16.3 using aws blue/green deployment. I have followed the AWS guide and have encountered an error...

Hi! In my AWS environment I have several RDS instances that are created and connected to my dev environment on the cloud and secure via VPC. For local development until now I runned a docker...

We have a 'regional cluster' Aurora Mysql witth 4 instances, serverless v2 (0.5 to 6 ACUs) To cut down costs we need to reduce multi-AZ from 3 zone to 2 How ?!

I have a current db running with time zone UTC and I want to change the time zone GMT+7 for the same time in my country. I have researched and understand we can't do this with db running. We just...

hello, I'm a student who want to test RDS Failover, I need to know if the Ip changes or how much time it needs to reboot RDS. My teacher said that RDS have no downtime (disaster recovery feature) then...

Hi all, we are using cross-database queries and it seems like it is not possible to access materialized or regular views using it. Documentation...

Our corporate app responsible for day to day operations has ceased to allow management and users to log in. Attached is a screen shot of the error being provided. This is a business critical issue as...

I am trying to use RDS free tier but there is no option to select the instance class that is available for tier. As per AWS free tier "750 hrs of Amazon RDS in a Single-AZ db.t2.micro Instance." can...

We have RDS PostgreSQL and a Read Replica associated with it. We have noticed that the users created in the Primary cannot connect to the read replica. Are there additional steps required for the...

Hello I have a dc2.large Redshift cluster that I'm using to run some ETL processes, and I'm also using Metabase to generate dashboards from a table. This seems to put a strain on the database, as...