Reply-To: <david.gullever@web.de>
From: "David M. Gullever" <david.gullever@web.de>
To: "Postgresql" <pgsql-admin@postgresql.org>
Subject: apt installation postgresql 8.3
Date: Mon, 16 Jan 2012 23:24:41 +0300
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit
Thread-Index: AczUjOC86+EH7sBcQcKTuAk/fTExLA==
Message-Id: <20120116211659.649642CE0E@smtp.orange.ug>

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