X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id F0F2311F60BA for ; Fri, 14 Apr 2006 10:21:27 -0300 (ADT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Score: 0.787 X-Spam-Level: X-Spam-Status: No, score=0.787 required=5 tests=[AWL=-0.546, HTML_MESSAGE=0.001, RCVD_IN_BL_SPAMCOP_NET=1.332] Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id ksx4HxiZO+zh for ; Fri, 14 Apr 2006 10:21:18 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.224]) by postgresql.org (Postfix) with ESMTP id 5C03A11F61E4 for ; Fri, 14 Apr 2006 10:21:21 -0300 (ADT) Received: by wproxy.gmail.com with SMTP id 67so275591wri for ; Fri, 14 Apr 2006 06:21:20 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; b=dauA0G7XyQbrPnQ/mad008UsckAnI9oG1wkpCYjQdU5eSctNXqn+qcAlOveCgFCylRjtuCD71GVhjvZsm3gW7eUriY1udzFQAEvnHszmuKYNZ7BrBnM3fC2UZQ37zgxT67B2JmqzxOuDO07Wko4S+VKzBCCd6pLtXmtuzlAfo/8= Received: by 10.65.224.16 with SMTP id b16mr865418qbr; Fri, 14 Apr 2006 06:21:20 -0700 (PDT) Received: by 10.65.249.3 with HTTP; Fri, 14 Apr 2006 06:21:20 -0700 (PDT) Message-ID: Date: Fri, 14 Apr 2006 18:21:20 +0500 From: "Shoaib Mir" To: pgsql-admin@postgresql.org Subject: Re: Slony1 or DRBD for replication ? In-Reply-To: <443F9BF3.4060101@laposte.net> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_29390_30619466.1145020880206" References: <443F9BF3.4060101@laposte.net> X-Archive-Number: 200604/129 X-Sequence-Number: 21298 ------=_Part_29390_30619466.1145020880206 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline SLONY should be the choice :) On 4/14/06, Pierre LEBRECH wrote: > > Hello, > > I want to replicate my PostgreSQL database at an other location. The > distance between the two locations should be around 10 miles. The link > should be a fast ethernet dedicated link. > > What would you suggest me to do? DRBD or slony1 for PostgreSQL > replication? > > Thank you. > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match > ------=_Part_29390_30619466.1145020880206 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline SLONY should be the choice :)

On 4/= 14/06, Pierre LEBRECH <pierre.lebrech@laposte.net> wrote:
Hello,

I w= ant to replicate my PostgreSQL database at an other location. The
distan= ce between the two locations should be around 10 miles. The link
should be a fast ethernet dedicated link.

What would you suggest= me to do? DRBD or slony1 for PostgreSQL replication?

Thank you.
=
---------------------------(end of broadcast)--------------------------= -
TIP 9: In versions below 8.0, the planner will ignore your desire to       choose an index scan if your joining = column's datatypes do not
       match
=

------=_Part_29390_30619466.1145020880206--