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:
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
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.comml-node%2b3264406-1436673590-144...@n5.nabble.com
wrote:
On Sunday 14. November 2010 13.44.53 franrtorres77
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 -
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:
http://search.cpan.org/dist/DBD-Pg/Pg.pm
regards,
Leif B.
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 stab
On Sun, Nov 14, 2010 at 4:12 PM, Leif Biberg Kristensen
l...@solumslekt.org 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
do $$
begin
execute 'COMMENT ON TABLE test_count is ''Updated ' || current_date ||
;
end$$;
thanks, it works cool.
pasman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Lincoln Yeoh wrote:
What's more important to such companies is the ability to scale over
multiple machines.
That question - how much work it is to administer thousands of database
servers - seems to have been largely missing from this conversation.
Apparently back in 2008, Facebook had 1800
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
I just released PostgreSQL 9.0 RPM for Red Hat Enterprise Linux 6 and
Fedora 14, on both x86 and x86_64.
Please note that 9.0 packages have a different layout as compared to
previous ones. You may want to read this blog post about this first:
On tor, 2010-11-11 at 20:33 +0200, Andrus wrote:
Windows uses % as subnet mask delimiter.
This is not a subnet mask but a zone index, but it should probably still
be supported.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
How about supporting something like:
wal_keep_segments = '7d'
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
Peter Eisentraut pete...@gmx.net writes:
On tor, 2010-11-11 at 20:33 +0200, Andrus wrote:
Windows uses % as subnet mask delimiter.
This is not a subnet mask but a zone index, but it should probably still
be supported.
I believe we looked into that some time ago and decided that the
behavior
On sön, 2010-11-14 at 16:46 -0500, Tom Lane wrote:
Peter Eisentraut pete...@gmx.net writes:
On tor, 2010-11-11 at 20:33 +0200, Andrus wrote:
Windows uses % as subnet mask delimiter.
This is not a subnet mask but a zone index, but it should probably still
be supported.
I believe we
Peter Eisentraut pete...@gmx.net writes:
On sön, 2010-11-14 at 16:46 -0500, Tom Lane wrote:
I believe we looked into that some time ago and decided that the
behavior was too platform-dependent to be worth messing with.
I suppose the problem is that the zone identifier could be almost any
On Sun, Nov 14, 2010 at 12:15 PM, Ron Mayer
rm...@cheapcomplexdevices.comwrote:
Lincoln Yeoh wrote:
What's more important to such companies is the ability to scale over
multiple machines.
That question - how much work it is to administer thousands of database
servers - seems to have been
I am running postgres postgres version 8.3 on OS X.
The data directory is on network volume.
The network volume was disconnected and server crashed.
Log reported that last know up was 9:30 pm (about 30 min prior to the server
crash.)
My conf Checkpoint_Segments setting = 3 (not sure if this is
On 15/11/10 07:04, anypossibility wrote:
I am running postgres postgres version 8.3 on OS X.
The data directory is on network volume.
What kind of network volume?
An AFP mount? SMB share? NFS? iSCSI?
In general, it's a really bad idea to run PostgreSQL (or any other
database) over file-level
Hi,
In general, it's a really bad idea to run PostgreSQL (or any other
database) over file-level network storage like SMB/AFP/CIFS/NFS.
Block-level network storage like iSCSI is generally OK, depending on the
quality of the drivers in target and initiator.
What Craig says it is true and it
I'm planning to migrate our pg db to a new machine in the next couple
of weeks. The current DB has 32 GB memory; the new one will have 96
GB. It's going to be Postgres 8.2.x (we're planning to upgrade to 8.4
as part of another project) running on CentOS 5.4 or 5.5. I know the
old rule of thumb
On Sun, Nov 14, 2010 at 8:34 PM, Evan D. Hoffman evandhoff...@gmail.com wrote:
I'm planning to migrate our pg db to a new machine in the next couple
of weeks. The current DB has 32 GB memory; the new one will have 96
GB. It's going to be Postgres 8.2.x (we're planning to upgrade to 8.4
as
On 15 Nov 2010, at 2:02, ray joseph wrote:
Alban,
Thank you for your time and effort. I can see that you are very familiar
with this environment.
I have only used MS Access (for years). My difficulties are very basic.
When I said I can't view the data in the data base, I meant
23 matches
Mail list logo