Using pg_migrator to upgrade 8.3->8.4

Using pg_migrator to upgrade 8.3->8.4

am 01.02.2010 17:02:35 von 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 :)

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: Using pg_migrator to upgrade 8.3->8.4

am 01.02.2010 17:12:59 von 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 http://momjian.us
EnterpriseDB http://enterprisedb.com

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

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: Using pg_migrator to upgrade 8.3->8.4

am 01.02.2010 17:24:43 von 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.
>>=20
>> pg_migrator is an attractive option, but we have butted up again the
>> integer datetime timestamp problem:
>>=20
>> "Old and new pg_controldata date/time storage types do not match.
>>=20
>> You will need to rebuild the new server with configure
>> --disable-integer-datetimes or get server binaries built
>> with those options."
>=20
> Yep, that is necessary.
>=20
>> 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
>=20
>=20
> No idea if anyone is building RPMs for it. The source and Win32
> binaries are here:
>=20
> http://pgfoundry.org/frs/?group_id=3D1000235
>=20
>> 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...)?
>=20
> Nope.
>=20
> --=20
> Bruce Momjian http://momjian.us
> EnterpriseDB http://enterprisedb.com
>=20
> + If your life is a hard drive, Christ can be your backup. +


--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: Using pg_migrator to upgrade 8.3->8.4

am 01.02.2010 17:26:43 von 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 http://momjian.us
EnterpriseDB http://enterprisedb.com

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

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: Using pg_migrator to upgrade 8.3->8.4

am 01.02.2010 18:06:23 von devrim

--=-hIclEGxuG60NRyJrdcZT
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

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=20

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

%{!?intdatetimes:%define intdatetimes 1}

to=20

%{!?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,
--=20
Devrim GÜNDÜZ, RHCE
Command Prompt - http://www.CommandPrompt.com=20
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz

--=-hIclEGxuG60NRyJrdcZT
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: This is a digitally signed message part

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)

iEYEABECAAYFAktnCg4ACgkQtl86P3SPfQ6dhgCfcxc+clNauJylLJEB+J6w Af+8
VS8AoJpbACDYTCgTY/JVoJGahgywdimT
=tWtF
-----END PGP SIGNATURE-----

--=-hIclEGxuG60NRyJrdcZT--

Re: Using pg_migrator to upgrade 8.3->8.4

am 01.02.2010 21:27:08 von Mark Corner

Excuse by noobness, but where can I find the source RPMs for Centos? I sea=
rched for a while without luck.

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

Thanks!
-Mark


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

> Hi,
>=20
> On Mon, 2010-02-01 at 11:02 -0500, Mark Corner wrote:
>=20
>> 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=20
>=20
> You can grab spec file, patches, etc from SVN repository, change
>=20
> %{!?intdatetimes:%define intdatetimes 1}
>=20
> to=20
>=20
> %{!?intdatetimes:%define intdatetimes 0}
>=20
> 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 ;)
>=20
> Regards,
> --=20
> Devrim GÜNDÜZ, RHCE
> Command Prompt - http://www.CommandPrompt.com=20
> devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
> http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz


--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: Using pg_migrator to upgrade 8.3->8.4

am 01.02.2010 22:08:48 von devrim

--=-FPlHi5k443blB4vgbiQm
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Mon, 2010-02-01 at 15:27 -0500, Mark Corner wrote:
>=20
> 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.=20

https://projects.commandprompt.com/public/pgcore/repo/rpm/re dhat/

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

--=-FPlHi5k443blB4vgbiQm
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: This is a digitally signed message part

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)

iEYEABECAAYFAktnQt4ACgkQtl86P3SPfQ4SpgCgqIXS4VUyhggDGYCSUB4T LfDL
JVkAoM+Z1g5zilqGqJxUfz/79/8VpopB
=v5lR
-----END PGP SIGNATURE-----

--=-FPlHi5k443blB4vgbiQm--

Re: Using pg_migrator to upgrade 8.3->8.4

am 02.02.2010 12:57:52 von devrim

--=-xNrCvkqrsJgoD3e5F/Lk
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Mon, 2010-02-01 at 11:12 -0500, Bruce Momjian wrote:
>=20
>=20
> No idea if anyone is building RPMs for it=20

Of course I'm building ;)

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

--=-xNrCvkqrsJgoD3e5F/Lk
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: This is a digitally signed message part

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)

iEYEABECAAYFAktoEzgACgkQtl86P3SPfQ4WqACgzSUj0vU+zcNbRJiunDYq SVbs
NQsAn0tTH9JAHxrMAHBCxyXBNmPskZvL
=LrUe
-----END PGP SIGNATURE-----

--=-xNrCvkqrsJgoD3e5F/Lk--

Re: Using pg_migrator to upgrade 8.3->8.4

am 02.02.2010 20:00:41 von Bruce Momjian

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

Oh, wow, that's nice.

--=20
Bruce Momjian http://momjian.us
EnterpriseDB http://enterprisedb.com

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

--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: Using pg_migrator to upgrade 8.3->8.4

am 02.02.2010 21:32:21 von Mark Corner

=20
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:
>>>=20
>>>=20
>>> No idea if anyone is building RPMs for it=20
>>=20
>> Of course I'm building ;)
>>=20
>> We have pg_migrator 8.4.14 for RHEL/CentOS 4,5 and Fedora 12-i386.
>=20
> Oh, wow, that's nice.
>=20
> --=20
> Bruce Momjian http://momjian.us
> EnterpriseDB http://enterprisedb.com
>=20
> + If your life is a hard drive, Christ can be your backup. +


--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: Using pg_migrator to upgrade 8.3->8.4

am 02.02.2010 21:36:59 von 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 http://momjian.us
> > EnterpriseDB http://enterprisedb.com
> >
> > + If your life is a hard drive, Christ can be your backup. +

--
Bruce Momjian http://momjian.us
EnterpriseDB http://enterprisedb.com

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

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: Using pg_migrator to upgrade 8.3->8.4

am 02.02.2010 21:39:17 von Mark Corner

Yep, O will go down that road if I am not duplicating any work. In my expe=
rience building RPMS from SRPMS rarely just "works" :)

-Mark


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

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


--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: Using pg_migrator to upgrade 8.3->8.4

am 02.02.2010 22:47:17 von Tom Lane

Mark Corner 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

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin