Обсуждение: Using pg_migrator to upgrade 8.3->8.4
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 :)
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. +
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. +
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. +
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
Вложения
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
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
Вложения
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
Вложения
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. +
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. +
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. +
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. +
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