Re: [PERFORM] backend pid changing

2008-06-04 Thread Lewis Kapell
We are not using connection pooling, however the clients are tunneling through SSH. Forgot to mention that in my first message. Does that make any difference to it? Thank you, Lewis Kapell Computer Operations Seton Home Study School Tom Lane wrote: Lewis Kapell <[EMAIL PROTECTED]> writes:

Re: [PERFORM] backend pid changing

2008-06-04 Thread Tom Lane
Lewis Kapell <[EMAIL PROTECTED]> writes: > ... By examining the logs, I have observed that the > backend pid for a particular client sometimes changes during a session. That is just about impossible to believe, unless perhaps you have a connection pooler in the loop somewhere?

Re: [PERFORM] backend pid changing

2008-06-04 Thread Matthew Wakeling
On Wed, 4 Jun 2008, Lewis Kapell wrote: The client sends its authorization information immediately before sending the data, and also with the data chunk. Well, I have no idea why the backend pid is changing, but here it looks like you have a classic concurrency problem caused by checking a var

[PERFORM] backend pid changing

2008-06-04 Thread Lewis Kapell
I have a Windows application which connects to a Postgres (8.3) database residing on our company server. Most of the application's users work from their homes, so the application was developed with a lot of security checks. When a client connects to the database, a random hash is generated an