Re: spreading the DB?

From: Richard Huxton <dev(at)archonet(dot)com>
To: raptor <raptor(at)tvskat(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: spreading the DB?
Date: 2004-11-01 15:49:36
Message-ID: 41865B10.7030703@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

raptor wrote:
> hi,
>
> what do u do if the DB become big and u have to spread
> it into two or more computers.
> Links and Docs are ok too ?
>
> For example what if u do if u want to split the DB on two servers (at desing stage), but
> u have common data such as user info,address etc... if u decide to do it that way
> u need to syncronize common data in some way, what do u do.

It's called "replication" - you should probably spend some time reading
up on the issues it presents. The current most-popular system would seem
to be "Slony".

--
Richard Huxton
Archonet Ltd

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2004-11-01 15:54:36 Re: unique problem
Previous Message Neil Conway 2004-11-01 15:16:24 Re: Reasoning behind process instead of thread based