we are trying to move all database data to other location. we chose to perform pg_dump and we encountered few problems:
first was out of memory problem: during pg_dump initialization we get an error:
pg_dump: saving search_path =
pg_dump: saving database definition
out of memory
then we gave to VM +16GB of RAM, so 24GB in total, the pg_dump process passed it and now we have another problem:
pg_dump: dumping contents of table lob_messages
Write failed: Connection reset by peer
Error occurs so far only on this "lob_messages" table, this table is huge - pgAdmin shows 256GB size. I have tried pg_dump all the database, after that error i have tried only pg_dump on that exact table. Error still occurs.
Here is df -h view:
i have tried to make pg_dump file on /mnt mounted NAS storage and also locally in /var/lib/postgresql/9.4/main
error remains. Can you share some wisdom what i'm doing wrong? During that error (connection reset by peer) i got disconect from the server, but only on that session where pg_dump is run. On other connection (monitoring htop) remains connected during that error.