pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
About persistent connections...
5+ messages / 3 participants
[nested] [flat]

* About persistent connections...
@ 2002-03-01 14:54 David BOURIAUD <david.bouriaud@ac-rouen.fr>
  0 siblings, 0 replies; 5+ messages in thread

From: David BOURIAUD @ 2002-03-01 14:54 UTC (permalink / raw)
  To: pgsql-sql

Hi to all !

Does anyone know how the postmaster handles persistent connections ?
I use to use them with php, but yet I haven't upgraded to postgreSQL 7.2, I'm
still on version 7.1.3, and it occured to me that when my users close their
browser rather than click on the quit button I provided, their connection
remains alive and is never closed. Is there a way to set it up so that such
connections are closed after a certain amount of time of inactivity, as it is
done with ftp for example ? Thanks by advance for your help.
--
David BOURIAUD
----------------------------------------------------------
In a world without walls or fences, what use do we have
for windows or gates ?
----------------------------------------------------------
ICQ#102562021



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* About persistent connections...
@ 2002-03-01 15:29 David BOURIAUD <david.bouriaud@ac-rouen.fr>
  2002-03-01 16:06 ` Re: About persistent connections... Gary Stainburn <gary.stainburn@ringways.co.uk>
  2002-03-01 17:36 ` Re: About persistent connections... Josh Berkus <josh@agliodbs.com>
  0 siblings, 2 replies; 5+ messages in thread

From: David BOURIAUD @ 2002-03-01 15:29 UTC (permalink / raw)
  To: pgsql-sql


Hi to all !

Does anyone know how the postmaster handles persistent connections ?
I use to use them with php, but yet I haven't upgraded to postgreSQL 7.2, I'm 
still on version 7.1.3, and it occured to me that when my users close their 
browser rather than click on the quit button I provided, their connection 
remains alive and is never closed. Is there a way to set it up so that such 
connections are closed after a certain amount of time of inactivity, as it is 
done with ftp for example ? Thanks by advance for your help.
-- 
David BOURIAUD
----------------------------------------------------------
In a world without walls or fences, what use do we have 
for windows or gates ?
----------------------------------------------------------
ICQ#102562021



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: About persistent connections...
  2002-03-01 15:29 About persistent connections... David BOURIAUD <david.bouriaud@ac-rouen.fr>
@ 2002-03-01 16:06 ` Gary Stainburn <gary.stainburn@ringways.co.uk>
  2002-03-04 07:49   ` Re: About persistent connections... David BOURIAUD <david.bouriaud@ac-rouen.fr>
  1 sibling, 1 reply; 5+ messages in thread

From: Gary Stainburn @ 2002-03-01 16:06 UTC (permalink / raw)
  To: David BOURIAUD <david.bouriaud@ac-rouen.fr>; pgsql-sql

On Friday 01 March 2002 3:29 pm, David BOURIAUD wrote:
> Hi to all !
>
> Does anyone know how the postmaster handles persistent connections ?
> I use to use them with php, but yet I haven't upgraded to postgreSQL 7.2,
> I'm still on version 7.1.3, and it occured to me that when my users close
> their browser rather than click on the quit button I provided, their
> connection remains alive and is never closed. Is there a way to set it up
> so that such connections are closed after a certain amount of time of
> inactivity, as it is done with ftp for example ? Thanks by advance for your
> help.

Hi Dave,

The whole point of a persistant connection is that it doesn't close.  HTTP is 
completely stateless and unless you do clever stuff like session management, 
every visit to the site is totally seperate.  The connection process for Pg 
is slow, and the point of persistent connections is to get round this.

If you are using persistent connections, then the user clicking quit will 
make no difference anyway.  The only way to close the connection is to either 
restart the web server, or restart Postmaster.

As a site note, it would be nice to be able to set a timeout for a persistant 
connection so that periodically the connection is closed, and a new clean 
connection made on request.

-- 
Gary Stainburn
 
This email does not contain private or confidential material as it
may be snooped on by interested government parties for unknown
and undisclosed purposes - Regulation of Investigatory Powers Act, 2000     



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: About persistent connections...
  2002-03-01 15:29 About persistent connections... David BOURIAUD <david.bouriaud@ac-rouen.fr>
  2002-03-01 16:06 ` Re: About persistent connections... Gary Stainburn <gary.stainburn@ringways.co.uk>
@ 2002-03-04 07:49   ` David BOURIAUD <david.bouriaud@ac-rouen.fr>
  0 siblings, 0 replies; 5+ messages in thread

From: David BOURIAUD @ 2002-03-04 07:49 UTC (permalink / raw)
  To: pgsql-sql

Hi Gary !

> Hi Dave,
>
> The whole point of a persistant connection is that it doesn't close.  HTTP
> is completely stateless and unless you do clever stuff like session
> management, every visit to the site is totally seperate.  The connection
> process for Pg is slow, and the point of persistent connections is to get
> round this.

Sure, that's what I understood from the various docs I read !

>
> If you are using persistent connections, then the user clicking quit will
> make no difference anyway.  The only way to close the connection is to
> either restart the web server, or restart Postmaster.

Sure again, but the fact is that when I provide a "quit" button, it redirects 
the client towards a php page that closes the connection, erases the session 
file and tells him that he is now away, so, I tend to think that the 
connection is definetly closed afetr the reading of this page.

>
> As a site note, it would be nice to be able to set a timeout for a
> persistant connection so that periodically the connection is closed, and a
> new clean connection made on request.

That would be great enough indeed !
As a mater of fact, I didn't suspect the existence of pgsql-php list, as 
suggests Josh in reply of my previous mail, and I'll subscribe to this list 
right now to make out what's related to this.
Thanks anyway for your concern.

-- 
David BOURIAUD
----------------------------------------------------------
In a world without walls or fences, what use do we have 
for windows or gates ?
----------------------------------------------------------
ICQ#102562021



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: About persistent connections...
  2002-03-01 15:29 About persistent connections... David BOURIAUD <david.bouriaud@ac-rouen.fr>
@ 2002-03-01 17:36 ` Josh Berkus <josh@agliodbs.com>
  1 sibling, 0 replies; 5+ messages in thread

From: Josh Berkus @ 2002-03-01 17:36 UTC (permalink / raw)
  To: David BOURIAUD <david.bouriaud@ac-rouen.fr>; pgsql-sql

David,

> Does anyone know how the postmaster handles persistent connections ?

Please read the archives of the PGSQL-PHP list.  This issue has been
 discussed ad nauseum there.

FYI, the PGSQL-SQL list is for advanced SQL questions, like discussions
 of relational tree structures.  If you're not sure where to look for
 an answer, try the PGSQL-NOVICE list.

-Josh





^ permalink  raw  reply  [nested|flat] 5+ messages in thread


end of thread, other threads:[~2002-03-04 07:49 UTC | newest]

Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-03-01 14:54 About persistent connections... David BOURIAUD <david.bouriaud@ac-rouen.fr>
2002-03-01 15:29 About persistent connections... David BOURIAUD <david.bouriaud@ac-rouen.fr>
2002-03-01 16:06 ` Gary Stainburn <gary.stainburn@ringways.co.uk>
2002-03-04 07:49   ` David BOURIAUD <david.bouriaud@ac-rouen.fr>
2002-03-01 17:36 ` Josh Berkus <josh@agliodbs.com>

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