stephen,
try adding the user like you normally would. Did you know the system users and database users are not necessarily the
sameperson? With that in mind, after adding the user, create an alias in .bashrc like
alias psql='/usr/local/psql -U postgresadmin -d my_db_name'
Furthermore, in /home/username (that is, that user's ~ home directory) you can put a .pgpass file which contains the
passwordfor postgresadmin
HOWEVER, it would have been simpler to simply use the 'postgres' system account as it is the universal default
On Fri, Jul 02, 2004 at 07:56:09PM +0800, Stephen Liu wrote:
> Hi folks,
>
> RH8.0
> postgresql-7.4.3.tar.gz
>
> I have postgresql-7.4.3 installed
>
> $ whereis pgsql
> pgsql: /usr/local/pgsql
>
> and have created "postgresadmin" for root
> # adduser postgresadmin
>
> root can su postgresadmin without password
>
> Now I expect to add 'userA' to login as postgresadmin
> with a password
>
> Can I perform following step to reach my goal;
>
> # adduser userA postgresadmin passwd xxx
>
> Kindly advise. TIA
>
> B.R
> Stephen
>
> _______________________________________________________________________
> Do You Yahoo!?
> Get your free @yahoo.com.hk address at http://mail.english.yahoo.com.hk
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend