Обсуждение: About connecting to a database

Hello everybody,

I have the following problem. When I execute my application to query a
PostgresSQL database, the PGsetdb function gives me the following error:

FATAL: PQsetdb: Unable to determine a Postgres username!

and the application can't connect to the database.


Could anyone say me what the reason can be ? Thanks in advance !!

Regards,

    Mariano

 -------------------------------------------------------------------
 Mariano Herrero                   office: F2.315
 University of  Paderborn          voice:  +49 5251 60-6693
 Dept. of Computer Science         fax:    +49 5251 60-6697
 Fuerstenallee 11                  mailto:mariano@uni-paderborn.de
 33102 Paderborn, Germany

 http://www.uni-paderborn.de/fachbereich/AG/monien/PERSONAL/MARIANO/
 -------------------------------------------------------------------

Mariano Herrero <mariano@uni-paderborn.de> writes:
> I have the following problem. When I execute my application to query a
> PostgresSQL database, the PGsetdb function gives me the following error:
> FATAL: PQsetdb: Unable to determine a Postgres username!

libpq looks for an environment variable PGUSER.  If that's not found,
it either tries Kerberos (if compiled to use Kerberos) or tries
    getpwuid(geteuid());
to get your userID from the Unix system.

Perhaps you have a malfunctioning Kerberos environment?
Or maybe getpwuid is failing, but that ought to have stopped you
from even logging in...

Anyway, you can override all this by setting PGUSER, or by calling
PQsetdbLogin so you can pass an explicit username.  But it might
be better to figure out why plain PQsetdb isn't working.

            regards, tom lane