On 11/4/18 2:55 PM, Charles Martin wrote:
Yep, you called it:

Nov  2 20:30:45 localhost kernel: Out of memory: Kill process 30438 (postmaster) score 709 or sacrifice child Nov  2 20:30:45 localhost kernel: Killed process 30438, UID 26, (postmaster) total-vm:3068900kB, anon-rss:1695392kB, file-rss:1074692kB

So it's running out of memory when trying to dump this table. The "old" server has 4GB of ram, the "new" server 20GB.


In addition to the other suggestions, what is the exact pg_dump command you are using?


--
Adrian Klaver
adrian.kla...@aklaver.com

Reply via email to