Re: Patch for pg_upgrade to turn off autovacuum

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: Patch for pg_upgrade to turn off autovacuum
Дата
Msg-id 201104212222.p3LMMg117746@momjian.us
обсуждение исходный текст
Ответ на Re: Patch for pg_upgrade to turn off autovacuum  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Patch for pg_upgrade to turn off autovacuum  (Jeff Davis <pgsql@j-davis.com>)
Re: Patch for pg_upgrade to turn off autovacuum  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
Tom Lane wrote:
> Bruce Momjian <bruce@momjian.us> writes:
> > Tom Lane wrote:
> >> Huh?  Why would that be?  Seems like you've done something in the wrong
> >> place if that's an issue.
> 
> > Yeah, it is complicated.  I don't really care if autovacuum runs on the
> > old cluster (we only move the files while the server is down).  We only
> > want autovacuum not to mess with the relfrozenxids we set on the new
> > cluster while the table file is empty.
> 
> > The other issue is that the old alpha binary will not know about the -b
> > flag and hence will not start.
> 
> Well, once again, why are you trying to do that?  It's not the source
> postmaster that needs this flag.

Well, consider that this also locks out non-super users so I figured it
would be good to run the old and new in the same binary upgrade mode. 
Again, we can do just the new cluster for 9.1.   I can also control the
behavior based on the catalog version number, which seems the most
logical.

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + It's impossible for everything to be true. +


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Patch for pg_upgrade to turn off autovacuum
Следующее
От: Jeff Davis
Дата:
Сообщение: Re: Patch for pg_upgrade to turn off autovacuum