[Pgpool-general] Pgpool and/or Slony

[Andrew Sullivan]

On Fri, Jan 12, 2007 at 02:31:29PM -0500, Brad Nicholson wrote:
> With slony, now() will get fired on the master, update foo with the
> timestamp, and then replicate that exact timestamp to the subscribers.
> 
> With pgpool you will get the value of now() on each server, which are
> very likely not going to match.

I believe this particular limitation is no longer true (if ever it
was), in that pgpool has some intelligence about translating this
sort of data in some cases.  The key thing, however, is that there
_are_ cases where statement-based replication has some difficulties,
and some of them can't be worked around in principle.

A

-- 
Andrew Sullivan  | ajs at crankycanuck.ca
Information security isn't a technological problem.  It's an economics
problem.
		--Bruce Schneier