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@xxxxxx ----------------------------------------- -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
