Re: Implementing Replication via pgAdmin

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
servicevia 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
servicevia manage->services 

3) Launched: pgAdmin3 (v1.6.2)  a) Created Master Server Connection  b) Selected database: MyTest  c) Right-clicked
Replicationobject, 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
[entereddata]     Local Node: 1,  Value: "Master Node" [entered data]     Admin Node: 99, Value: "pgAdmin Node"
[entereddata]     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)
ReplicationSets (0) 
   At this point, I tried to add a slave node but was unable to:   a) I tried (on Master server) connection:     1)
Right-clickedReplication object, selected from menu: New slony-I Cluster ...     2) Join existing cluster: [checked]
   Server: Master-Server-Name [no change]        Database: MyTest [no change]        Cluster-name: <Master-Server-Name>
      Local Node: 2, Value: "Slave Node" [entered data]        Admin node: "99 - pgAdmin Node" [no change]
Comment:<empty> [no data entered]     3) Clicked OK and...        "An error has occurred:         ERROR: schema
"_<Master-Host-Server>-Master-Cluster"already exists        " 
     So, perhaps I should not have added a join here, in the master server connection,     so I clicked CANCEL
   b) Then I tried (on Slave Server) connection:     1) Right-clicked Replication object, selected from menu: New
slony-ICluster ...     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
listand 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
valueand 'OK' remains greyed out. 
   So I am at loss to go any further...
   Any advice?

>-----Original Message-----
>From: Dave Page [mailto:dpage@postgresql.org]
>Sent: Monday, September 17, 2007 8:58 AM
>To: Daniel B. Thurman
>Cc: Pgadmin-Support (E-mail)
>Subject: Re: [pgadmin-support] Implementing Replication via pgAdmin
>
>
>Daniel B. Thurman wrote:
>> I have tried to follow the pgAdmin slony support in the help sections
>> of pgAdmin and it seems to be inconsistent.  For example, it is not
>> intuitively clear from the help sections how exactly to
>setup the master
>> and slave configurations.  From a windows client
>perspective, it seems
>> that one must use command-line operations in order to setup the slony
>> services, create and configure the configuration files, and
>then try to use
>> the pgAdmin replication objects to define the master/slave
>relationships?
>
>Yes.
>
>> Since it is possible to create new connections to all of the
>postgreSQL
>> servers within your network into the pgAdmin connections
>list, should it
>> also be possible to seamlessly perform (slony) replication
>for all of the
>> master/slaves databases with slony services automatically
>initialized and
>> completely within pgAdmin without having to resort to manual
>command-line
>> operations?
>
>The slon daemon (on *nix) or service & engines (on Windows) must be
>configured from the command line. pgAdmin makes no attempt to do this
>because that is entirely OS dependent (in fact, it is distribution
>dependent because, for example, Redhat and Slackware start daemons in
>entirely different ways). In addition, you may not even want
>to run slon
>on the machine that you're running pgAdmin on, or even that you're
>running the database on.
>
>So yes, configure the slons on the command line, then use pgAdmin to
>create your replication clusters and sets.
>
>Regards, Dave
>
>No virus found in this incoming message.
>Checked by AVG Free Edition.
>Version: 7.5.487 / Virus Database: 269.13.21/1012 - Release
>Date: 9/16/2007 6:32 PM
>
>

No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.487 / Virus Database: 269.13.21/1012 - Release Date: 9/16/2007 6:32 PM