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

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

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 datetimes available? :) For >> ce

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

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

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

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

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

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

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

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

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

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

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

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

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

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 attractive due

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

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