Обсуждение: Using pg_migrator to upgrade 8.3->8.4

Поиск
Список
Период
Сортировка

Using pg_migrator to upgrade 8.3->8.4

От
Mark Corner
Дата:
We are looking to upgrade out 8.3 db to 8.4.  The full dump and
restore is not very attractive due to the downtime involved.

pg_migrator is an attractive option, but we have butted up again the
integer datetime timestamp problem:

"Old and new pg_controldata date/time storage types do not match.

You will need to rebuild the new server with configure
--disable-integer-datetimes or get server binaries built
with those options."

We also noticed that the are non id rpms available for 8.3, but we
couldn't find any for 8.4 here:
https://projects.commandprompt.com/public/pgcore

So, is the best option to compile postgres from source?  Is there
anyway to change the storage of timestamps in our 8.3 db online (I am
guessing no...)?

Mostly I just need a sanity check before I waste a bunch of time :)

Re: Using pg_migrator to upgrade 8.3->8.4

От
Bruce Momjian
Дата:
Mark Corner wrote:
> We are looking to upgrade out 8.3 db to 8.4.  The full dump and
> restore is not very attractive due to the downtime involved.
>
> pg_migrator is an attractive option, but we have butted up again the
> integer datetime timestamp problem:
>
> "Old and new pg_controldata date/time storage types do not match.
>
> You will need to rebuild the new server with configure
> --disable-integer-datetimes or get server binaries built
> with those options."

Yep, that is necessary.

> We also noticed that the are non id rpms available for 8.3, but we
> couldn't find any for 8.4 here:
> https://projects.commandprompt.com/public/pgcore


No idea if anyone is building RPMs for it.  The source and Win32
binaries are here:

    http://pgfoundry.org/frs/?group_id=1000235

> So, is the best option to compile postgres from source?  Is there
> anyway to change the storage of timestamps in our 8.3 db online (I am
> guessing no...)?

Nope.

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

  + If your life is a hard drive, Christ can be your backup. +

Re: Using pg_migrator to upgrade 8.3->8.4

От
Mark Corner
Дата:
All good info...

With respect to RPMs, I was actually referring to postgres84 rpms with non-integer datetime prebuilt.

On Feb 1, 2010, at 11:12 AM, Bruce Momjian wrote:

> Mark Corner wrote:
>> We are looking to upgrade out 8.3 db to 8.4.  The full dump and
>> restore is not very attractive due to the downtime involved.
>>
>> pg_migrator is an attractive option, but we have butted up again the
>> integer datetime timestamp problem:
>>
>> "Old and new pg_controldata date/time storage types do not match.
>>
>> You will need to rebuild the new server with configure
>> --disable-integer-datetimes or get server binaries built
>> with those options."
>
> Yep, that is necessary.
>
>> We also noticed that the are non id rpms available for 8.3, but we
>> couldn't find any for 8.4 here:
>> https://projects.commandprompt.com/public/pgcore
>
>
> No idea if anyone is building RPMs for it.  The source and Win32
> binaries are here:
>
>     http://pgfoundry.org/frs/?group_id=1000235
>
>> So, is the best option to compile postgres from source?  Is there
>> anyway to change the storage of timestamps in our 8.3 db online (I am
>> guessing no...)?
>
> Nope.
>
> --
>  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
>  EnterpriseDB                             http://enterprisedb.com
>
>  + If your life is a hard drive, Christ can be your backup. +


Re: Using pg_migrator to upgrade 8.3->8.4

От
Bruce Momjian
Дата:
Mark Corner wrote:
> All good info...
>
> With respect to RPMs, I was actually referring to postgres84
> rpms with non-integer datetime prebuilt.

Oh, I don't think anyone has made any of those, but I can see it
would be useful.

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

  + If your life is a hard drive, Christ can be your backup. +

Re: Using pg_migrator to upgrade 8.3->8.4

От
Devrim GÜNDÜZ
Дата:
Hi,

On Mon, 2010-02-01 at 11:02 -0500, Mark Corner wrote:

> We also noticed that the are non id rpms available for 8.3, but we
> couldn't find any for 8.4 here:
> https://projects.commandprompt.com/public/pgcore

You can grab spec file, patches, etc from SVN repository, change

%{!?intdatetimes:%define intdatetimes 1}

to

%{!?intdatetimes:%define intdatetimes 0}

and build packages on your server. I don't have any interest to push
non-id packages to repository, unless my boss specifically asks me to do
so ;)

Regards,
--
Devrim GÜNDÜZ, RHCE
Command Prompt - http://www.CommandPrompt.com
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz

Вложения

Re: Using pg_migrator to upgrade 8.3->8.4

От
Mark Corner
Дата:
Excuse by noobness, but where can I find the source RPMs for Centos?  I searched for a while without luck.

And which svn repository are you referring to?  I assume not the postgres CVS repo.

Thanks!
-Mark


On Feb 1, 2010, at 12:06 PM, Devrim GÜNDÜZ wrote:

> Hi,
>
> On Mon, 2010-02-01 at 11:02 -0500, Mark Corner wrote:
>
>> We also noticed that the are non id rpms available for 8.3, but we
>> couldn't find any for 8.4 here:
>> https://projects.commandprompt.com/public/pgcore
>
> You can grab spec file, patches, etc from SVN repository, change
>
> %{!?intdatetimes:%define intdatetimes 1}
>
> to
>
> %{!?intdatetimes:%define intdatetimes 0}
>
> and build packages on your server. I don't have any interest to push
> non-id packages to repository, unless my boss specifically asks me to do
> so ;)
>
> Regards,
> --
> Devrim GÜNDÜZ, RHCE
> Command Prompt - http://www.CommandPrompt.com
> devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
> http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz


Re: Using pg_migrator to upgrade 8.3->8.4

