Re: Stalled post to pgsql-admin

Поиск
Список
Период
Сортировка
От Andrew Biagioni
Тема Re: Stalled post to pgsql-admin
Дата
Msg-id 3E2D9420.4010908@e-greek.net
обсуждение исходный текст
Ответ на Re: Stalled post to pgsql-admin  (Zhiqiang Feng <zf2@st-andrews.ac.uk>)
Ответы Re: Stalled post to pgsql-admin  (Zhiqiang Feng <zf2@st-andrews.ac.uk>)
Список pgsql-admin
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

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


 


В списке pgsql-admin по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Failed to initialize lc_messages to ''
Следующее
От: Murthy Kambhampaty
Дата:
Сообщение: Re: ReceiveSharedInvalidMessages: cache state reset