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(dot)klaver(at)aklaver(dot)com