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

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: Pg-Upgrade standbys via rsync... and avoid sending UNlogged data?
Дата
Msg-id 20160808204606.GA16417@momjian.us
обсуждение исходный текст
Ответ на Re: Pg-Upgrade standbys via rsync... and avoid sending UNlogged data?  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Список 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@momjian.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 +


В списке pgsql-admin по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Database 'template1' vacuum
Следующее
От: "dbyzaa@163.com"
Дата:
Сообщение: how can I know WAL insert location When the primary crash