I've had the same question, I believe the best it gets will be something
like running rsync over an encrypted (if needed for security) tunnel (ssh).
But you'll have to user some dump utility as far as I know.
Cheers Wim.
----- Oorspronkelijk bericht -----
Van: Differentiated Software Solutions Pvt. Ltd. +ADw-diffs+AEA-vsnl.com+AD4-
Aan: +ADw-pgsql-general+AEA-postgresql.org+AD4-
Verzonden: Friday, March 24, 2000 9:19 AM
Onderwerp: +AFs-GENERAL+AF0- DB replication
+AD4- Hi,
+AD4-
+AD4- We have an application which has databases in 2 different machines.
+AD4- The databases are small (25 MB).
+AD4-
+AD4- Every 15 minutes we want DB of one machine to be synced with another
+AD4- machine. Are there ready made utilities in postgres to do this.
+AD4- One way is to take a pgdump, tar it, ftp it and then restore it into the
+AD4- other machine.
+AD4- This has a problem if I want to sync selected tables. Also this means the
+AD4- entire data gets reloaded, whereas only the incremental changes should get
+AD4- dumped.
+AD4-
+AD4- Any help is appreciated.
+AD4-
+AD4- Murali
+AD4-
+AD4- Differentiated Software Solutions Pvt. Ltd.,
+AD4- 176, Gr. Floor, 6th Main
+AD4- 2nd Block RT Nagar
+AD4- Bangalore - 560 032
+AD4- India
+AD4- Ph: 91 80 3431470
+AD4- email : diffs+AEA-vsnl.com
+AD4- http://www.diffs-india.com
+AD4-
