From: Stephen Frost <sfrost@snowman.net>
To: Don Seiler <don@seiler.us>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Upgrade master/slave: rsync?
Date: Wed, 13 Sep 2017 12:53:35 -0400
Message-ID: <20170913165335.GY4628@tamriel.snowman.net> (raw)
In-Reply-To: <CAHJZqBAyNA121LKyxt9itVnK864hZkpP4=wCT5WP3_SWQ0PxzQ@mail.gmail.com>
References: <CAHJZqBA_Z_HYf13Mqg=T0uDWHpoxoUAxoAv3BUJsSPHNwNr+cw@mail.gmail.com>
<20170913162413.GX4628@tamriel.snowman.net>
<CAHJZqBAyNA121LKyxt9itVnK864hZkpP4=wCT5WP3_SWQ0PxzQ@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Don,
On these mailing lists, we really prefer it if people wouldn't
"top-post", instead add your comments in-line and eliminate text that
isn't relevant.
* Don Seiler (don@seiler.us) wrote:
> In the meantime I'll look at using the --link method and rsync. Probably
> should be using --link method on a larger database anyway to save time and
> disk space?
Yes, it's much more efficient, but I strongly recommend taking a backup
as close to before the upgrade as possible, being extremely careful
throughout the process, plan for a good bit of time above what the
actual commands take to run, and make sure that you have *tested* your
backup and *restore* process well and have strong confidence in it.
Thanks!
Stephen
Attachments:
signature.asc (application/pgp-signature, 818B) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: sfrost@snowman.net, don@seiler.us
Subject: Re: Upgrade master/slave: rsync?
In-Reply-To: <20170913165335.GY4628@tamriel.snowman.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox