pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedDistributed Transactions
4+ messages / 4 participants
[nested] [flat]
* Distributed Transactions
@ 2004-02-19 03:46 George A.J <jinujosein@yahoo.com>
0 siblings, 2 replies; 4+ messages in thread
From: George A.J @ 2004-02-19 03:46 UTC (permalink / raw)
To: pgsql-sql
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.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Distributed Transactions
@ 2004-02-19 04:39 Josh Berkus <josh@agliodbs.com>
parent: George A.J <jinujosein@yahoo.com>
1 sibling, 0 replies; 4+ messages in thread
From: Josh Berkus @ 2004-02-19 04:39 UTC (permalink / raw)
To: George A.J <jinujosein@yahoo.com>; pgsql-sql
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Distributed Transactions
@ 2004-02-19 16:38 scott.marlowe <scott.marlowe@ihs.com>
parent: George A.J <jinujosein@yahoo.com>
1 sibling, 1 reply; 4+ messages in thread
From: scott.marlowe @ 2004-02-19 16:38 UTC (permalink / raw)
To: George A.J <jinujosein@yahoo.com>; +Cc: pgsql-sql
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.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Distributed Transactions
@ 2004-02-19 22:38 Tom Lane <tgl@sss.pgh.pa.us>
parent: scott.marlowe <scott.marlowe@ihs.com>
0 siblings, 0 replies; 4+ messages in thread
From: Tom Lane @ 2004-02-19 22:38 UTC (permalink / raw)
To: scott.marlowe <scott.marlowe@ihs.com>; +Cc: George A.J <jinujosein@yahoo.com>; pgsql-sql
"scott.marlowe" <scott.marlowe@ihs.com> 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
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2004-02-19 22:38 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-02-19 03:46 Distributed Transactions George A.J <jinujosein@yahoo.com>
2004-02-19 04:39 ` Josh Berkus <josh@agliodbs.com>
2004-02-19 16:38 ` scott.marlowe <scott.marlowe@ihs.com>
2004-02-19 22:38 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox