Re: Upgrade master/slave: rsync?

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: Don Seiler <don(at)seiler(dot)us>
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Upgrade master/slave: rsync?
Date: 2017-09-13 16:53:35
Message-ID: 20170913165335.GY4628@tamriel.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-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(at)seiler(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Don Seiler 2017-09-13 16:56:08 Re: Upgrade master/slave: rsync?
Previous Message Don Seiler 2017-09-13 16:50:00 Re: Upgrade master/slave: rsync?