X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 55AC65357C for ; Thu, 14 Apr 2005 06:33:09 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 75885-09 for ; Thu, 14 Apr 2005 09:33:01 +0000 (GMT) Received: from ar-sd.net (unknown [82.77.155.72]) by svr1.postgresql.org (Postfix) with ESMTP id ED5F85361F for ; Thu, 14 Apr 2005 06:32:55 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by ar-sd.net (Postfix) with ESMTP id 4F84A20237; Thu, 14 Apr 2005 12:20:59 +0300 (EEST) Received: from ar-sd.net ([127.0.0.1]) by localhost (linz [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 09112-03; Thu, 14 Apr 2005 12:20:56 +0300 (EEST) Received: from forge (unknown [192.168.0.11]) by ar-sd.net (Postfix) with SMTP id 0EA8520220; Thu, 14 Apr 2005 12:20:56 +0300 (EEST) Message-ID: <00d101c540d4$f2bffd00$0b00a8c0@forge> From: "Andrei Bintintan" To: "Joshua D. Drake" , "John DeSoi" Cc: References: <004a01c53f2b$9c801330$0b00a8c0@forge> <86F21A1E-AB4E-11D9-807C-000A95B03262@pgedit.com> <425BF9B7.8080103@commandprompt.com> Subject: Re: PostgreSQL replication solution? Date: Thu, 14 Apr 2005 12:32:57 +0300 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Virus-Scanned: by amavisd-new at ar-sd.net X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200504/188 X-Sequence-Number: 17201 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" To: "John DeSoi" Cc: "Andrei Bintintan" ; 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 > > > > > >