| From: | "Brandon Metcalf" <bmetcalf(at)nortel(dot)com> |
|---|---|
| To: | Merlin Moncure <mmoncure(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: syncing with a MySQL DB |
| Date: | 2008-10-21 13:54:30 |
| Message-ID: | Pine.LNX.4.58L.0810210852400.4497@cash.us.nortel.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
m == mmoncure(at)gmail(dot)com writes:
m> On Tue, Oct 21, 2008 at 9:07 AM, Brandon Metcalf <bmetcalf(at)nortel(dot)com> wrote:
m> > I have a need to keep a PostgreSQL and MySQL table synchronized. My
m> > thoughts are to use triggers on the pgsql side to manipulate the MySQL
m> > table when data in the pgsql table is changed. I also plan on using
m> > PL/Perl to write the functions.
m> >
m> > Are there better ways to achieve this?
m> have you looked at dbi-link?
No, but just did and it looks very cool. Have you used it before? If
so, would you mind if I ask you some questions? We could take it off
the list if that's more appropriate.
--
Brandon
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rob Richardson | 2008-10-21 13:57:51 | When are updates from inside transactions visible? |
| Previous Message | Rob Richardson | 2008-10-21 13:51:12 | Where are updates from inside transactions visible? |