stephen, try adding the user like you normally would. Did you know the system users and database users are not necessarily the same person? 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 password for 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 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
