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-08 20:46:06
Message-ID: 20160808204606.GA16417@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Sun, Aug 7, 2016 at 09:29:20PM -0400, Peter Eisentraut wrote:
> On 8/5/16 10:06 AM, Bruce Momjian wrote:
> > On Fri, Aug 5, 2016 at 10:05:21AM -0400, Bruce Momjian wrote:
> >> 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.
> >
> > Sorry, typo: :-(
> >
> > Would you like to suggest another location as I could not find one.
>
> I think it belongs to the previous paragraph, so I moved it there.

OK, fine.

--
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

Browse pgsql-admin by date

  From Date Subject
Next Message dbyzaa@163.com 2016-08-11 06:24:49 how can I know WAL insert location When the primary crash
Previous Message Tom Lane 2016-08-08 16:45:10 Re: Database 'template1' vacuum