Re: [GENERAL] Replicating PostgreSQL DB to lightweight system

2006-05-03 Thread Adrian Klaver
You might want to look at Knoda (www.knoda.org). In particular the following link- http://hk-classes.sourceforge.net/tutorials/knodascriptingtutorial/bk01ch05s12.html On Tuesday 02 May 2006 07:31 pm, pgdb wrote: >like to know if I can replicate a PG db to another > lightweight platform like SQLite

Re: [GENERAL] Replicating PostgreSQL DB to lightweight system

2006-05-03 Thread Vivek Khera
On May 3, 2006, at 12:00 AM, David Fetter wrote: 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 to

Re: [GENERAL] Replicating PostgreSQL DB to lightweight system

2006-05-02 Thread Leif B. Kristensen
On Wednesday 03 May 2006 04:31, pgdb wrote: >I 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 expecte

Re: [GENERAL] Replicating PostgreSQL DB to lightweight system

2006-05-02 Thread pgdb
David Fetter writes: David Fetter writes: > On Wed, May 03, 2006 at 02:31:19AM +, 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 ser

Re: [GENERAL] Replicating PostgreSQL DB to lightweight system

2006-05-02 Thread David Fetter
On Wed, May 03, 2006 at 02:31:19AM +, 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 devi

Re: [GENERAL] Replicating PostgreSQL DB to lightweight system

2006-05-02 Thread Chris
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, access

[GENERAL] Replicating PostgreSQL DB to lightweight system

2006-05-02 Thread pgdb
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' t