Hi Zhiqiang, You might take a look at the following link:
http://www.tek-tips.com/viewthread.cfm?SQID=449717&SPID=699&page=1 After you have postgres user properly setup, you can use pgaccess to configure other users. LelandJ ----- Original Message ----- From: "Zhiqiang Feng" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, January 20, 2003 7:52 AM Subject: Re: [ADMIN] Stalled post to pgsql-admin > > Hello all, > > I am new to postgreSQL. I have installed postgreSQL 7.1.3-2 on Linux 7.2. > If I login as root (administrator) and change user as postgres I can create > database on /usr/local/pgsql/data which I created and changed its owner as > postgres. > > root# mkdir usr/local/pgsql/data > root# chown postgres /usr/local/pgsql/data > root# su postgres > bash-2.3# initdb -D /usr/local/pgsql/data > bash-2.3# postmaster -D /usr/local/pgsql/data > logfile 2 >&1 & > bash-2.3# createdb testdb > bash-2.3# psql testdb > > However, when I login as a normal linux user I cannot create database. So > it is a user management problem. > > zf2linux# createdb mydb > FATAL 1: user 'zf2linux' does not exist > > I have tried to create a user of zf2linux in postgreSQL but the error still > occurs. > If I try to change to postgres from zf1linux it asks for password. > > zf2linux# su postgres > password: ****** > incorrect password. > > My pg_hba.conf is left as the default format: > > local all trust > host all 127.0.0.1 255.255.255.255 trust > > I must miss something before I allow other users to access the postgreSQL > server and account. Could you please help me with the problem? > > Thanks for your attention and will sum. > > Geoff > > Dr. Zhiqiang Feng > School of Geography & Geosciences > Irving Building > University of St Andrews > St Andrews Fife KY16 9AL > tel: 01334 463951 > > [EMAIL PROTECTED] > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to [EMAIL PROTECTED] so that your > message can get through to the mailing list cleanly ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html