From: | "David M(dot) Gullever" <david(dot)gullever(at)web(dot)de> |
---|---|
To: | "Postgresql" <pgsql-admin(at)postgresql(dot)org> |
Subject: | apt installation postgresql 8.3 |
Date: | 2012-01-16 20:24:41 |
Message-ID: | 20120116211659.649642CE0E@smtp.orange.ug |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(dot)gullever(at)web(dot)de
-----------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Fujii Masao | 2012-01-17 03:44:09 | Re: PG synchronous replication and unresponsive slave |
Previous Message | Manoj Govindassamy | 2012-01-16 18:51:23 | PG synchronous replication and unresponsive slave |