Skip site navigation (1) Skip section navigation (2)

libpgtcl modifications

From: g(dot)hintermayer(at)mail(dot)inode(dot)at
To: pgsql-interfaces(at)postgresql(dot)org
Subject: libpgtcl modifications
Date: 2002-08-08 08:52:13
Message-ID: E17cj1h-0004SY-00@e-mail.inode.at (view raw or flat)
Thread:
Lists: pgsql-interfaces
I hacked libpgtcl to get the following working:
> A broken backend connection trigers a notify event to the client (fixed
> notification string "connection_closed") so proper action can be taken to switch
> to another database server etc. Remember that this is event driven. If you have
> applications, that have idle database connections most of the time, you'll get
> immediate feedback of a dying server. Upon connection to the server issue a
> pg_notify for notify event "connection_closed" and whenever the backend crashes
> (which it does do in very very rare cases) you get an event driven recovery. (of
> course the Tcl-Event loop has to be processed). Issuing a notification
> "connection_closed" on a still working database could be used for switching to
> another db-server.
> I'd like to share my changes (because I don't want to apply them to every
> release). What's the way to go ?

Attached is a patch (hope I did it right ;-) )

Gerhard
--
Gerhard Hintermayer
http://www.inode.at/g.hintermayer

Attachment: patch-notification.gz
Description: text/plain (1.3 KB)

pgsql-interfaces by date

Next:From: Michael MeskesDate: 2002-08-11 13:58:51
Subject: Re: ECGP - varchar in struct?
Previous:From: Iavor RaytchevDate: 2002-08-07 14:42:50
Subject: pgaccess 0.98.8p3 weekly release

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group