Re: unexpected EOF on client connection during pg_dumpall

From: Robert Burgholzer <rburghol(at)vt(dot)edu>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: unexpected EOF on client connection during pg_dumpall
Date: 2013-08-05 13:39:25
Message-ID: CACT-NGLr_7p6nNT_c3TRxa0iUZNr4LJ6rft89+BncA5Ly9i=OA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Armand du Plessis 2013-08-05 16:00:48 relfrozenxid not getting reset even after manual VACUUM
Previous Message Arnold, Sandra L. 2013-08-05 13:31:41 Re: unexpected EOF on client connection during pg_dumpall