Re: [GENERAL] Asynchronous replication of a PostgreSQL DB to

2006-12-12 Thread Bruce Momjian
I think Sequoia (open source) and Continuent (proprietary) do this. --- Markus Wollny wrote: > Hi! > > I'd like to export schema and data from a PostgreSQL database to a > remote MySQL database; any changes to the PG-master

Re: [GENERAL] Asynchronous replication of a PostgreSQL DB to a

2006-12-07 Thread Jeff Davis
On Thu, 2006-12-07 at 09:56 +0100, Markus Wollny wrote: > My first problem is that the PostgreSQLs schema is not stable, so if I > simply write a couple of jobs to transport the data, I need to alter > these jobs and the MySQL schema whenever there are changes to the PG > schema. The second problem

[GENERAL] Asynchronous replication of a PostgreSQL DB to a MySQL target

2006-12-07 Thread Markus Wollny
Hi! I'd like to export schema and data from a PostgreSQL database to a remote MySQL database; any changes to the PG-master should be reflected on the MySQL target in a matter of a few minutes to one hour max. Has anybody done something like this before? Here's some more background: We've got an