From jinujosein@yahoo.com Thu Feb 19 03:46:41 2004 X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 881C0D1E0DE for ; Thu, 19 Feb 2004 03:46:41 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 05829-06 for ; Wed, 18 Feb 2004 23:46:21 -0400 (AST) Received: from web14912.mail.yahoo.com (web14912.mail.yahoo.com [216.136.225.248]) by svr1.postgresql.org (Postfix) with SMTP id 3E1DFD1E0EF for ; Wed, 18 Feb 2004 23:46:17 -0400 (AST) Message-ID: <20040219034621.30543.qmail@web14912.mail.yahoo.com> Received: from [61.3.241.192] by web14912.mail.yahoo.com via HTTP; Wed, 18 Feb 2004 19:46:21 PST Date: Wed, 18 Feb 2004 19:46:21 -0800 (PST) From: "George A.J" Subject: Distributed Transactions To: pgsql-sql@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-651146377-1077162381=:29954" X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.4 tagged_above=0.0 required=5.0 tests=BAYES_44, HTML_MESSAGE, HTML_TAG_BALANCE_A, RCVD_IN_RFCI X-Spam-Level: X-Archive-Number: 200402/269 X-Sequence-Number: 16959 --0-651146377-1077162381=:29954 Content-Type: text/plain; charset=us-ascii Hi all, i am using PostgreSQL 7.3.2. How can i do distributed transactions in PostgreSQL. is there a transaction coordinator available for Postgres.. thanks in advance regards jinujose --------------------------------- Do you Yahoo!? Yahoo! Mail SpamGuard - Read only the mail you want. --0-651146377-1077162381=:29954 Content-Type: text/html; charset=us-ascii
Hi all,
 
i am using PostgreSQL 7.3.2. How can i do distributed transactions in PostgreSQL.
is there a transaction coordinator available for Postgres..
 
thanks in advance
regards
jinujose

Do you Yahoo!?
Yahoo! Mail SpamGuard - Read only the mail you want. --0-651146377-1077162381=:29954-- From josh@agliodbs.com Thu Feb 19 04:40:03 2004 X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id B4EBDD1E0C7 for ; Thu, 19 Feb 2004 04:40:03 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 11018-10 for ; Thu, 19 Feb 2004 00:40:07 -0400 (AST) Received: from davinci.ethosmedia.com (server228.ethosmedia.com [209.128.84.228]) by svr1.postgresql.org (Postfix) with ESMTP id 75876D1B4C5 for ; Thu, 19 Feb 2004 00:40:01 -0400 (AST) Received: from [63.195.55.98] (HELO 192.168.1.29) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.0.2) with ESMTP id 4454578; Wed, 18 Feb 2004 20:41:11 -0800 From: Josh Berkus Reply-To: josh@agliodbs.com Organization: Aglio Database Solutions To: "George A.J" , pgsql-sql@postgresql.org Subject: Re: Distributed Transactions Date: Wed, 18 Feb 2004 20:39:13 -0800 User-Agent: KMail/1.5.4 References: <20040219034621.30543.qmail@web14912.mail.yahoo.com> In-Reply-To: <20040219034621.30543.qmail@web14912.mail.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200402182039.13581.josh@agliodbs.com> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/270 X-Sequence-Number: 16960 Jinujose, > i am using PostgreSQL 7.3.2. How can i do distributed transactions in PostgreSQL. > is there a transaction coordinator available for Postgres.. Distributed transactions? Transaction coodinator? I'm not quite sure what these are. If you mean Two Phase Commit, for committing a transaction across multiple servers/databases, it's under development and may be released with version 7.5. Or later. -- -Josh Berkus Aglio Database Solutions San Francisco From scott.marlowe@ihs.com Thu Feb 19 16:47:07 2004 X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 78D01D1E167 for ; Thu, 19 Feb 2004 16:47:07 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 30238-03 for ; Thu, 19 Feb 2004 12:47:01 -0400 (AST) Received: from mail1.ihs.com (mail1.ihs.com [170.207.70.222]) by svr1.postgresql.org (Postfix) with ESMTP id 70B31D1E157 for ; Thu, 19 Feb 2004 12:47:00 -0400 (AST) Received: from css120.ihs.com (css120.ihs.com [170.207.105.120]) by mail1.ihs.com (8.12.10/8.12.10) with ESMTP id i1JGiwVo018137; Thu, 19 Feb 2004 09:44:58 -0700 (MST) Date: Thu, 19 Feb 2004 09:38:09 -0700 (MST) From: "scott.marlowe" To: "George A.J" Cc: Subject: Re: Distributed Transactions In-Reply-To: <20040219034621.30543.qmail@web14912.mail.yahoo.com> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-IHS-MailScanner: Found to be clean X-IHS-MailScanner-SpamCheck: X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/276 X-Sequence-Number: 16966 On Wed, 18 Feb 2004, George A.J wrote: > Hi all, > > i am using PostgreSQL 7.3.2. How can i do distributed transactions in PostgreSQL. > is there a transaction coordinator available for Postgres.. there isn't one, really, but you could likely roll something that worked. Oh, and update your version of postgresql. There's a nasty "won't startup" bug in 7.3.2 you'd just as soon rather avoid. It doesn't lose data, but there's nothing like restarting your database only to have it complain about some boundary condition in the write ahead log and then have to spend an hour or so with it down while you download the updates to get it working. 7.3.5 is the latest version of the 7.3 branch, but it looks like rpm wise, the latest on the sites is 7.3.4. From tgl@sss.pgh.pa.us Thu Feb 19 22:38:09 2004 X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 4DC4ED1E15D for ; Thu, 19 Feb 2004 22:38:09 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 55287-02 for ; Thu, 19 Feb 2004 18:38:08 -0400 (AST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id 16401D1E157 for ; Thu, 19 Feb 2004 18:38:06 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i1JMc6Pj023522; Thu, 19 Feb 2004 17:38:06 -0500 (EST) To: "scott.marlowe" Cc: "George A.J" , pgsql-sql@postgresql.org Subject: Re: Distributed Transactions In-reply-to: References: Comments: In-reply-to "scott.marlowe" message dated "Thu, 19 Feb 2004 09:38:09 -0700" Date: Thu, 19 Feb 2004 17:38:06 -0500 Message-ID: <23521.1077230286@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/293 X-Sequence-Number: 16983 "scott.marlowe" writes: > Oh, and update your version of postgresql. There's a nasty "won't > startup" bug in 7.3.2 you'd just as soon rather avoid. Actually I think the "won't start" bug was in 7.3.3 :-(. Still, it's good advice to keep up with the latest version in your release series. We don't make such releases just to amuse ourselves. regards, tom lane