apt installation postgresql 8.3

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
-----------------------------------------

Responses

Browse pgsql-admin by date

  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