Re: pg_upgrade and extra_float_digits

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: pg_upgrade and extra_float_digits
Дата
Msg-id 201005170018.o4H0IjX15856@momjian.us
обсуждение исходный текст
Ответ на Re: pg_upgrade and extra_float_digits  (Andrew Dunstan <andrew@dunslane.net>)
Ответы Re: pg_upgrade and extra_float_digits  (Andrew Dunstan <andrew@dunslane.net>)
Re: pg_upgrade and extra_float_digits  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Andrew Dunstan wrote:
> >> Eventually the idea would be to have the build farm run such tests (with
> >> a properly created dump file) so we can learn quickly if the backend
> >> data format is changed.
> >>     
> >
> > If we're thinking of doing that, it would be better to back-patch the
> > change that allowed '3'.
> >
> >             
> >   
> 
> Yeah.
> 
> It's going to require some fancy dancing to get the buildfarm to do it. 
> Each buildfarm run is for a specific branch, and all the built artefacts 
> are normally thrown away. I'd have to work out a way of stashing the 
> binaries from a build on one branch for use in the pg_upgrade tests in 
> the run on another branch. It's doable but could get messy.

Uh, that is not actually a problem.  You just need to set
extra_float_digits=-3 to create the dump file, which is only done once
for each major version.  You can _load_ that dump file into an
unmodified old cluster and test just fine.  I will write up some
instructions in the next few days.

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com


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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: Sort of a planner regression 8.3->8.4 (due to EXISTS inlining) and related stuff
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: pg_upgrade and extra_float_digits