On Wed, May 03, 2006 at 02:31:19AM +0000, pgdb wrote: > Hi, > like to know if I can replicate a PG db to another lightweight > platform like SQLite? The objective is to "push" updates to remote > devices(laptops, PDAs etc) from a central server, so that the data > can be used offline. These devices are not expected to modify any > data, accessing them thru' the small-footprint db system.
If they're big enough, you could use Slony and PostgreSQL on the devices, which has the nice property of disallowing any attempts at writing. > Would be glad to hear if there are examples of existing > commercial/OSS products to serve the purpose. If you're not using PostgreSQL for the smaller systems, you might be able to rig something up with pg_dump using the --inserts option. The tough part will probably be getting the schema translated into SQLite (or whatever system you choose) idiom. You might also consider DBI-Link, but I'm pretty sure that's not a fit for this case. > Appreciate any advice. Thanks. In future, please post in plain text, as many of us have trouble reading HTML ;) Cheers, D -- David Fetter <[EMAIL PROTECTED]> http://fetter.org/ phone: +1 415 235 3778 AIM: dfetter666 > Skype: davidfetter Remember to vote! ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
