Re: [ADMIN] Using pg_migrator to upgrade 8.3->8.4

2010-02-02 Thread 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 dat

Re: [ADMIN] Using pg_migrator to upgrade 8.3->8.4

2010-02-02 Thread 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

Re: [ADMIN] Using pg_migrator to upgrade 8.3->8.4

2010-02-01 Thread Mark Corner
-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 reposit

Re: [ADMIN] Using pg_migrator to upgrade 8.3->8.4

2010-02-01 Thread 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

[ADMIN] Using pg_migrator to upgrade 8.3->8.4

2010-02-01 Thread 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.