Hi BGa,
Just found some free resources for Postgres Replication. You can
visit http://gborg.postgresql.org/genpage?replication_research
Regards,
Moinak.
Date: Thu, 19 Dec 2002 17:07:32 +0530
To: BGanesh <bga@xxxxxxxx>, ilugc@xxxxxxxxxxxxxxxxxx
From: Moinak Ghosh <moinakg@xxxxxxxxx>
Subject: Re: [Ilugc] [info] postgresql in a production environment
Hi BGa,
One commercial product called Enterprise Replication Server,
http://www.erserver.com/, provides Replication feature for PostgreSQL.
Till sometime back they were offering free downloads but now they have
started charging substantially :(
Regards,
Moinak.
At 04:38 PM 12/18/2002 +0530, BGanesh wrote:
Hello,
Last week, we at ETV implemented a postgreSQL backend for
election results
updates at Gujarat. There were twelve input clients, and three output
clients
which generated realtime on air graphics. Clients were all Windows 2000
(anybody know of any good character generators ala CG2000 from matrox
running
on Linux?).
There were two Linux machines running postgresql, in an almost
failsafe
environment. The secondary database would pull the most recent data every
minute via a cron job from the primary and update itself. In case the
primary
db failed, it would shoot the primary (if it was still alive), and take over
by a simple ip change (I know I know, there are better ways). The clients
with uncommited transactions would rollback, and the data remains online
with
a worst case scenario of 30 seconds downtime. When the first machine came
back online in such a scenario, it would begin functioning as the
secondary...
What would make postgres production ready is realtime
replication, and I
guess that would be available in ver 7.3 (any ETA for this?).
Downsides : The developers were from the Windows world, and made
certain
incorrect assumptions (ex, setup and teardown of tables is fast in MS
sql2000, and quite slow in postgres; and since they were unaware of this
fact
they were creating temporary tables all over the place for complex queries).
So, the only problem was their unfamiliarity with the tools....
in a related note, is anybody aware of MS-Access like DB's for
Linux (as in
ease of use) ?
regards
BGa
--
We will find a way, or we will make one - Hannibal
_______________________________________________
To unsubscribe, email ilugc-request@xxxxxxxxxxxxxxxxxx with
"unsubscribe <password> address"
in the subject or body of the message.
http://www.aero.iitm.ernet.in/mailman/listinfo/ilugc