Re: Implementing Replication via pgAdmin

Daniel B. Thurman wrote:
> Thanks Dave.
> 
> But I am having some trouble trying to get replication to work.
> 
> Here is what I did:
> 
> 1) On master server:
>    a) I registered: lib/slevent.dll
>    b) I register as a service: slon -regservice
>    c) slon -listengines
>       2 engine(s) registered for service 'Slony-I'
>       Engine 1: E:\Program Files\PostgreSQL\8.2\data\slon.conf
>       Engine 2: E:\Program Files\PostgreSQL\8.2\data\master.conf
>    d) Started the slon service via manage->services
> 
> 2) On Slave Server
>    a) I registered: lib/slevent.dll
>    b) I register as a service: slon -regservice
>    c) slon -listengines
>       2 engine(s) registered for service 'Slony-I'
>       Engine 1: E:\Program Files\PostgreSQL\8.2\data\slon.conf
>       Engine 2: E:\Program Files\PostgreSQL\8.2\data\slave.conf
>    d) Started the slon service via manage->services

Why did you register 2 engines on each? For a simple master-slave setup
you would only need one engine for the master and one for the slave.

> 3) Launched: pgAdmin3 (v1.6.2)

You might want to try 1.8 beta 5. There have been some useful
improvements to the Slony code.

>    a) Created Master Server Connection
>    b) Selected database: MyTest
>    c) Right-clicked Replication object, selected from menu: New slony-I Cluster ...
>    d) Join existsing cluster: [unchecked]
>       Server: <Master-Server-Name> [Greyed out]
>       Database: MyTest [Entered data]
>       Cluster Name: <Master-HostName>-Master-Cluster [entered data]
>       Local Node: 1,  Value: "Master Node" [entered data]
>       Admin Node: 99, Value: "pgAdmin Node" [entered data]
>       Comment: <empty> [no data entered]
>    d) Clicked OK and Completed structure shows:
>       <Master Hostname>-Master-Cluster
>         Nodes (2)
>           Master Node
>             Paths (0)
>             listens (0)
>           pgAdmin Node
>             Paths (1)
>               Master Node
>             listens (1)
>               Master Node (Master Node)
>         Replication Sets (0)

OK.

>     At this point, I tried to add a slave node but was unable to:
>     a) I tried (on Master server) connection:

Setup the slave on the slave, not the master.

> 
>     b) Then I tried (on Slave Server) connection:
>       1) Right-clicked Replication object, selected from menu: New slony-I Cluster ...
>       2) Join existing cluster: [checked]
>          Server: <Slave-Server-Name> [Initially was Greyed out, but active after a delay]
>          Database: MyTest [unchanged]
>          Cluster Name: <empty> [dropdown shows empty list and not selecteable]
>          Local Node: <empty>, Value: <empty>
>          Admin Node: <empty>, Value: <empty>
>          Comment: <empty>
> 
>       At this point, it makes no sense to enter any fields after 'Cluster Name' since
>       the 'Cluster Name' must have a value and 'OK' remains greyed out.

Yeah, iirc that could happen on earlier versions of pgAdmin. Install a
copy of 1.8 beta 5 (it'll install alongside your current copy) and try
that. It should work more as you would expect.

Regards, Dave.