Charles Martin <ssappeals@xxxxxxxxx> writes: > 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. That's kind of odd: a COPY shouldn't really consume very much working memory. I suspect that much of the process's apparent VM consumption may be shared buffers ... what have you got shared_buffers set to on the old server? If it's more than half a GB or so, maybe reducing it would help. regards, tom lane
