Unix Technical Forum

replication

This is a discussion on replication within the pgsql Admins forums, part of the PostgreSQL category; --> Please,anybody can tell me how to make replication of a PostGre DB????...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > pgsql Admins

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-10-2008, 06:12 AM
Alain Rodriguez Arias
 
Posts: n/a
Default replication

Please,anybody can tell me how to make replication of a PostGre DB????

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 04-10-2008, 06:12 AM
Alvaro Herrera
 
Posts: n/a
Default Re: replication

On Fri, Sep 02, 2005 at 04:11:35PM -0400, Alain Rodriguez Arias wrote:
> Please,anybody can tell me how to make replication of a PostGre DB????


Did you already look at Slony-I, www.slony.info ?

--
Alvaro Herrera -- Valdivia, Chile Architect, www.EnterpriseDB.com
"I think my standards have lowered enough that now I think 'good design'
is when the page doesn't irritate the living f*ck out of me." (JWZ)

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 04-10-2008, 06:12 AM
Chris Browne
 
Posts: n/a
Default Re: replication

alainrod@gmail.com (Alain Rodriguez Arias) writes:
> Please,anybody can tell me how to make replication of a PostGre DB????


What do you mean by "replication?"

- If what you desire is to create a copy, then you can take a backup
and restore it somewhere else.

Read The Fine Manual if that fits your need.
<http://www.postgresql.org/docs/current/static/backup.html>

- If what you require instead is that the replica mirror the activity
that takes place on the database in which you perform updates, then
you should probably look into Slony-I. URL to documentation for that
below.
--
output = reverse("moc.enworbbc" "@" "enworbbc")
http://cbbrowne.com/info/slony.html
Rules of the Evil Overlord #67. "No matter how many shorts we have in
the system, my guards will be instructed to treat every surveillance
camera malfunction as a full-scale emergency."
<http://www.eviloverlord.com/>
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
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
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 10:20 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com