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/