On 06/07/2012 08:29 AM, Benson Jin wrote:
> Hi Adrian,
>
> Thanks for the suggestion! We thought about that too, but concerned about the possible performance
penalty trigger based replication would bring. If there is no other
alternative, we will give
your suggestion a try...
AFAIK there is no direct way to do a binary fp timestamp --> integer
timestamp conversion, otherwise pg_upgrade would handle it. To make that
jump it needs to go through a text based representation. That leaves a
dump/restore cycle or non-binary replication.
>
> Cheers,
>
> Benson
>
--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com