Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

Creating paths and listens

Create paths to other nodes

Slony-I needs path information, that defines how a slon process can communicate to other nodes. The conninfo string takes a connect string as described in the libpq connection documentation. Usually, you will need to specify host, dbname and username, while the password should be stored in the .pgpass file.
You must create a path to every other node, on each node. For example, in a two node cluster you need to create a path to the slave on the master, and one to the master on the slave.

Create listens to other nodes

After the communication path has been defined, the slon processes need to be advised to listen to events from other nodes.
Note: This step is not necessary for Slony-I v1.1 and later, because listen information is generated automatically when paths are defined.


Popular posts from this blog

How to Get Table Size, Database Size, Indexes Size, schema Size, Tablespace Size, column Size in PostgreSQL Database

7 Steps to configure BDR replication in postgresql

How to find the server is whether standby (slave) or primary(master) in Postgresql replication ?

PostgreSQL Monitoring Tools

PostgreSQL pgBadger