Re: pg_control is missing a field for LOBLKSIZE

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: pg_control is missing a field for LOBLKSIZE
Дата
Msg-id 20140617230138.GG3666@momjian.us
обсуждение исходный текст
Ответ на Re: pg_control is missing a field for LOBLKSIZE  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Ответы Re: pg_control is missing a field for LOBLKSIZE  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Tue, Jun 17, 2014 at 03:55:02PM -0400, Alvaro Herrera wrote:
> Bruce Momjian wrote:
> > On Tue, Jun 17, 2014 at 12:28:46PM -0400, Tom Lane wrote:
> > > Bruce Momjian <bruce@momjian.us> writes:
> > > > Uh, I think pg_upgrade needs to check that they match too.
> > > 
> > > Possibly.  What do you think it should do when examining a pg_control
> > > version that lacks the field?
> > 
> > Good question.  I have existing cases where fields were removed, but not
> > ones that were added.  As we have no way to query the old cluster's
> > value for LOBLKSIZE, I think I will just add code to compare them if
> > they _both_ exist.
> 
> Can't you compare it to the historic default value?  I mean, add an
> assumption that people thus far has never tweaked it.

Well, if they did tweak it, then they would be unable to use pg_upgrade
because it would complain about a mismatch if they actually matched the
old and new servers.

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + Everyone has their own god. +



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

Предыдущее
От: Andreas Karlsson
Дата:
Сообщение: Re: [REVIEW] psql tab completion for DROP TRIGGER/RULE and ALTER TABLE ... DISABLE/ENABLE
Следующее
От: Tom Lane
Дата:
Сообщение: Re: UPDATE SET (a,b,c) = (SELECT ...) versus rules