Re: psql security fail?

On Tue, Nov 5, 2013 at 9:10 PM, John R Pierce <pierce@hogranch.com> wrote:
> On 11/3/2013 12:20 PM, Maxy wrote:
>>
>> psql -d mydb
>>
>> pg asks me the password but if i do
>>
>> psql -U postgresql -d mydb
>>
>> pg don't ask me the password.
>> PostgreSQL 9.2.4 on i686-pc-linux-gnu, compiled by gcc (GCC) 4.7.1, 32-bit
>
>
>
> $ psql -U postgresql -d mydb
> psql: FATAL:  role "postgresql" does not exist
>
>  PostgreSQL 9.2.4 on i686-pc-linux-gnu, compiled by gcc (GCC) 4.1.2 20080704
> (Red Hat 4.1.2-54), 32-bit
>
>
> something is whack.

I would check if there's by any chance a .pgpass file in your home
directory, which contains the password used to log in.


--
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/