Christopher Browne cbbrowne
Wed Oct 6 16:21:16 PDT 2004
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Fiel Cabral wrote:
| My PostgreSQL server only accepts encrypted SSL
| connections.
| Will slony1 be able to connect to it?
| -Fiel Cabral

This should present no problem.

There are two components of Slony-I that connect to databases:
~ - slonik, the configuration tool, and
~ - slon, the replication daemon

Both simply use libpq to connect to PostgreSQL instances:

[postgres at marge bin]$ ldd slon
	libpq.so.3 => /opt/OXRS/dbs/pgsql742-2004-06-17/lib/libpq.so.3 (0xb75d4000)
	libpthread.so.0 => /lib/tls/libpthread.so.0 (0xb75bb000)
	libc.so.6 => /lib/tls/libc.so.6 (0xb7483000)
	libcrypt.so.1 => /lib/libcrypt.so.1 (0xb7456000)
	libresolv.so.2 => /lib/libresolv.so.2 (0xb7444000)
	libnsl.so.1 => /lib/libnsl.so.1 (0xb742f000)
	/lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0xb75eb000)
[postgres at marge bin]$ ldd slonik
	libpq.so.3 => /opt/OXRS/dbs/pgsql742-2004-06-17/lib/libpq.so.3 (0xb75d4000)
	libc.so.6 => /lib/tls/libc.so.6 (0xb7493000)
	libcrypt.so.1 => /lib/libcrypt.so.1 (0xb7466000)
	libresolv.so.2 => /lib/libresolv.so.2 (0xb7454000)
	libnsl.so.1 => /lib/libnsl.so.1 (0xb743f000)
	libpthread.so.0 => /lib/tls/libpthread.so.0 (0xb742f000)
	/lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0xb75eb000)

They do not use any special protocols.

You'll have a slon for each replication node; the slon instances do not
communicate via any special protocol; they do all of their communication
~ by leaving messages/events in the database instances, so all that is
needed is ordinary database connections via libpq.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.5 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFBZA1lCVn6LJfHIAIRArYJAKDgR9QMaiVh5gi4az3bdU1MZwu4EwCguBCx
UYvBhx6dcovevynIP9YMymw=
=CzdI
-----END PGP SIGNATURE-----


More information about the Slony1-general mailing list