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.
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
140
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
137
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
106
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
240
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
144
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
201
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
79
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
135
views
asked 2 years agolg...