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 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
101
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
233
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
139
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
193
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
75
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
131
views
asked 2 years agolg...