From: | Justin Clift <justin(at)postgresql(dot)org> |
---|---|
To: | Allan Engelhardt <allane(at)cybaea(dot)com> |
Cc: | Raymond Chui <raymond(dot)chui(at)noaa(dot)gov>, pgsql-general(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Re: Mirroring the database? |
Date: | 2001-08-09 01:51:43 |
Message-ID: | 3B71ECAF.65EBD3A0@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-sql |
There's also PostgreSQL Replicator (which I haven't gotten around to
trying) :
http://pgreplicator.sourceforge.net
:-)
Regards and best wishes,
Justin Clift
Allan Engelhardt wrote:
>
> 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!
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
- Indira Gandhi
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-08-09 02:11:59 | Re: Re: First Saturday and Last Saturday of a month |
Previous Message | Mike Mascari | 2001-08-09 01:37:00 | Re: createdb confusion |
From | Date | Subject | |
---|---|---|---|
Next Message | Carolyn Lu Wong | 2001-08-09 06:18:27 | what does this error mean? |
Previous Message | Josh Berkus | 2001-08-08 20:04:39 | Re: Problem with aggregate functions and GROUP BY |