Both explanations sound very similar and very logical indeed.
Never occurred to me to think that way.
Actually, now I remembered, that in a few rare occasions we had to
restart the whole server after the "refresh" and then there was no
problem, at all.
Thank you both! Iv.
--
Sent via pgsql-
Hi Ray,
On Wed, 2009-05-27 at 14:24 +0200, Iv Ray wrote:
> When the db is refreshed, the first click inside the web application
> that uses it (php 5.x, Apache 2.x), and some of the next clicks (i. e.
> the 3rd, 5th, 8th, 12th) result in the following error -
> PGSQL ERROR: server closed the c
Hi,
I guess this has nothing to do with postgres. Your web applicationdoes
some kind of connection pooling and doesn't notice when you shut down
the database. When you access the application after you reinitialized
the database it will use these old and now invald connections and run
into the give
