pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedUsing pg_migrator to upgrade 8.3->8.4
13+ messages / 4 participants
[nested] [flat]
* Using pg_migrator to upgrade 8.3->8.4
@ 2010-02-01 16:02 Mark Corner <mcorner@gmail.com>
0 siblings, 2 replies; 13+ messages in thread
From: Mark Corner @ 2010-02-01 16:02 UTC (permalink / raw)
To: pgsql-admin
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 :)
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Using pg_migrator to upgrade 8.3->8.4
@ 2010-02-01 16:12 Bruce Momjian <bruce@momjian.us>
parent: Mark Corner <mcorner@gmail.com>
1 sibling, 2 replies; 13+ messages in thread
From: Bruce Momjian @ 2010-02-01 16:12 UTC (permalink / raw)
To: Mark Corner <mcorner@gmail.com>; +Cc: 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@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Using pg_migrator to upgrade 8.3->8.4
@ 2010-02-01 16:24 Mark Corner <mcorner@gmail.com>
parent: Bruce Momjian <bruce@momjian.us>
1 sibling, 1 reply; 13+ messages in thread
From: Mark Corner @ 2010-02-01 16:24 UTC (permalink / raw)
To: Bruce Momjian <bruce@momjian.us>; +Cc: 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=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. +
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Using pg_migrator to upgrade 8.3->8.4
@ 2010-02-01 16:26 Bruce Momjian <bruce@momjian.us>
parent: Mark Corner <mcorner@gmail.com>
0 siblings, 0 replies; 13+ messages in thread
From: Bruce Momjian @ 2010-02-01 16:26 UTC (permalink / raw)
To: Mark Corner <mcorner@gmail.com>; +Cc: 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@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Using pg_migrator to upgrade 8.3->8.4
@ 2010-02-01 17:06 Devrim GÜNDÜZ <devrim@gunduz.org>
parent: Mark Corner <mcorner@gmail.com>
1 sibling, 1 reply; 13+ messages in thread
From: Devrim GÜNDÜZ @ 2010-02-01 17:06 UTC (permalink / raw)
To: Mark Corner <mcorner@gmail.com>; +Cc: pgsql-admin
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
Attachments:
signature.asc (application/pgp-signature, 197B) download
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Using pg_migrator to upgrade 8.3->8.4
@ 2010-02-01 20:27 Mark Corner <mcorner@gmail.com>
parent: Devrim GÜNDÜZ <devrim@gunduz.org>
0 siblings, 1 reply; 13+ messages in thread
From: Mark Corner @ 2010-02-01 20:27 UTC (permalink / raw)
To: Devrim GÜNDÜZ <devrim@gunduz.org>; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Using pg_migrator to upgrade 8.3->8.4
@ 2010-02-01 21:08 Devrim GÜNDÜZ <devrim@gunduz.org>
parent: Mark Corner <mcorner@gmail.com>
0 siblings, 0 replies; 13+ messages in thread
From: Devrim GÜNDÜZ @ 2010-02-01 21:08 UTC (permalink / raw)
To: Mark Corner <mcorner@gmail.com>; +Cc: pgsql-admin
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
Attachments:
signature.asc (application/pgp-signature, 197B) download
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Using pg_migrator to upgrade 8.3->8.4
@ 2010-02-02 11:57 Devrim GÜNDÜZ <devrim@gunduz.org>
parent: Bruce Momjian <bruce@momjian.us>
1 sibling, 1 reply; 13+ messages in thread
From: Devrim GÜNDÜZ @ 2010-02-02 11:57 UTC (permalink / raw)
To: Bruce Momjian <bruce@momjian.us>; +Cc: Mark Corner <mcorner@gmail.com>; pgsql-admin
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
Attachments:
signature.asc (application/pgp-signature, 197B) download
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Using pg_migrator to upgrade 8.3->8.4
@ 2010-02-02 19:00 Bruce Momjian <bruce@momjian.us>
parent: Devrim GÜNDÜZ <devrim@gunduz.org>
0 siblings, 1 reply; 13+ messages in thread
From: Bruce Momjian @ 2010-02-02 19:00 UTC (permalink / raw)
To: Devrim GÜNDÜZ <devrim@gunduz.org>; +Cc: Mark Corner <mcorner@gmail.com>; pgsql-admin
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. +
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Using pg_migrator to upgrade 8.3->8.4
@ 2010-02-02 20:32 Mark Corner <mcorner@gmail.com>
parent: Bruce Momjian <bruce@momjian.us>
0 siblings, 1 reply; 13+ messages in thread
From: Mark Corner @ 2010-02-02 20:32 UTC (permalink / raw)
To: Bruce Momjian <bruce@momjian.us>; +Cc: Devrim GÜNDÜZ <devrim@gunduz.org>; 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Ü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. +
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Using pg_migrator to upgrade 8.3->8.4
@ 2010-02-02 20:36 Bruce Momjian <bruce@momjian.us>
parent: Mark Corner <mcorner@gmail.com>
0 siblings, 1 reply; 13+ messages in thread
From: Bruce Momjian @ 2010-02-02 20:36 UTC (permalink / raw)
To: Mark Corner <mcorner@gmail.com>; +Cc: Devrim GÜNDÜZ <devrim@gunduz.org>; 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@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. +
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Using pg_migrator to upgrade 8.3->8.4
@ 2010-02-02 20:39 Mark Corner <mcorner@gmail.com>
parent: Bruce Momjian <bruce@momjian.us>
0 siblings, 1 reply; 13+ messages in thread
From: Mark Corner @ 2010-02-02 20:39 UTC (permalink / raw)
To: Bruce Momjian <bruce@momjian.us>; +Cc: Devrim GÜNDÜZ <devrim@gunduz.org>; pgsql-admin
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. +
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Using pg_migrator to upgrade 8.3->8.4
@ 2010-02-02 21:47 Tom Lane <tgl@sss.pgh.pa.us>
parent: Mark Corner <mcorner@gmail.com>
0 siblings, 0 replies; 13+ messages in thread
From: Tom Lane @ 2010-02-02 21:47 UTC (permalink / raw)
To: Mark Corner <mcorner@gmail.com>; +Cc: Bruce Momjian <bruce@momjian.us>; Devrim GÜNDÜZ <devrim@gunduz.org>; pgsql-admin
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
^ permalink raw reply [nested|flat] 13+ messages in thread
end of thread, other threads:[~2010-02-02 21:47 UTC | newest]
Thread overview: 13+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-02-01 16:02 Using pg_migrator to upgrade 8.3->8.4 Mark Corner <mcorner@gmail.com>
2010-02-01 16:12 ` Bruce Momjian <bruce@momjian.us>
2010-02-01 16:24 ` Mark Corner <mcorner@gmail.com>
2010-02-01 16:26 ` Bruce Momjian <bruce@momjian.us>
2010-02-02 11:57 ` Devrim GÜNDÜZ <devrim@gunduz.org>
2010-02-02 19:00 ` Bruce Momjian <bruce@momjian.us>
2010-02-02 20:32 ` Mark Corner <mcorner@gmail.com>
2010-02-02 20:36 ` Bruce Momjian <bruce@momjian.us>
2010-02-02 20:39 ` Mark Corner <mcorner@gmail.com>
2010-02-02 21:47 ` Tom Lane <tgl@sss.pgh.pa.us>
2010-02-01 17:06 ` Devrim GÜNDÜZ <devrim@gunduz.org>
2010-02-01 20:27 ` Mark Corner <mcorner@gmail.com>
2010-02-01 21:08 ` Devrim GÜNDÜZ <devrim@gunduz.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox