[Pgpool-general] What is the recommended way to migrate a DB to replicate it with pgpool
Christian Nolte
ch.nolte at noltec.org
Wed Aug 8 13:15:26 UTC 2007
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi!
I have a huge DB here which I would like to replicate with pgpool.
pgpool is configured for replication with two (backend-) servers. This
DB has now to be replicated and the way which makes sense to me is to do
a dump and sending it to the pgpool backend (pgpool listens on port 5432
here):
$ pg_dump -d to_be_replicated -h host_to_be_replicated -o -F c | \
pg_restore -d replicated_db -h host_replicated
Is this the correct way for getting a consistent replicated DB?
Best regards!
Christian
- --
For more than 4 generations the IT Professionals were the
guardians of quality and stability in software. Before the
dark times. Before Microsoft...
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org
iD8DBQFGucHuCNjA0nfhW7wRAhvYAJ4lxddIvtrrNfytWpRGlO48/L4QEgCfdzjW
hkM2SBRXBrJSRd6p1TAeIo8=
=Z8SD
-----END PGP SIGNATURE-----
More information about the Pgpool-general
mailing list