This post has been de-listed
It is no longer included in search results and normal feeds (front page, hot posts, subreddit posts, etc). It remains visible only via the author's post history.
Well, I am currently an intern at a company and they want me to help their client migrate from MYSQL to PostgreSQL. I figured a way out using docker. I created a dump file of the current database of the client, then I pushed that dump to docker container and shift it to postgres container using pgloader coz pgloader isn't available or working for windows I guess. Thus, now I have the whole database on postgres container, which I am able to access on my local machine by making a connection through pgadmin4 using the container port. But when I am trying to create a dump file for postgres database, the size of that dump file is coming out to be only 13Mb, while the size of the database is 156Mb and even the size of the dump file of client's MYSQL was around 130Mb ish (somewhere around that, give or take 5mb). while taking the backup I kept the format as custom and included all the base, pre-post and the actual data.
Can someone help me. Thanks in Advance!
P.S: If I have posted this at the wrong place, plz ignore this and do let me know where should I post it. Sorry!
Subreddit
Post Details
- Posted
- 2 months ago
- Reddit URL
- View post on reddit.com
- External URL
- reddit.com/r/PostgreSQL/...