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 >

[GENERAL] Adding data from mysql to postgresql periodically

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 postresql? Best regards -- View this message in context: http://post