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.klaver@xxxxxxxxxxx
