Re: I hava a problem in postgresql!

From: "Oliver Elphick" <olly(at)lfix(dot)co(dot)uk>
To: "ksp" <ksp(at)ms12(dot)url(dot)com(dot)tw>
Cc: pgsql-docs(at)postgresql(dot)org
Subject: Re: I hava a problem in postgresql!
Date: 2000-11-09 17:19:41
Message-ID: 200011091719.eA9HJg531162@linda.lfix.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

"ksp" wrote:
>I am a tiro in the postgresql,I will use the PHP Function to connection pos=
>tgresql.I use the=20
>pg_connect("localhost","5432","","","webmaster")
>
>The error message:
>warning: Unable to connect to PostgresSQL server: FATAL 1: SetUserId: user =
>'nobody' is not in 'pg_shadow' in /home/e0001cq/html/memo_postgre/memo_inse=
>rt.php3 on line 2

PostgreSQL users are not the same as system users. You have to create
the user `nobody' in PostgreSQL (or tell PHP to connect as a different user).

As user postgres, do: `createuser nobody' at the shell prompt and answer
the questions.

--
Oliver Elphick Oliver(dot)Elphick(at)lfix(dot)co(dot)uk
Isle of Wight http://www.lfix.co.uk/oliver
PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47 6B 7E 39 CC 56 E4 C1 47
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"O death, where is thy sting? O grave, where is
thy victory?" 1 Corinthians 15:55

Browse pgsql-docs by date

  From Date Subject
Next Message Roland Roberts 2000-11-09 17:37:35 Re: I hava a problem in postgresql!
Previous Message ksp 2000-11-09 16:41:44 I hava a problem in postgresql!