Question - user postgres
If the admin is creating various "postgresql" users to work on different
databases - is it advisable to create these as "LINUX" users so that they
have a home directory for saving their scripts - and while we are about it -
where would experienced postgresql admins (as user postgres - no home
directory, although the set command reveals HOME=/var/lib/postgresql ???)
save their scripts - and just one more thing... this is the second time that
I have installed postgresql 8.3 - the first time I had lots of trouble just
logging user postgres on to the database engine, and finally solved the
problem with a PATH entry into /etc/profile. This time I just do su postgres
and follow with psql (from any directory) and Bobs yrrr uncle - I'm in - but
I cannot find a "PATH" entry for postmaster, so how does this work - thanks
dragonfish ???
Ps - since it is not possible to logon to the system as user postgres - is
it generally recommended that user postgres be given a password immediately
after installation - I would think yes ??? That's a silly question - I take
it back !!!
-----------------------------------------
Meddle not in the affairs of Dragons
For you are crunchy and good with Mustard
David M. Gullever
david.gullever@web.de
-----------------------------------------