Re: pgsql logged in on console - su/PAM problem?

Larry Rosenman wrote:
> 
> 
> --On Tuesday, July 08, 2003 13:58:19 +0200 Lukas Ertl <l.ertl_at_univie.ac.at> 
> wrote:
> 
> > Hi,
> >
> > can anyone explain why the pgsql user is logged in on console nowadays?
> I'm seeing the same thing, and am also interested in making it stop.

It's got tomething to do with the 'su - pgsql -c ...'.

I've been able to reproduce this with an arbitrary user by doing
the following, but haven't debugged further:

ne-dead] ~ # w
11:34AM  up 22:26, 2 users, load averages: 2.46, 2.45, 2.44
USER             TTY      FROM              LOGIN_at_  IDLE WHAT
pgsql            console  -                Tue01PM 22:25 -
ianf             p0       copernicus.so.cp 11:34AM     - w
[brane-dead] ~ # su - games
Last login: Wed Jul  9 11:33:30 on ttyp0
This account is currently not available.
[brane-dead] ~ # w
11:34AM  up 22:26, 2 users, load averages: 2.55, 2.47, 2.45
USER             TTY      FROM              LOGIN_at_  IDLE WHAT
pgsql            console  -                Tue01PM 22:25 -
games            p0       -                11:34AM     - w
[brane-dead] ~ # exit
exit
[brane-dead] ~ $ w
11:34AM  up 22:26, 2 users, load averages: 2.50, 2.46, 2.45
USER             TTY      FROM              LOGIN_at_  IDLE WHAT
pgsql            console  -                Tue01PM 22:25 -
games            p0       -                11:34AM     - w

Ian