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 CDEEC533B4 for ; Tue, 12 Apr 2005 13:39:53 -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 55408-08 for ; Tue, 12 Apr 2005 16:39:50 +0000 (GMT) Received: from hosting.commandprompt.com (128.commandprompt.com [207.173.200.128]) by svr1.postgresql.org (Postfix) with ESMTP id 6AFCC533DD for ; Tue, 12 Apr 2005 13:39:50 -0300 (ADT) Received: from [192.168.1.52] (fc1smp [66.93.38.87]) (authenticated bits=0) by hosting.commandprompt.com (8.12.8/8.12.8) with ESMTP id j3CGYfma028436; Tue, 12 Apr 2005 09:34:42 -0700 Message-ID: <425BF9B7.8080103@commandprompt.com> Date: Tue, 12 Apr 2005 09:39:19 -0700 From: "Joshua D. Drake" Organization: Command Prompt, Inc. User-Agent: Mozilla Thunderbird 1.0.2-1.3.2 (X11/20050324) X-Accept-Language: en-us, en MIME-Version: 1.0 To: John DeSoi Cc: Andrei Bintintan , pgsql-admin@postgresql.org Subject: Re: PostgreSQL replication solution? References: <004a01c53f2b$9c801330$0b00a8c0@forge> <86F21A1E-AB4E-11D9-807C-000A95B03262@pgedit.com> In-Reply-To: <86F21A1E-AB4E-11D9-807C-000A95B03262@pgedit.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.028 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200504/162 X-Sequence-Number: 17175 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