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.
Hi AWS expert, I have a code read data from AWS aurora PostgreSQL, I want to bookmark the table with custom column named 'ceres_mono_index'. But it seems like the bookmark is still uses the primary...
1
answers
0
votes
1633
views
asked a year agolg...
Newer versions of Amazon Aurora PostgreSQL-compatible edition are now available and database cluster(s) running Aurora PostgreSQL minor versions 11.13, 11.14, 11.15, 12.8, 12.10, 13.4, 13.5, and 13.6...
0
answers
0
votes
400
views
We are streaming the CDC data using DMS and clients are consuming it. While consuming the DMS event, clients are unable to identify primary key in a DMS event. Do we have any transformation rule of...
3
answers
0
votes
560
views
asked a year agolg...
Is there a way we can refresh a limited set of data from Prod AWS account to Dev AWS account PostgreSQL database?
For e.g., I have to refresh few rows from couple of tables of Prod to Dev DB. I don't...
2
answers
0
votes
377
views
asked a year agolg...
Hi, I'm trying to create a copy of an Aurora PostgreSQL cluster snapshot in a different region using the aws cli, I was able to do it five times, but now I'm getting the error message **Cannot copy...
0
answers
0
votes
85
views
asked a year agolg...
Would it be possible to setup an Aurora serverless v2 in us-east-1 and have a read replica in another region (us-west-2)? How could we do this via console?
1
answers
0
votes
934
views
asked a year agolg...
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?
0
answers
0
votes
25
views
asked a year agolg...
How can we change SQLNET.ENCRYPTION_CLIENT = Accepted to Requested in Oracle_FDW extension? Which parameter has to be changed?
1
answers
0
votes
33
views
asked a year agolg...
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...
Accepted AnswerAurora PostgreSQL
1
answers
0
votes
630
views
asked a year agolg...
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...
1
answers
0
votes
256
views
asked a year agolg...
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...
1
answers
0
votes
1668
views
asked a year agolg...
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...
1
answers
0
votes
363
views
asked a year agolg...