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" <zf2@st-andrews.ac.uk>
To: <pgsql-admin@postgresql.org>
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
>
> zf2@st-andrews.ac.uk
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly