Re: Stalled post to pgsql-admin

Thank Leland and Andrews for your help.

I successfully use pgaccess to add users and now can start postgresql as a
normal user.

However, it seems pgaccess requires TCP/IP port connection so I have to
include
host          all    IP_address_of_pc     255.255.0.0        trust

in the pg_hba.conf.

With regards,

Zhiqiang

At 21:18 20/01/03 -0600, Leland F. Jackson, CPA wrote:
>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
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?
>
>http://www.postgresql.org/users-lounge/docs/faq.html

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