pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Marco Carvalho <aramefarpado@gmail.com>
To: pgsql-admin@postgresql.org
Subject: multiple servers updating from/to one
Date: Wed, 30 Mar 2005 11:51:37 -0300
Message-ID: <9250651c0503300651788c62c6@mail.gmail.com> (raw)

Hi, all

I need to do this scenario:

Web Application           Web Application             Web Application
           |                                  |                       
              |
  pgsql server 1           pgsql server 2              pgsql server 3
           |                                  |                       
              |
           |                                  |                       
              |
           | adsl                          | adsl                     
         | adsl
           |                                  |                       
              |
           |                                  |                       
              |
              -------------------------------------------------------
                                              |
                             pgsql server ("master")

I need various servers in different locations running exactly some
things, one Web Application and one pgsql server, all synchronizing
with "master" server through unstable adsl connections.
So, If I do one insert in server 1, this data goes to "master" and is
available to other servers, and vice-versa, and if adsl connection
broken, Web Application still working with local server and when
connection is restored both databases are synchronized.
Is this possible?
If it's true, what tools I need?

Thanks in advance to any help, and sorry for my bad English (if
someone can't understand I say, I try to be more clear).

Cheers,

Marco Carvalho



view thread (2+ messages)  latest in thread

Message-ID: <9250651c0503300651788c62c6@mail.gmail.com>
Permalink:  ../9250651c0503300651788c62c6@mail.gmail.com/
Also on:    postgresql.org/message-id/9250651c0503300651788c62c6@mail.gmail.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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: aramefarpado@gmail.com
  Subject: Re: multiple servers updating from/to one
  In-Reply-To: <9250651c0503300651788c62c6@mail.gmail.com>
  References: <9250651c0503300651788c62c6@mail.gmail.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