AWS RDS export to s3, is giving me a very wrong error, that is, my s3 bucket is not in same region

It appears that you're encountering an unexpected error message when trying to export your RDS database to S3, specifically stating that your S3 bucket is not in the same region as your RDS instance, even though you're certain they are in the same region.

This error message can sometimes be misleading and may not accurately reflect the root cause of the issue. Here are a few things to consider and try:

1. Double-check the IAM role permissions: Ensure that the IAM role you're using for the export has the necessary permissions to access both RDS and S3. The role should have policies that allow actions like "s3:PutObject", "s3:GetObject", and "s3:ListBucket" on your S3 bucket.

2. Verify the trust relationship: Make sure the IAM role's trust relationship allows the RDS export service to assume it. The trust policy should include "export.rds.amazonaws.com" as a trusted entity.

3. Check for S3 bucket policy restrictions: Your S3 bucket might have a policy that restricts access based on VPC endpoints or specific IP ranges. Ensure that the bucket policy allows access from the RDS export service.

4. Examine CloudTrail logs: Look at the CloudTrail event history to see if there are any specific errors or access denied messages that might provide more insight into the issue.

5. Try creating a new S3 bucket: As a test, try creating a new S3 bucket in the same region and attempt the export to this new bucket.

6. Verify KMS key permissions: If you're using encryption, ensure that the KMS key policy allows the RDS export service to use the key.

7. Consider using a different region: As a troubleshooting step, you could try exporting to a bucket in a different region to see if the error persists.

If none of these steps resolve the issue, it may be worth contacting AWS support for further assistance, as this could potentially be a service-side issue or a more complex configuration problem.
Sources
i want to export rds db to the amazon s3 but facing this issue i already created the role export-rds-db-s3 with s3 full access and glue console full access | AWS re:Post
Failure messages for Amazon S3 export tasks for Amazon RDS - Amazon Relational Database Service
When using the RDS export to s3 feature, export records are not saved in certain regions. | AWS re:Post

Hi,

Please review the below AWS documentation to verify that required S3 permissions are configured to access the Amazon S3 bucket from RDS instance. The documentation also includes the limitations with S3 export from RDS.

• https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/postgresql-s3-export.html
• https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/postgresql-s3-export.html

Also, please refer to the below blog posts for sample setup and configuration to perform export and import data from S3 to RDS,

• https://aws.amazon.com/blogs/database/export-and-import-data-from-amazon-s3-to-amazon-aurora-postgresql/
• https://aws.amazon.com/blogs/database/work-with-files-in-amazon-aurora-postgresql/

I encountered the same issue; however, a few months ago I successfully exported to the same bucket using the same configuration. Is there a solution?