Re: ODBC and pgpool

From: Mark Morgan Lloyd <markMLl(dot)pgsql-odbc(at)telemetry(dot)co(dot)uk>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Re: ODBC and pgpool
Date: 2006-02-05 10:04:47
Message-ID: 43E5CDBF.BD0A14B6@telemetry.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Sure, when I've had time to rewrite the apps.

I'm not trying to be flip, I mean it since I'm interested in porting to Lazarus
and preferably getting off x86. Right now the apps use ODBC but I'm planning a
server upgrade since I need some of the newer facilities and want to eliminate
as many points of failure as possible.

What would be nice would be if ODBC could itself failover between servers, but
from the point of view of this ML that comment's just from another kvetching
luser- I've got neither the time nor the C expertise to get directly involved.

Ben Trewern wrote:
>
> I'd try zeoslib instead see http://forum.zeoslib.net.ms/. It's not perfect
> but works well for what I'm using it for.
>
> Regard
>
> Ben
>
> "Mark Morgan Lloyd" <markMLl(dot)pgsql-odbc(at)telemetry(dot)co(dot)uk> wrote in message
> news:43E0999E(dot)7281D1F(at)telemetry(dot)co(dot)uk(dot)(dot)(dot)
> > Many thanks. Not the most desirable situation but at least it's a clear
> > answer.
> >
> > My current situation is that I'm using Delphi on the clients, this has
> > data-aware components that adopt undefined (or at the very least
> > inconvenient
> > :-) states when no longer connected to the underlying database. However I
> > have
> > aother reasons to want to discard these, so this becomes just one more
> > factor to
> > consider in the redesign.
> >
> > Peter Eisentraut wrote:
> >>
> >> Mark Morgan Lloyd wrote:
> >> > If a Win-32 system connects via ODBC to pgpool, does the system
> >> > running pgpool have to be permanently running or can it be rebooted
> >> > without deranging open but quiescent connections?
> >>
> >> No, your application will have to be able to reconnect if the connection
> >> is lost by reason of the "server" disappearing or having been moved.

--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk

[Opinions above are the author's, not those of his employers or colleagues]

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Ludek Finstrle 2006-02-05 19:13:01 Re: Document omission
Previous Message Tom Lane 2006-02-05 00:55:34 Re: Latest release of PostgreSQL ODBC driver