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

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>
Cc: Stephen Frost <sfrost(at)snowman(dot)net>, 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 14:05:21
Message-ID: 20160805140521.GA5093@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Fri, Aug 5, 2016 at 09:04:19AM -0400, Peter Eisentraut wrote:
> 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.

Would you like to suggest another location as I could not find out.

--
Bruce Momjian <bruce(at)momjian(dot)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 +

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Bruce Momjian 2016-08-05 14:06:44 Re: Pg-Upgrade standbys via rsync... and avoid sending UNlogged data?
Previous Message Peter Eisentraut 2016-08-05 13:04:19 Re: Pg-Upgrade standbys via rsync... and avoid sending UNlogged data?