"Dietmar May" <dcmay@dmis.com> writes:
> So, why can't the server-side code that closes the connection release any
> resources associated with that connection before the socket is closed? It
> seems that doing so could fix this problem quite cleanly.
How would that help? The client isn't waiting around for it, because it
already closed its socket.
> Perhaps I'm misunderstanding the manual - "4.1: When a new database is
> created, the template database [template1] is essentially cloned.
At least in recent versions, template1 is only the default template,
not the sole possibility.
In theory you could in fact run without any template1, but it would
break enough client-side code that I doubt anyone would find it useful
to do so in practice.
regards, tom lane