All Content tagged with Database

Hello, I have a very small site in WP in Lightdsail. I got a "en error establishing a database connection" first then I reboot the instance and now the site cannot be reached. The instance is suppose...

ust a simple thing like storing MySQL connectionstring in a parameterStore secure variable is a major PIA: Since our RDS MySQL is in a VPC, my Lambda needs to be there also - then you need to setup V...

Hi community, I need to store hourly and daily data for about 6,000 assets in my PostgreSQL Aurora DB. Given the scale, I plan to keep three years of daily data and three months of hourly data. Addit...

Hello, We have function called trigger_neptune_loader_job(), which has following functionalities: 1. Connecting to Neptune and sets up S3 access. 2. Clears existing data in the Neptune cluster. 3. Ide...

I created a parameter group and adjusted the queryConcurrency and queryQueueSize to 0. I applied the group to the running Timestream InfluxDB database. After a while, it went into a **FAILED** status....

I am experiencing issues with my Amazon RDS instances, which currently show the status "**Inaccessible-encryption-credentials**." The affected instances are: Website Production Aurora (Regional Clus...

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

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

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