Database replication method
| От | Yuksel Pinarbasi |
|---|---|
| Тема | Database replication method |
| Дата | |
| Msg-id | 4ACE746999B44373AE4344C83CFAD385@yukiPC обсуждение исходный текст |
| Ответ на | Re: Insert image into bytea question (George Roberge <groberge@andforthelamb.org>) |
| Ответы |
Re: Database replication method
|
| Список | 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
В списке pgsql-novice по дате отправления: