Re: [GENERAL] Adding data from mysql to postgresql periodically

Hi, franrtorres77 writes: > I need to add periodically some data from a remote mysql database into our > postgresql database. So, does anyone know how to do it having in mind that > it must be runned every minute or so for adding new records to the > postresql? I've been doing that with pgloader

Re: [GENERAL] Adding data from mysql to postgresql periodically

On Nov 14, 2010, at 4:44 AM PST, franrtorres77 wrote: > > Hi there > > I need to add periodically some data from a remote mysql database into our > postgresql database. So, does anyone know how to do it having in mind that > it must be runned every minute or so for adding new records to the > po

Re: [GENERAL] Adding data from mysql to postgresql periodically

On Sun, Nov 14, 2010 at 7:44 AM, franrtorres77 wrote: > I need to add periodically some data from a remote mysql database into our > postgresql database. So, does anyone know how to do it having in mind that > it must be runned every minute or so for adding new records to the > postresql? People

Re: [GENERAL] Adding data from mysql to postgresql periodically

Hello again. Well, the data that I want to import is some satellite coordinates saved in mysql , the fields are X and Y and want to import them into a postgis table for converting these coordinates to a normal latitude and longitude points because in mysql are saved in Utm format. I have foound

Re: [GENERAL] Adding data from mysql to postgresql periodically

On Sunday 14 November 2010 4:44:53 am franrtorres77 wrote: > Hi there > > I need to add periodically some data from a remote mysql database into our > postgresql database. So, does anyone know how to do it having in mind that > it must be runned every minute or so for adding new records to the > po

Re: [GENERAL] Adding data from mysql to postgresql periodically

On Sun, Nov 14, 2010 at 4:12 PM, Leif Biberg Kristensen wrote: > On Sunday 14. November 2010 13.44.53 franrtorres77 wrote: >> >> Hi there >> >> I need to add periodically some data from a remote mysql database into our >> postgresql database. So, does anyone know how to do it having in mind that >

Re: [GENERAL] Adding data from mysql to postgresql periodically

On Sunday 14. November 2010 14.33.39 franrtorres77 wrote: > > well, I know how to query to mysql but what i dont know is how to then write > that data on the fly to the postgresql I'd also like to say that it's an interesting question, and a lot of people (including me) might want to take a sta

Re: [GENERAL] Adding data from mysql to postgresql periodically

On Sunday 14. November 2010 14.33.39 franrtorres77 wrote: > > well, I know how to query to mysql but what i dont know is how to then write > that data on the fly to the postgresql The DBD::Pg package has an excellent documentation: regards, Leif B. Kr

Re: [GENERAL] Adding data from mysql to postgresql periodically

well, I know how to query to mysql but what i dont know is how to then write that data on the fly to the postgresql -- View this message in context: http://postgresql.1045698.n5.nabble.com/Adding-data-from-mysql-to-postgresql-periodically-tp3264392p3264417.html Sent from the PostgreSQL - general

Re: [GENERAL] Adding data from mysql to postgresql periodically

So, do you know where I can find out an example for that? *Fran* On 14 November 2010 14:13, Leif Biberg Kristensen [via PostgreSQL] < ml-node+3264406-1436673590-144...@n5.nabble.com > wrote: > On Sunday 14. November 2010 13.44.53 franrtorres77 wrote: > > > > Hi there > > > > I need to add peri

Re: [GENERAL] Adding data from mysql to postgresql periodically

On Sunday 14. November 2010 13.44.53 franrtorres77 wrote: > > Hi there > > I need to add periodically some data from a remote mysql database into our > postgresql database. So, does anyone know how to do it having in mind that > it must be runned every minute or so for adding new records to the >