psql uses default user from kerberos ticket not the current user - Mailing list pgsql-general

From Dmitry Litvintsev
Subject psql uses default user from kerberos ticket not the current user
Date
Msg-id Pine.LNX.4.58.1003072008460.8812@ncdf92.fnal.gov
Whole thread Raw
Responses Re: psql uses default user from kerberos ticket not the current user
List pgsql-general

Hi,

I have postgreslq 8.3.7. I have the following issue:

$ psql databasename
psql: FATAL:  role "litvinse" does not exist

If found the workaround:

$ kdestroy
$ psql databasename
Welcome to psql 8.3.7, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help with psql commands
       \g or terminate with semicolon to execute query
       \q to quit

databasename=#

Apparently default user is extracted from kerberos ticket. Is it possible
to disable this behavior and take current unix user as default user.

I would like to explicitly specify the username to psql and not to execute
kdestroy.

thank you,
--
Dmitry Litvintsev



pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Avoiding duplicates (or at least marking them as such) in a "cumulative" transaction table.
Next
From: Vick Khera
Date:
Subject: Re: postgresql 8.2 startup script