Just found some free resources for Postgres Replication. You can
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
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 :(
At 04:38 PM 12/18/2002 +0530, BGanesh wrote:
Last week, we at ETV implemented a postgreSQL backend for
updates at Gujarat. There were twelve input clients, and three output
which generated realtime on air graphics. Clients were all Windows 2000
(anybody know of any good character generators ala CG2000 from matrox
There were two Linux machines running postgresql, in an almost
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
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
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
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
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
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) ?
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.