Unanswered Questions tagged with 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,
I'm using DMS version 3.4.6 to ingest data in S3 from a table in the Aurora database. The type of task in the DMS I'm using is full-load-and-cdc and when I run the task for the first time it...
0
answers
0
votes
122
views
asked 2 years agolg...
I have a situation where the DB has a primary key field say "id" with an autoincrement or UUID auto generations field. I am using AWS RDS Postgres database.
Options 1 (Preferred) - The CSV I want to...
0
answers
0
votes
142
views
asked 2 years agolg...
Hello. We want migrate to AuroraDB.
1. We have postgres RDS database instance in us-east-1
2. Created Aurora Read-replica in same region
3. Try to promote read-replica
See blank screen in UI.
Tried to...
0
answers
0
votes
143
views
asked 2 years agolg...
I am doing refactoring from Oracle to postgres. All the tables data migrated from Oracle to postgressql. I am having issue with one table, below error found in postgres log files. Please let me know...
0
answers
0
votes
108
views
asked 2 years agolg...
In my AWS DMS Task
Source - MongoDB
Target - RDS Postgres SQL
I am able to apply column filter and only 3 selected columns gets migrated to target.
But if source mongo document contains an object...
0
answers
0
votes
244
views
asked 2 years agolg...
I'm performance testing some tables in both RDS Postgres and MySQL with the following configurations:
* Tested each on `db.m6g.4xlarge` and `db.m6g.xlarge` instance type
* 1024 GiB storage each
*...
0
answers
0
votes
149
views
asked 2 years agolg...
I am trying to load data from an EC2 instance into Redshift tables but cannot figure out how to do this using the copy command. I have tried the following to create the sql queries:
```
def...
0
answers
0
votes
207
views
asked 2 years agolg...
Hello,
We recently upgraded from aurora pg 12.4 to aurora 13.4 and after that, we noticed that this query stopped working,
`select sum(allocated) from aurora_stat_memctx_usage()`
I did not see...
0
answers
0
votes
81
views
asked 2 years agolg...
There is a postgis function called [ST_Transform](https://postgis.net/docs/ST_Transform.html) to transform the coordinates to a different spatial reference system. This function receives the original...
0
answers
0
votes
137
views
asked 2 years agolg...