Lookng at this product for some work I have that requires pull sync of data from one central postgres database to multiple other databases on separate hosts
Using the GUI seems to allow for creating multiple publishers and subscribers however I cannot find how to do this via the command line options using the publisher.conf and subscriber.conf files.
1. Can I do pull replication from the command line / configuration files?
it appears not, I can live with this for now but not in the long term
2. Can the configuration files be used to specify multiple published and subscribed items?
at this stage it appears I can only publish one item and subscribe to one item on any given host, this is a show stopper for me.
2.a. Can I run multiple subscriber process on the same host?
3. Can I do any configuration without using the GUI's as this will make it difficult to deploy in my current Non-X environment
Yes, the structure (and by
Yes, the structure (and by extension the GUI) is designed to allow for multiple publications/subscriptions. I didn't deal with this initially in the *.conf files because I didn't need the functionality at the time. I will, however, need the functionality very soon, so you can expect to see the structure of the *.conf files change rather dramatically in the near future. It will probably become xml-based, and may very well combine most if not all of the conf files in /etc/dbreplicator.
Right now, the command line app won't allow pull/push, but this will also change. As I deploy more of these, I too find it rather cumbersome to have to deal with X applications, so you can expect this to change rather soon as well. Most likely the 2.2.4 or 2.3.1 release.
RIght now, no configuration is possible without the GUI's, but as above, this too will change. I need to be able to script the setup of a publisher/subscriber, so will add that functionality.
I should be getting these things done within the next few weeks, as my work necessitates it and thus makes it possible to devote some time to during business hours.