| From: | Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com> |
|---|---|
| To: | Bruce Momjian <bruce(at)momjian(dot)us> |
| 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 01:29:20 |
| Message-ID: | bbc8fd84-b4b4-d70b-3c2c-1e41678674cc@2ndquadrant.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Johan Fredriksson | 2016-08-08 07:26:40 | Re: [PERFORM] Create language plperlu Error |
| Previous Message | Patrick B | 2016-08-07 20:32:43 | Re: fe_sendauth: no password supplied - PostgreSQL 9.2 |