Questions tagged with Aurora PostgreSQL
Content language: English
Select up to 5 tags to filter
Sort by most recent
Browse through the questions and answers listed below or filter and sort to narrow down your results.
I need to import a CSV file from s3 bucket into my Aurora database table. However some fields could contain double quote character which will break the process.
```
32533|Lease changed from "12...
Accepted AnswerAurora PostgreSQL
1
answers
0
votes
877
views
asked 9 months agolg...
Update:
Turns out it is the call to SSM (Parameter Store) to get DB info that is timing out, so this is not actually related to Aurora Serverless.
Our staging environment is setup to scale down to 0...
1
answers
0
votes
366
views
asked 9 months agolg...
Recently had to terminate an SQL query "update cron.job_run_details" that was running indefintely on our RDS db, using SELECT pg_terminate_backend(<jobid>);
Since then, no cron jobs are running. I've...
2
answers
0
votes
787
views
asked 9 months agolg...
I'm using the new auto-rotation for RDS that doesn't require a lambda - https://docs.aws.amazon.com/secretsmanager/latest/userguide/rotate-secrets_turn-on-for-db.html
The problem I'm facing is...
1
answers
0
votes
306
views
asked 9 months agolg...
Is it possible to create a Cloudwatch chart of the number of Aurora Postgres read replica instances? I've searched the documents and list of available Cloudwatch metrics, but I can't find...
2
answers
0
votes
303
views
asked 9 months agolg...
Our timeline has shifted and I either need to cancel or postpone a major version upgrade and I can't seem to find a place in the management UI or aws cli to stop this from happening in the next...
1
answers
0
votes
516
views
asked 10 months agolg...
I am using below command to load data from s3 to postgresql database.
SELECT aws_s3.table_import_from_s3 (
'delta.t_etails',
'',
'(FORMAT csv, HEADER true, DELIMITER '','', QUOTE ''~'', ENCODING...
1
answers
0
votes
440
views
asked 10 months agolg...
I setup Postgraphile with postgres 15 and appsync. I am getting an error when logged in with cognito in the appsync console. Appsync is sending cognito username as cognito:username and it NEEDS to be...
0
answers
0
votes
78
views
asked 10 months agolg...
When setting an Aurora RDS PostgreSQL table to **unlogged**, will those **unlogged** tables still be available in **read replicas**?
Accepted AnswerAurora PostgreSQL
1
answers
0
votes
664
views
asked 10 months agolg...
Does Amazon Aurora Global Database support global reader endpoint, is it possible to load balance traffic across two regions using single reader endpoint.
1
answers
0
votes
304
views
asked 10 months agolg...
Hi, I am following this doc for copying CSV files from S3 directly into an Aurora serverless V2 database in RDS: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PostgreSQL.S3Import.html...
1
answers
0
votes
757
views
asked 10 months agolg...
i would like to know what is the main challenge facing with aws glue jobs when upgrading aurora postgresql 13.6 to aurora postgresql 14.3 ?
1
answers
0
votes
266
views
asked 10 months agolg...