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 [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

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 [at] momjian.us> 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 [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

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=3D1000235
>
>> 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 [at] momjian.us> 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 [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

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 [at] momjian.us> 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 [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

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

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=C3=9CND=C3=9CZ, 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

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

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=DCND=DCZ 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=DCND=DCZ, 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


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

--=-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:
>
> 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/re dhat/

Regards,
--
Devrim G=C3=9CND=C3=9CZ, 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

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

--=-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:
>
>
> 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=C3=9CND=C3=9CZ, 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

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

Devrim G=DCND=DCZ 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 [at] momjian.us> 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 [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

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=DCND=DCZ 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 [at] momjian.us> 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 [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

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 [at] momjian.us> http://momjian.us
> > EnterpriseDB http://enterprisedb.com
> >
> > + If your life is a hard drive, Christ can be your backup. +

--
Bruce Momjian <bruce [at] momjian.us> 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 [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

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:
>>
>> So are the RPMs for postgres with non-integer datetimes available? :) F=
or 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 [at] momjian.us> http://momjian.us
>>> EnterpriseDB http://enterprisedb.com
>>>
>>> + If your life is a hard drive, Christ can be your backup. +
>
> --
> Bruce Momjian <bruce [at] momjian.us> 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 [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Mark Corner <mcorner [at] 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

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