On 2018-Jul-27, PG Bug reporting form wrote:
> While testing a migration procedure on a database (v9.6.9) from floating
> point datetimes to int64 (v9.6.9) using pglogical i saw that after the
> initial data sync all the subsequent replicated rows containing dates are
> getting nonsensical datetime values in the subscriber.
> I've read:
> https://www.postgresql.org/message-id/flat/26788.1487455319%40sss.pgh.pa.us#26788.1487455319@sss.pgh.pa.us
> So I know that this is not something new, but i was wondering if there is
> any way around this,
As I recall, pglogical has a way to indicate transmission of data using
the text representation rather than binary, which should fix this
problem.
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services