Re: I hava a problem in postgresql! - Mailing list pgsql-docs

From Roland Roberts
Subject Re: I hava a problem in postgresql!
Date
Msg-id m23dh1vyg0.fsf@tycho.rlent.pnet
Whole thread Raw
In response to I hava a problem in postgresql!  ("ksp" <ksp@ms12.url.com.tw>)
List pgsql-docs
>>>>> "ksp" == ksp  <ksp@ms12.url.com.tw> writes:
    ksp> I am a tiro in the postgresql,I will use the PHP Function to
    ksp> connection postgresql.  I use the

    ksp> pg_connect ("localhost","5432","","","webmaster")

    ksp> The error message:
    ksp> warning: Unable to connect to PostgresSQL server:
    ksp> FATAL 1: SetUserId: user 'nobody' is not in 'pg_shadow' in
    ksp>     /home/e0001cq/html/memo_postgre/memo_insert.php3 on line 2

You need to either (1) run createuser to add "nobody" to the pg_auth
table, or (2) add signon information to your pg_connect command.

If you are using PHP4, you can replace the above with

    pg_connect ("host=localhost port=5432 user=SOMEBODY password=PASSWD dbname=webmaster")

where SOMEBODY and PASSWD are appropriate for your installation.  If
you are not using password authentication, just omit that parameter.

roland
--
               PGP Key ID: 66 BC 3B CD
Roland B. Roberts, PhD                             RL Enterprises
roland@rlenter.com                     76-15 113th Street, Apt 3B
rbroberts@acm.org                          Forest Hills, NY 11375

pgsql-docs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: JDBC Documentation
Next
From: Vince Vielhaber
Date:
Subject: Re: Update of web page