Re: Stalled post to pgsql-admin - Mailing list pgsql-admin
From | Leland F. Jackson, CPA |
---|---|
Subject | Re: Stalled post to pgsql-admin |
Date | |
Msg-id | 004a01c2c0fb$c3529a10$7401a8c0@jackson Whole thread Raw |
In response to | Re: Stalled post to pgsql-admin (Zhiqiang Feng <zf2@st-andrews.ac.uk>) |
Responses |
Re: Stalled post to pgsql-admin
(Zhiqiang Feng <zf2@st-andrews.ac.uk>)
|
List | pgsql-admin |
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
pgsql-admin by date: