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.
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
141
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
107
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
242
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
147
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
204
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
80
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
136
views
asked 2 years agolg...