pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Andrei Bintintan <klodoma@ar-sd.net>
To: Joshua D. Drake <jd@commandprompt.com>
To: John DeSoi <desoi@pgedit.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: PostgreSQL replication solution?
Date: Thu, 14 Apr 2005 12:32:57 +0300
Message-ID: <00d101c540d4$f2bffd00$0b00a8c0@forge> (raw)
References: <004a01c53f2b$9c801330$0b00a8c0@forge>
	<86F21A1E-AB4E-11D9-807C-000A95B03262@pgedit.com>
	<425BF9B7.8080103@commandprompt.com>

The scenario is the following:
I have a main database on a server probably this will be the master.

With this replication we want first to make a copy of this database which 
will be at another location(another company) with 1 time/day sincronization, 
so this will be a slave which will contain a part of the database(so not all 
the tables) ~ asyncronus replication

and

we also would like to make a backup server in our local LAN which will 
contain a complete backup of the main database in case of the server fail.

We would like a free solution if possible,
I read about Slony, what about erserver? http://www.pgsql.com/download/ or
http://gborg.postgresql.org/project/erserver/projdisplay.php

Did anyone used it? Which is better to use?

Thanks for any tipps.
Andy.


----- Original Message ----- 
From: "Joshua D. Drake" <jd@commandprompt.com>
To: "John DeSoi" <desoi@pgedit.com>
Cc: "Andrei Bintintan" <klodoma@ar-sd.net>; <pgsql-admin@postgresql.org>
Sent: Tuesday, April 12, 2005 7:39 PM
Subject: Re: [ADMIN] PostgreSQL replication solution?


> John DeSoi wrote:
>
>>
>> On Apr 12, 2005, at 2:48 AM, Andrei Bintintan wrote:
>>
>>>
>>> I have to do a database replication (of corse pgsql database) and I 
>>> never done something like this. I still read about ...  what replication 
>>> is.
>>>   Can anyone send me some directions, documentation, ideeas, solutions?
>>
>>
>> Here is a nice article on Slony:
>>
>> http://www.onlamp.com/pub/a/onlamp/2004/11/18/slony.html
>
> You can also look at replicator over at http://www.commandprompt.com/ . It 
> is simpler to setup than slony but it is not free.
>
> Sincerely,
>
> Joshua D. Drake
>
>
>
>
>
> 





view thread (4+ messages)

Message-ID: <00d101c540d4$f2bffd00$0b00a8c0@forge>
Permalink:  ../00d101c540d4$f2bffd00$0b00a8c0@forge/
Also on:    postgresql.org/message-id/00d101c540d4$f2bffd00$0b00a8c0@forge

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: klodoma@ar-sd.net, jd@commandprompt.com, desoi@pgedit.com
  Subject: Re: PostgreSQL replication solution?
  In-Reply-To: <00d101c540d4$f2bffd00$0b00a8c0@forge>
  References: <004a01c53f2b$9c801330$0b00a8c0@forge> <86F21A1E-AB4E-11D9-807C-000A95B03262@pgedit.com> <425BF9B7.8080103@commandprompt.com> <00d101c540d4$f2bffd00$0b00a8c0@forge>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox