Database replication method

From: "Yuksel Pinarbasi" <yukselp(at)gmail(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Database replication method
Date: 2014-05-02 13:01:33
Message-ID: 4ACE746999B44373AE4344C83CFAD385@yukiPC
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi all,
I'm new to PostgreSQL and generally to database engines
(background from MS Access but I started to learn PostgreSQL).

My question is about database architecture.
There is a small private school with 2 branches in 2 seperate locations.
Their database will manage student and teacher informations (contact informations, payments etc.)
Since a student or a teacher can go to both these two locations, database must be shared.
But, there might be failures to internet connections from time to time and I wonder how can we maintain data integrity after connection established.

Syncronization speed is not crucial. Mostly their data stays internal . I want (ideally):
2 Mirrored databases in 2 location, after an update they try to synchronise, if a connection occurs try later.

How can I do this with PostgreSQL?

Thanks,
Yuksel

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Jov 2014-05-02 13:06:54 Re: Insert image into bytea question
Previous Message George Roberge 2014-05-02 12:16:32 Re: Insert image into bytea question