Search Postgresql Archives

Re: Need help in transferring FP to Int64 DateTime

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

On 06/06/2012 09:20 AM, Benson Jin wrote:
Hi All,

I am sure this question has been asked before, however, I failed to find
any related topics in the internet. We have a database about 100GB in
size. It was started back in 7.x days and has been upgraded along the
way to 9.0. Because of the historical reason, all timestamps are stored
in FloatingPoint. To use pg9, we had to compile it with FP support
instead of the default Int64. Some recent research shows that PG team
will eventually dump FP support in favor of int64 in future, we figured
we need to make the move to Int64 before the database gets even larger.
The challenge we now face is how to "convert" the database fast enough,
so that required down time is minimized. Searching through the internet
for 2 days yields little fruit so far... Can someone please provide
enlighten us?

A thought. Dependent on sufficient disk space.

Use one of the trigger based(non-binary) replication tools i.e. Slony, Bucardo, etc.
Compile a Postgres 9.0 instance using the default of integer timestamps.
Set up replication PG 9.0 FP --> PG 9.0 integer
Once the standby is close to the primary, shut off access to the primary and let the standby completely catch up.
Shut down the primary and promote the standby as the new primary.

I have not actually done this, which is why I propose it as a thought. Hopefully, others will weigh in on the advisability of the above.


Bo Jin

Adrian Klaver

Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:

[Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Programming PHP]     [Kernel Newbies]     [PHP Classes]     [Find Someone Nice]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

Add to Google Powered by Linux