Re: unexpected EOF on client connection during pg_dumpall - Mailing list pgsql-admin

From Robert Burgholzer
Subject Re: unexpected EOF on client connection during pg_dumpall
Date
Msg-id CACT-NGLr_7p6nNT_c3TRxa0iUZNr4LJ6rft89+BncA5Ly9i=OA@mail.gmail.com
Whole thread Raw
In response to Re: unexpected EOF on client connection during pg_dumpall  ("Arnold, Sandra L." <arnoldsl@ornl.gov>)
List pgsql-admin
FWIW - if you are looking at a backup approach with the dumpall, I have found that using a rsync to just mirror the file system is waaaaaaaay faster, and hence less prone to interuption.  This is how it is recommended with a warm standby development, and works great, and also is far less consumptive of system resources. The big limitation is that if you are duplicating for an upgrade, it might be problematic since the file system dupes are PG Version specific I think.

regards,
r.b.

pgsql-admin by date:

Previous
From: "Arnold, Sandra L."
Date:
Subject: Re: unexpected EOF on client connection during pg_dumpall
Next
From: Armand du Plessis
Date:
Subject: relfrozenxid not getting reset even after manual VACUUM