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 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
426
views
asked 9 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
75
views
asked 9 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
645
views
asked 9 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
287
views
asked 9 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
732
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
254
views
asked 10 months agolg...
pgvector for Auroralg...
Any plans on allowing us to use pgvector in Aurora?
4
answers
0
votes
1284
views
asked 10 months agolg...
I am trying to connect to my Aurora PostgreSQL db, you must forgive me for I am new to AWS.
these settings keep returning this error in datagrip
> DBMS: PostgreSQL (no ver.)
Case sensitivity:...
2
answers
0
votes
3441
views
asked 10 months agolg...
Hello,
I'd like to get a cloudwatch alert setup when a failover event occurs. Does anyone know what I should be looking for in the postgresql.log or what cloudwatch metric I can use for this?...
3
answers
0
votes
569
views
asked 10 months agolg...
Redshift Federated query to postresql failing with ERROR: authentication method 10 not supportedlg...
We are trying to do Federated query from Redshift to Aurora PostgreSQL DB with Redshift version 1.0.51973 and Aurora PG latest version 15.2, please find the steps we followed for the...
1
answers
0
votes
1153
views
asked 10 months agolg...
Hello,
I'm trying to figure out if there is a way with Aurora Serverless v2 to migrate tenants from one db instance to another.
Say for example that I'm using "Aurora Serverless v2 - Postgres...
1
answers
0
votes
278
views
asked 10 months agolg...
I need to migrate some large object data from pg_catalog and for that I need lo_compat_privileges to be set to ON but I can't do this as it is not modifiable. Is there a way to modify this?
Thanks
1
answers
0
votes
434
views
asked 10 months agolg...