Re: Pg-Upgrade standbys via rsync... and avoid sending UNlogged data?

From: Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>
To: Bruce Momjian <bruce(at)momjian(dot)us>, Stephen Frost <sfrost(at)snowman(dot)net>
Cc: Jerry Sievers <gsievers19(at)comcast(dot)net>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Pg-Upgrade standbys via rsync... and avoid sending UNlogged data?
Date: 2016-08-05 13:04:19
Message-ID: 4f3868e0-d3e5-11a7-939b-f143543d4bcb@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On 8/4/16 6:55 PM, Bruce Momjian wrote:
> <para>
> + Unfortunately, <application>rsync</> also needlessly copies the
> + files associated with temporary and unlogged tables.
> If you have tablespaces, you will need to run a similar
> <application>rsync</> command for each tablespace directory. If you
> have relocated <filename>pg_xlog</> outside the data directories,

That seems like an odd location to insert that.

--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Bruce Momjian 2016-08-05 14:05:21 Re: Pg-Upgrade standbys via rsync... and avoid sending UNlogged data?
Previous Message Bruce Momjian 2016-08-04 22:55:36 Re: Pg-Upgrade standbys via rsync... and avoid sending UNlogged data?