[Pgpool-general] what does "master node" mean in context of replication in pgpoolII?

Marcin Krol mrkafk at gmail.com
Fri Jan 14 16:30:16 UTC 2011


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hello everyone,

When I enable replication in pgpool II 3.0.1, does the "master node"
have any special significance? I have found (by experiment) that INSERTs
 get propagated to all nodes instantly as far as I can tell, so how does
one node differ from another node?

There is a caveat, but rather small one:

"caution: Stop autovacuum on the master node (the first node which is up
and running). Autovacuum may change the contents of the database and
might cause inconsistency after online recovery if it's runnung."

Other caveats?

And how do I find out which node is master node from viewpoint of pgpool
anyway?


- --

Regards,
mk

- --
Premature optimization is the root of all fun.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iQEcBAEBAgAGBQJNMHoYAAoJEFMgHzhQQ7hOPSwH/jcQMMBEcsYur2dIt82hIBqO
Ano6E7qT9rL++wj7mfgenY5J5EoHX/IzmiA8xecI2JmLFYsWYjn35ZQMU3jtrrF/
jGqNBxxo3T2nBxhW7fnCbMFBWXwN04H0WtR3MEV7nFvP0wc1MIBlkVXly9OPz3Bj
z5UW4kBNxMcM6sSOl5QP8oFhFyPUYMbvp+U9hQTfT16iAwntHv51k7yo8abKSG/B
n4wjEpTmWLEmUjoFXPal5uH4K+jWd1C8tbxYL4vIkBHoIjPmW9DXeAJkiuBJ/SLk
GRZS/UDegKyTiNpKOdw6cH9Df9HWBlEpD7GLvmfieaFjafOwUSS7kJzPAkgFf2E=
=RAXE
-----END PGP SIGNATURE-----


More information about the Pgpool-general mailing list