Re: Pg-Upgrade standbys via rsync... and avoid sending UNlogged data? - Mailing list pgsql-admin

From Peter Eisentraut
Subject Re: Pg-Upgrade standbys via rsync... and avoid sending UNlogged data?
Date
Msg-id bbc8fd84-b4b4-d70b-3c2c-1e41678674cc@2ndquadrant.com
Whole thread Raw
In response to Re: Pg-Upgrade standbys via rsync... and avoid sending UNlogged data?  (Bruce Momjian <bruce@momjian.us>)
Responses Re: Pg-Upgrade standbys via rsync... and avoid sending UNlogged data?
List pgsql-admin
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.


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


pgsql-admin by date:

Previous
From: Patrick B
Date:
Subject: Re: fe_sendauth: no password supplied - PostgreSQL 9.2
Next
From: Johan Fredriksson
Date:
Subject: Re: [PERFORM] Create language plperlu Error