pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Allan Engelhardt <allane@cybaea.com>
To: Raymond Chui <raymond.chui@noaa.gov>
Subject: Re: Mirroring the database?
Date: Mon, 06 Aug 2001 20:57:55 +0100
Message-ID: <3B6EF6C3.F3897443@cybaea.com> (raw)
References: <3B6ED545.4C1F96BE@noaa.gov>

Ehhh, use dual-ported RAID disks?  (Well, tri-port in your case, but maybe A and B machines are enough.  You still have a (small) single point of failure, but you probably have that anyhow (network switch?).  You'll need some way of brining PostgreSQL up on B when A dies, but that could be a simple script.  Reconnect would of course be manual from the point of the client.).

Or buy Oracle.

Replication is at the top of the TODO list: http://www.uk.postgresql.org/docs/todo.html


Allan.


PS:
Maybe SQLB does some of what you want?  http://sourceforge.net/projects/sqlb/  [The documentation is a little opaque...I'm not quite sure what it does, exactly.  Anybody want to comment?]


Raymond Chui wrote:

> Does the latest PostgreSQL 7.1.2 support database mirroring?
>
> I have machine A, B and C, they all have the same database and tables.
> Machine A is the operational machine, machine B and C are backup.
>
> If users do INSERT, UPDATE and DELETE in machine A, I want have the
> same SQL statements in machine B and C.
>
> 1. I can do pg_dump or COPY every hour.
> 2. I can use PerlDBI or JDBC open multiple connections for each SQL
>     statement.
> 3. But I prefer if the system auto mirroring the database, then I can do
> nothing.
>     All I need is set the auto mirroring configure.
>
> Please tell me how to do in 3. above. Thank you in advance!




view thread (3+ messages)  latest in thread

Message-ID: <3B6EF6C3.F3897443@cybaea.com>
Permalink:  ../3B6EF6C3.F3897443@cybaea.com/
Also on:    postgresql.org/message-id/3B6EF6C3.F3897443@cybaea.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: allane@cybaea.com, raymond.chui@noaa.gov
  Subject: Re: Mirroring the database?
  In-Reply-To: <3B6EF6C3.F3897443@cybaea.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox