Re: [INTERFACES] About connecting to a database

Mariano Herrero <mariano(at)uni-paderborn(dot)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