From: | Carol Walter <walterc(at)indiana(dot)edu> |
---|---|
To: | |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Database in use? |
Date: | 2009-03-04 15:05:35 |
Message-ID: | 57663379-4339-4E2F-B03D-C588A74C1AFF@indiana.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
That's interesting and is probably the answer to my question as to why
this happens. Thanks, Nick. What it doesn't explain is why I was
able to connect to a test database using PhpPgAdmin and close the
browser, without logging out, and I was able to rename my test
database. I couldn't reproduce the behavior. I wonder if it is a
property of the particular browser or desktop platform. I was using
Firefox on a Mac. The users use Windows. I'm not sure which browser
they are using.
I also still want to know if there is a way to gracefully break that
persistent connection on the server side. Using a PHP front end over
the web, I don't always know who has a browser open.
Thanks,
Carol
On Mar 4, 2009, at 9:36 AM, Hajek, Nick wrote:
>>
>> The users are accessing the database using PhpPgAdmin. I
>> thought that this might happen if they closed the browser
>> without closing logging off. I know that if you do that the
>> browser will return to where you left it, when you open it
>> again. I tried that with my own database, and I couldn't
>> reproduce the condition.
>>
>> Carol
>
>
> A persistent connection is often used with PHP. With this, PHP will
> maintain the connection after a browser is closed or a user is logged
> off so that the next time a db connection is required, the response
> time
> is better. To break any persistent connections would require
> restarting
> the browser.
>
> Nick Hajek
From | Date | Subject | |
---|---|---|---|
Next Message | Jan-Peter.Seifert | 2009-03-04 17:38:15 | Re: getting 'full' names of functions? |
Previous Message | Kevin Grittner | 2009-03-04 14:49:43 | Re: Backing up postgresql database |