Re: Upgrade master/slave: rsync?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxx>        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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin



[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux