psql uses default user from kerberos ticket not the current user

From: Dmitry Litvintsev <litvinse(at)fnal(dot)gov>
To: pgsql-general(at)postgresql(dot)org
Subject: psql uses default user from kerberos ticket not the current user
Date: 2010-03-08 02:20:49
Message-ID: Pine.LNX.4.58.1003072008460.8812@ncdf92.fnal.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2010-03-08 02:26:32 Re: Transaction wraparound problem with database postgres
Previous Message Markus Wollny 2010-03-08 01:06:57 Re: Transaction wraparound problem with database postgres