-----BEGIN PGP SIGNED MESSAGE----- Hash: RIPEMD160 > Major Replication Requirements (from the Central Office side): > > 1. Apply updates on certain tables like products, customers, > users and settings and commit on the remote location POS. > 2. Query Sales, Transactions, Inventory and other tables > for reporting purposes from POS. > 3. Fetch update at least within 4-8 hours interval. > 4. Generate Backups Not sure what "generate backups" means in the replication sense, but if you have sites that are flaky, you might want to look at Bucardo: http://bucardo.org/ It does master->slave (like Slony), but also does master<->master if you need it. - -- Greg Sabino Mullane greg@xxxxxxxxxxxx End Point Corporation PGP Key: 0x14964AC8 200908191342 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -----BEGIN PGP SIGNATURE----- iEYEAREDAAYFAkqMOZEACgkQvJuQZxSWSsgo4gCfYhM1itn1KyVt4l/nEG4nkek5 w5MAoMrnYEbtrqSoKpcHR1m2qtTem2z8 =T0gZ -----END PGP SIGNATURE----- -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general