Questions tagged with Aurora PostgreSQL
Content language: English
Sort by most recent
How do we enable TLS in ORACLE_FDW. As I understand we need to create a wallet and ingest the server side certificate. But how do we do that? Is that even possible?
How can we change SQLNET.ENCRYPTION_CLIENT = Accepted to Requested in Oracle_FDW extension? Which parameter has to be changed?
Hello Team
Is it possible to downgrade my Aurora Postgres instance from db.t3.large to db.t3.small , im not getting the option to choose the smaller instance when i try to modify the instance.
regards
we have our data in AWS RDS postgres db. We have a table with around 100-200 rows and we loaded up 200M rows in 3 hours timeframe. That table is indexed as well. And now we want to insert more data into the table and we see that adding 20M rows is taking 5 hours.
Our instance size is db.r6g.xlarge. And we have two AZ. I want to know the reason for slower performance in query operation and what is the best way to import that huge data into postgres table.
I need to change the default timezone of AWS Aurora PostgreSQL cluster from UTC to CST. We can change it by creating a custom cluster parameter group and then use it in the cluster.
Now my question is what will happen during daylight savings? Will there be any impact of daylight savings to the DB cluster? Do we need to make any change regarding daylight savings in the cluster, instance? Do we need to reboot the cluster?
Please suggest.
To generate a bash script to automate the process of creating snapshots of aroura psql database backup and export the same to s3 bucket with aws iam credentials cron job for every 3 hours and hold snapshots for 30 days
I am trying to export a snapshot to an S3 bucket, from our Aurora Postgres Serverless v2 cluster. I keep getting the following error message: "The specified db snapshot engine mode isn't supported and can't be exported."
AFAICT from the user guide, Serverless v2 does support exporting snapshots to S3: https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-export-snapshot.html
Our engine is Aurora PostgreSQL, version 10.21, region is eu-west-1, encrypted.
In the CLI doc for [creating db instance](https://docs.aws.amazon.com/cli/latest/reference/rds/create-db-instance.html) and [creating db cluster ](https://docs.aws.amazon.com/cli/latest/reference/rds/create-db-cluster.html), it is mentioned that if publicly accessible flag is not specified explicitly, then the behavior is dependent on DBSubnetGroupName being specified or not. In my case, I specified the DBSubnetGroup which consists of public subnets and yet, the db instances created were not publicly accessible.
Hello Team,
IHAC who has EKS cluster pods connecting to Aurora Postgresql Global Database Primary cluster endpoint. During an outage in the primary region, customer wants to point the EKS pods to the DB endpoint in secondary region. customer is familiar with process of failover from the database end.
Are there any best practices for switching EKS cluster pods from Primary cluster endpoint to secondary cluster endpoint? Do we have a circuit breaker solution that can be implemented.
Customer must point to the DB cluster endpoints and RDS proxy cannot be leveraged due to SSL Cert Requirement.
Best practices for EKS database Connection handling during failover.
Thanks,
Karthik
asked a month ago
Hello,
We plan to, but have not yet migrated to a supported major version of Aurora PostgreSQL since major version 10 was deprecated on January 31. In the [announcement](https://repost.aws/questions/QU0ligxMlJSJWhzzgKbKgytQ/announcement-amazon-aurora-postgre-sql-10-x-end-of-support-is-january-31-2023), it was stated that forced major version upgrades would only be performed during a maintenance window.
If our cluster is marked for automatic upgrade at some point, would this be visible like the usual [pending maintenance actions](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_UpgradeDBInstance.Maintenance.html#USER_UpgradeDBInstance.Maintenance.Viewing)? Would AWS notify us through some other channel? While we are actively preparing to perform this upgrade, we would appreciate knowing when/if it's going to be applied during the maintenance window on any given week.
Thanks!
When I browse on Snapshots for RDS, I see a lot of public snapshots around 216 . Are these the snapshots that other accounts shared with me ? Will I be charged for them?
Is it safe to use them and how can I secure them ?
Are there any constraints regarding the size of private subnets for Aurora serverless v2 nodes? I've tested a scenario with /28 subnets, which seems to work without any problems, but I'd like to make sure I'm not missing something important.
[From the documentation:](https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/USER_VPC.WorkingWithRDSInstanceinaVPC.html)
> The CIDR blocks in each of your subnets must be large enough to accommodate spare IP addresses for Amazon Aurora to use during maintenance activities, including failover and compute scaling. For example, a range such as 10.0.0.0/24 and 10.0.1.0/24 is typically large enough.
A /24 for a single node per AZ seems to be rather wasteful IMHO.