Re: 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