Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 1D6A19FA249 for ; Thu, 4 Jan 2007 05:05:26 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 83150-01 for ; Thu, 4 Jan 2007 05:04:28 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from nz-out-0506.google.com (nz-out-0506.google.com [64.233.162.225]) by postgresql.org (Postfix) with ESMTP id 99AA09FA131 for ; Thu, 4 Jan 2007 05:04:42 -0400 (AST) Received: by nz-out-0506.google.com with SMTP id i11so2912886nzh for ; Thu, 04 Jan 2007 01:04:41 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=q/hkMGcJGhfz0cmOLB14NmfgVnYhDdV8iWbPzjlEG9SkxJ27je14Uobft1a+6dEwqG4UaYg8hHA9MrKeguPnOBIcsvaBJjF/Hh8oTC9Smd3UgGWgmHAqjDfAQaJ5SzTmM4hGw+GVvSFRy1XZr3HWawn4xPIy+Jk24/dgxIla0uY= Received: by 10.65.114.11 with SMTP id r11mr13710905qbm.1167901481652; Thu, 04 Jan 2007 01:04:41 -0800 (PST) Received: by 10.65.188.5 with HTTP; Thu, 4 Jan 2007 01:04:41 -0800 (PST) Message-ID: Date: Thu, 4 Jan 2007 14:04:41 +0500 From: "Shoaib Mir" To: "anorganic anorganic" Subject: Re: Replication Cc: pgsql-admin@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_2775_32401603.1167901481617" References: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/16 X-Sequence-Number: 24172 ------=_Part_2775_32401603.1167901481617 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Did you try Slony with PostgreSQL? -------------- Shoaib Mir EnterpriseDB (www.enterprisedb.com) On 1/4/07, anorganic anorganic wrote: > > Hello, > > i need make with postgre something as this: > > i have two servers S1 and S2, connection is quit good, but sometimes once > or twice per month there is short disconnection, longer discoonection 2x per > year (1-2+ hours) > on both are running updates > i need have same data in time, but i never update same collumns on S1 an > S2, S1 change another atributes than S2 = there are no conflicts, on MS SQL > i use transactional replication and i like find somethin same for postgre. > > Can u please send me some info where can i found what i need, which > postgre tool is right way for me.. > > Thnx a lot. > > ------=_Part_2775_32401603.1167901481617 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Did you try Slony with PostgreSQL?

--------------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)

On 1/4/07, anorganic anorganic <anorganicphc@gmail.com> wrote:
Hello,

i need make with postgre something as this:

i have two servers S1 and  S2, connection is quit good, but sometimes once or twice per month there is short disconnection, longer discoonection 2x per year (1-2+ hours)
on both are running updates
i need have same data in time, but i never update same collumns on S1 an S2, S1 change another atributes than S2 =  there are no conflicts, on MS SQL i use transactional replication and i like find somethin same for postgre.

Can u please send me some info where can i found what i need, which postgre tool is right way for me..

Thnx a lot.


------=_Part_2775_32401603.1167901481617--