Date: Tue, 19 Sep 2017 15:41:58 -0400
From: Bruce Momjian <bruce@momjian.us>
To: Don Seiler <don@seiler.us>
Cc: Stephen Frost <sfrost@snowman.net>,
	pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Upgrade master/slave: rsync?
Message-ID: <20170919194158.GC15391@momjian.us>
References: 
 <CAHJZqBA_Z_HYf13Mqg=T0uDWHpoxoUAxoAv3BUJsSPHNwNr+cw@mail.gmail.com>
 <20170913162413.GX4628@tamriel.snowman.net>
 <CAHJZqBAyNA121LKyxt9itVnK864hZkpP4=wCT5WP3_SWQ0PxzQ@mail.gmail.com>
 <20170913165335.GY4628@tamriel.snowman.net>
 <CAHJZqBAnpTO651fm16uDysNTOdJeOy_X=F2DfFstc87UFzTOFg@mail.gmail.com>
 <CAHJZqBDmY2UtD0YBbp+YGnvR0ARWwnRwEMsDibKrc37LWpqFcg@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: 
 <CAHJZqBDmY2UtD0YBbp+YGnvR0ARWwnRwEMsDibKrc37LWpqFcg@mail.gmail.com>
User-Agent: Mutt/1.5.23 (2014-03-12)
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

On Wed, Sep 13, 2017 at 03:01:50PM -0500, Don Seiler wrote:
> Thinking more on this in my situation. The databases I've inherited have the
> default system tables in the default tablespaces under $PGDATA (/var/lib/pgsql/
> 9.2/data), but then also has most of the app-specific data on separate
> tablespaces outside of the data directory (eg various directories under /opt/
> postgres). Of course this also means the various symlinks to these from $PGDATA
> /pg_tblspc. For these, pg_upgrade will create a new directory
> (PG_9.6_201608131) with hard-links (assuming I used the --link option) to the
> old PG_9.2_201204301 directory, and then add symlinks from the new 9.6 $PGDATA
> directory to the tablespace location.
> 
> I'm just trying to walk through this in my head. I'd need to run a similar
> rsync command for each of these. For example, for tablespace foo with location
> /opt/postgres/foo:
> 
> cd /opt/postgres/foo
> rsync --archive --delete --hard-links --size-only PG_9.2_201204301
> PG_9.6_201608131 standby.host.com:/opt/postgres/foo

Yes.

> And then rinse & repeat for any others similar tablespaces for each standby/
> slave?
> 
> Another question. I have one slave in the same datacenter as the master, the
> other slaves are in the DR data center across the country. I'm assuming I could
> sync those DR slaves from the local slave? That way I can get the master back
> online and serving requests as soon as the local slave is successfully upgraded
> rather than waiting for rsync over the WAN? And then one DR slave could be
> copied from the other so I only have to do the WAN rsync once (especially if
> it's a downstream standby in a cascading scenario)?

Yes.

I think you will find answers to these questions in the updated
pg_upgrade docs that were backpatched to 9.5:

	https://www.postgresql.org/docs/9.6/static/pgupgrade.html

-- 
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

+ As you are, so once was I.  As I am, so you will be. +
+                      Ancient Roman grave inscription +


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin