Re: Stalled post to pgsql-admin

Thanks, Andrew for your suggestion. I should change 255.255.0.0 to
255.255.255.255 to allow users of the PC to access the database.

zhiqiang

At 13:40 21/01/03 -0500, you wrote:
>
> Be careful with your pg_hba.conf entries (read the comments in the file
> itself, they are lengthy but useful). What you configured (below) will allow
> anyone to connect to your database from any machine without validation, as
> long as their IP address has the first two blocks equal to your machine. Are
> you sure that's what you want?
>
> Zhiqiang Feng wrote:
>>
>>
>> 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>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"
>>> <mailto:zf2(at)st-andrews(dot)ac(dot)uk><zf2(at)st-andrews(dot)ac(dot)uk> To:
>>> <mailto:pgsql-admin(at)postgresql(dot)org><pgsql-admin(at)postgresql(dot)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
>>>> <mailto:zf2(at)st-andrews(dot)ac(dot)uk>zf2(at)st-andrews(dot)ac(dot)uk
>>>> ---------------------------(end of broadcast)---------------------------
>>>> TIP 3: if posting/reading through Usenet, please send an appropriate
>>>> subscribe-nomail command to
>>>> <mailto:majordomo(at)postgresql(dot)org>majordomo(at)postgresql(dot)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>http://www.postgre
>>> sql.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
>> <mailto:zf2(at)st-andrews(dot)ac(dot)uk>zf2(at)st-andrews(dot)ac(dot)uk
>

Dr. Zhiqiang Feng
School of Geography & Geosciences
Irving Building
University of St Andrews
St Andrews Fife KY16 9AL
tel: 01334 463951

zf2(at)st-andrews(dot)ac(dot)uk