Marc G. Fournier wrote: > On Wed, 21 Dec 2005, Jan Wieck wrote: > >> The timestamps st_last_event_ts (origin) and st_last_received_ts >> (subscriber) are taken on different servers. If you play around with >> the clocks of them you will find also settings where sl_status >> reports them to be in the future. > > > Hrmmm, for this sort of thing, might it not be smarter to have slon > record based on GMT? That is what the problem was, that server was > recording based on GMT while the rest were AST ...
It uses timestamp with timezone, which means that it'll be *consistent*. It is a "recommended practice" to use UTC/GMT <http://linuxfinances.info/info/requirements.html>; as with security issues, how YOU choose to configure things is YOUR choice; some approaches may not turn out so well, as you see... _______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