От
Devrim GÜNDÜZ
Дата:
On Mon, 2010-02-01 at 15:27 -0500, Mark Corner wrote:
>
> Excuse by noobness, but where can I find the source RPMs for Centos?
> I searched for a while without luck.

http://yum.pgsqlrpms.org/srpms

> And which svn repository are you referring to?  I assume not the
> postgres CVS repo.

https://projects.commandprompt.com/public/pgcore/repo/rpm/redhat/

Regards,
--
Devrim GÜNDÜZ, RHCE
Command Prompt - http://www.CommandPrompt.com
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz

Вложения

Re: Using pg_migrator to upgrade 8.3->8.4

От
Devrim GÜNDÜZ
Дата:
On Mon, 2010-02-01 at 11:12 -0500, Bruce Momjian wrote:
>
>
> No idea if anyone is building RPMs for it

Of course I'm building ;)

We have pg_migrator 8.4.14 for RHEL/CentOS 4,5 and Fedora 12-i386.
--
Devrim GÜNDÜZ, RHCE
Command Prompt - http://www.CommandPrompt.com
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz

Вложения

Re: Using pg_migrator to upgrade 8.3->8.4

От
Bruce Momjian
Дата:
Devrim G�ND�Z wrote:
-- Start of PGP signed section.
> On Mon, 2010-02-01 at 11:12 -0500, Bruce Momjian wrote:
> >
> >
> > No idea if anyone is building RPMs for it
>
> Of course I'm building ;)
>
> We have pg_migrator 8.4.14 for RHEL/CentOS 4,5 and Fedora 12-i386.

Oh, wow, that's nice.

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

  + If your life is a hard drive, Christ can be your backup. +

Re: Using pg_migrator to upgrade 8.3->8.4

От
Mark Corner
Дата:
So are the RPMs for postgres with non-integer datetimes available? :)  For centos? :)

On Feb 2, 2010, at 2:00 PM, Bruce Momjian wrote:

> Devrim GÜNDÜZ wrote:
> -- Start of PGP signed section.
>> On Mon, 2010-02-01 at 11:12 -0500, Bruce Momjian wrote:
>>>
>>>
>>> No idea if anyone is building RPMs for it
>>
>> Of course I'm building ;)
>>
>> We have pg_migrator 8.4.14 for RHEL/CentOS 4,5 and Fedora 12-i386.
>
> Oh, wow, that's nice.
>
> --
>  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
>  EnterpriseDB                             http://enterprisedb.com
>
>  + If your life is a hard drive, Christ can be your backup. +


Re: Using pg_migrator to upgrade 8.3->8.4

От
Bruce Momjian
Дата:
Mark Corner wrote:
>
> So are the RPMs for postgres with non-integer datetimes available? :)  For centos? :)

No, but you were told how to modify the RPM configuration file to build
it that way, I think.

---------------------------------------------------------------------------


>
> On Feb 2, 2010, at 2:00 PM, Bruce Momjian wrote:
>
> > Devrim G?ND?Z wrote:
> > -- Start of PGP signed section.
> >> On Mon, 2010-02-01 at 11:12 -0500, Bruce Momjian wrote:
> >>>
> >>>
> >>> No idea if anyone is building RPMs for it
> >>
> >> Of course I'm building ;)
> >>
> >> We have pg_migrator 8.4.14 for RHEL/CentOS 4,5 and Fedora 12-i386.
> >
> > Oh, wow, that's nice.
> >
> > --
> >  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
> >  EnterpriseDB                             http://enterprisedb.com
> >
> >  + If your life is a hard drive, Christ can be your backup. +

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

  + If your life is a hard drive, Christ can be your backup. +

Re: Using pg_migrator to upgrade 8.3->8.4

От
Mark Corner
Дата:
Yep, O will go down that road if I am not duplicating any work.  In my experience building RPMS from SRPMS rarely just
"works":) 

-Mark


On Feb 2, 2010, at 3:36 PM, Bruce Momjian wrote:

> Mark Corner wrote:
>>
>> So are the RPMs for postgres with non-integer datetimes available? :)  For centos? :)
>
> No, but you were told how to modify the RPM configuration file to build
> it that way, I think.
>
> ---------------------------------------------------------------------------
>
>
>>
>> On Feb 2, 2010, at 2:00 PM, Bruce Momjian wrote:
>>
>>> Devrim G?ND?Z wrote:
>>> -- Start of PGP signed section.
>>>> On Mon, 2010-02-01 at 11:12 -0500, Bruce Momjian wrote:
>>>>>
>>>>>
>>>>> No idea if anyone is building RPMs for it
>>>>
>>>> Of course I'm building ;)
>>>>
>>>> We have pg_migrator 8.4.14 for RHEL/CentOS 4,5 and Fedora 12-i386.
>>>
>>> Oh, wow, that's nice.
>>>
>>> --
>>> Bruce Momjian  <bruce@momjian.us>        http://momjian.us
>>> EnterpriseDB                             http://enterprisedb.com
>>>
>>> + If your life is a hard drive, Christ can be your backup. +
>
> --
>  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
>  EnterpriseDB                             http://enterprisedb.com
>
>  + If your life is a hard drive, Christ can be your backup. +


Re: Using pg_migrator to upgrade 8.3->8.4

От
Tom Lane
Дата:
Mark Corner <mcorner@gmail.com> writes:
> Yep, O will go down that road if I am not duplicating any work.  In my experience building RPMS from SRPMS rarely
just"works" :) 

Really?  It's supposed to.  At least at Red Hat, the RPMs *are* built
from the SRPMs, nothing behind the curtain.  In recent releases they're
even built in a minimally-loaded chroot to ensure that there are not any
missing BuildRequires: (which did use to be a hazard).

            regards, tom lane