From: | Allan Engelhardt <allane(at)cybaea(dot)com> |
---|---|
To: | Raymond Chui <raymond(dot)chui(at)noaa(dot)gov> |
Subject: | Re: Mirroring the database? |
Date: | 2001-08-06 19:57:55 |
Message-ID: | 3B6EF6C3.F3897443@cybaea.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-sql |
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!
From | Date | Subject | |
---|---|---|---|
Next Message | Kathi Arthur | 2001-08-06 20:20:38 | Re: database does not exist in system catalog |
Previous Message | Kathi Arthur | 2001-08-06 19:47:19 | database does not exist in system catalog |
From | Date | Subject | |
---|---|---|---|
Next Message | Kate Collins | 2001-08-06 19:59:35 | Re: prob with PERL/Postgres |
Previous Message | Kristopher Yates | 2001-08-06 19:05:56 | prob with PERL/Postgres |