From klodoma@ar-sd.net Tue Apr 12 06:48:29 2005 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 1896053927 for ; Tue, 12 Apr 2005 03:48:29 -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 63149-01 for ; Tue, 12 Apr 2005 06:48:24 +0000 (GMT) Received: from ar-sd.net (unknown [82.77.155.72]) by svr1.postgresql.org (Postfix) with ESMTP id 62C9E53822 for ; Tue, 12 Apr 2005 03:48:23 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by ar-sd.net (Postfix) with ESMTP id 0952D1ED56 for ; Tue, 12 Apr 2005 09:36:34 +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 24578-01 for ; Tue, 12 Apr 2005 09:36:32 +0300 (EEST) Received: from forge (unknown [192.168.0.11]) by ar-sd.net (Postfix) with SMTP id BEA241ECAC for ; Tue, 12 Apr 2005 09:36:31 +0300 (EEST) Message-ID: <004a01c53f2b$9c801330$0b00a8c0@forge> From: "Andrei Bintintan" To: Subject: PostgreSQL replication solution? Date: Tue, 12 Apr 2005 09:48:17 +0300 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0047_01C53F44.C0B8CDF0" 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.045 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200504/147 X-Sequence-Number: 17160 This is a multi-part message in MIME format. ------=_NextPart_000_0047_01C53F44.C0B8CDF0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi to all,=20 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.=20 Can anyone send me some directions, documentation, ideeas, solutions?=20 Thanks.=20 Andy. ------=_NextPart_000_0047_01C53F44.C0B8CDF0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi to all,
 
I have to do a database replication (of = corse pgsql=20 database) and I never done something like this. I still read about = ... =20 what replication is.
 
Can anyone send me some directions, = documentation,=20 ideeas, solutions?
 
Thanks.
Andy.
------=_NextPart_000_0047_01C53F44.C0B8CDF0-- From desoi@pgedit.com Tue Apr 12 12:29:40 2005 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 BA8F25341B for ; Tue, 12 Apr 2005 09:29:40 -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 69807-01 for ; Tue, 12 Apr 2005 12:29:37 +0000 (GMT) Received: from a2s1.a2webhosting.com (host-180.a2webhosting.com [69.39.89.180]) by svr1.postgresql.org (Postfix) with ESMTP id 22D6B53439 for ; Tue, 12 Apr 2005 09:29:36 -0300 (ADT) Received: from user-11206j0.dsl.mindspring.com ([66.32.26.96] helo=[192.168.1.10]) by a2s1.a2webhosting.com with esmtpsa (TLSv1:RC4-SHA:128) (Exim 4.44) id 1DLKWR-0006Am-Ez; Tue, 12 Apr 2005 08:29:39 -0400 In-Reply-To: <004a01c53f2b$9c801330$0b00a8c0@forge> References: <004a01c53f2b$9c801330$0b00a8c0@forge> Mime-Version: 1.0 (Apple Message framework v619) Content-Type: text/plain; charset=ISO-8859-1; format=flowed Message-Id: <86F21A1E-AB4E-11D9-807C-000A95B03262@pgedit.com> Content-Transfer-Encoding: quoted-printable Cc: From: John DeSoi Subject: Re: PostgreSQL replication solution? Date: Tue, 12 Apr 2005 08:29:34 -0400 To: "Andrei Bintintan" X-Mailer: Apple Mail (2.619) X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - a2s1.a2webhosting.com X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - pgedit.com X-Source: X-Source-Args: X-Source-Dir: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.009 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200504/150 X-Sequence-Number: 17163 On Apr 12, 2005, at 2:48 AM, Andrei Bintintan wrote: > > I have to do a database replication (of corse pgsql database) and I=20 > never done something like this. I still read about ...=A0 what=20 > replication is. > =A0 > 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 John DeSoi, Ph.D. http://pgedit.com/ Power Tools for PostgreSQL From jd@commandprompt.com Tue Apr 12 16:39:53 2005 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 From klodoma@ar-sd.net Thu Apr 14 09:33:09 2005 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 > > > > > >