From: | Chris <dmagick(at)gmail(dot)com> |
---|---|
To: | pgdb <pgdb(at)gawab(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Replicating PostgreSQL DB to lightweight system |
Date: | 2006-05-03 02:58:31 |
Message-ID: | 44581C57.7010501@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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. Would be glad to
> hear if there are examples of existing commercial/OSS products to serve
> the purpose. Appreciate any advice. Thanks.
I doubt you'll find any tools to replicate between database systems..
however using pg_dump as a starting point you might be able to create
your own sqlite database and then replicate/copy that around.
You might have issues with date/time fields (don't know how sqlite
handles these) amongst other things, so you might need a script of some
sort to do some conversions.
--
Postgresql & php tutorials
http://www.designmagick.com/
From | Date | Subject | |
---|---|---|---|
Next Message | David Fetter | 2006-05-03 04:00:48 | Re: Replicating PostgreSQL DB to lightweight system |
Previous Message | pgdb | 2006-05-03 02:31:19 | Replicating PostgreSQL DB to lightweight system |