pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Mirroring the database?
3+ messages / 3 participants
[nested] [flat]

* Mirroring the database?
@ 2001-08-06 17:35 Raymond Chui <raymond.chui@noaa.gov>
  2001-08-06 19:57 ` Re: Mirroring the database? Allan Engelhardt <allane@cybaea.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Raymond Chui @ 2001-08-06 17:35 UTC (permalink / raw)
  To: pgsql-general@postgresql.org.pgsql-sql

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!




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Mirroring the database?
  2001-08-06 17:35 Mirroring the database? Raymond Chui <raymond.chui@noaa.gov>
@ 2001-08-06 19:57 ` Allan Engelhardt <allane@cybaea.com>
  2001-08-09 01:51   ` Re: Re: Mirroring the database? Justin Clift <justin@postgresql.org>
  0 siblings, 1 reply; 3+ messages in thread

From: Allan Engelhardt @ 2001-08-06 19:57 UTC (permalink / raw)
  To: Raymond Chui <raymond.chui@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!




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Re: Mirroring the database?
  2001-08-06 17:35 Mirroring the database? Raymond Chui <raymond.chui@noaa.gov>
  2001-08-06 19:57 ` Re: Mirroring the database? Allan Engelhardt <allane@cybaea.com>
@ 2001-08-09 01:51   ` Justin Clift <justin@postgresql.org>
  0 siblings, 0 replies; 3+ messages in thread

From: Justin Clift @ 2001-08-09 01:51 UTC (permalink / raw)
  To: Allan Engelhardt <allane@cybaea.com>; +Cc: Raymond Chui <raymond.chui@noaa.gov>; pgsql-general@postgresql.org; 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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2001-08-09 01:51 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-08-06 17:35 Mirroring the database? Raymond Chui <raymond.chui@noaa.gov>
2001-08-06 19:57 ` Allan Engelhardt <allane@cybaea.com>
2001-08-09 01:51   ` Justin Clift <justin@postgresql.org>

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