Re: idle connection timeout ...

On Saturday 26 October 2002 01:04 am, Bruce Momjian wrote:
> Robert Treat wrote:
> > > Nice idea.  You can now have per-user/db settings that are SET when the
> > > connection is made.  You can set any GUC variable that way.  We just
> > > need a variable that can look at all sessions and determine if that
> > > user has exceeded their connection quota.
> >
> > I understand how you are able to set those variables per db, but I don't
> > see how you can get those settings to persist between database shutdowns.
> > Perhaps someone can point me to the relevant documentation?
>
> The per db/user stuff is stored in the pg_database/pg_shadow tables per
> row, so they exist in permanent storage.

Ah.. that was the missing link.  I don't think the docs mention anything about
the information being stored in pg_database or pg_shadow, they always refer
to the "session default"  which made me wonder what happened "between
sessions".  Perhaps someone (me?) should work up a patch to help clarify
this....

Robert Treat