dbTalk Databases Forums  

spreading the DB?

comp.databases.postgresql.general comp.databases.postgresql.general


Discuss spreading the DB? in the comp.databases.postgresql.general forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Richard Huxton
 
Posts: n/a

Default Re: spreading the DB? - 11-01-2004 , 09:49 AM






raptor wrote:
Quote:
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

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html



Reply With Quote
  #2  
Old   
raptor
 
Posts: n/a

Default spreading the DB? - 11-01-2004 , 11:55 AM






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.


tia

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.