From: Shane Ambler <pgsql@Sheeky.Biz>
To: Mohammed Rashid <mail4rashid@gmail.com>
Cc: Scott Marlowe <scott.marlowe@gmail.com>
Cc: Rich <rhdyes@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Postgres database as a client/server architecture
Date: Wed, 08 Oct 2008 04:19:02 +1030
Message-ID: <48EBA10E.3010007@Sheeky.Biz> (raw)
In-Reply-To: <b1bef36d0810061054h99dbc18r5522799465e7a939@mail.gmail.com>
References: <b1bef36d0810052323x4bcaf24fmb3a012fc83a002b2@mail.gmail.com>
<dcc563d10810060708o21eebc16nab9b29aed6bd3eb9@mail.gmail.com>
<8fb205ea0810060800t6a14d70bo85bc55dd8db32914@mail.gmail.com>
<dcc563d10810060808g3b4149f2odae1de82f28eb805@mail.gmail.com>
<b1bef36d0810061054h99dbc18r5522799465e7a939@mail.gmail.com>
Mohammed Rashid wrote:
> Hi All,
>
> I think there is some confusion regarding this. I want postgres to be
> installed at two different PCs.Then the data from each postgres
> should be automatically updated to the third PC which we call server.
> This process should be automatic. It should also take care of
> network disconnection between client and server. After establishment
> of network connections the remaining data should be automatically
> updated to the server. It is bit different from the mirroring of
> databases, but the concept is same.
>
> I just want to ask whether the Postgres database supports this or
> not? Or I have to write an application to do so.
>
I think this sounds like you want a server in the office and the two
clients are maybe laptops that want to synchronise changes between their
own data and the office server when they come into the office. So they
would send changes to the server as well as receive changes from the server.
This case of intermittent network connections isn't usually handled by
replication options so would be a custom setup by you. To automate the
task you want some sort of heartbeat monitor to detect the presence of
the server and perform the synchronising.
You will either want a list of changed records per client or modified
timestamps to determine what has changed since the last synchronise, as
well as define actions upon conflicts.
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz
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-admin@postgresql.org
Cc: pgsql@Sheeky.Biz, mail4rashid@gmail.com, scott.marlowe@gmail.com, rhdyes@gmail.com
Subject: Re: Postgres database as a client/server architecture
In-Reply-To: <48EBA10E.3010007@Sheeky.Biz>
* 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