| From: | Magnus Hagander <magnus(at)hagander(dot)net> |
|---|---|
| To: | John R Pierce <pierce(at)hogranch(dot)com> |
| Cc: | pgsql-bugs <pgsql-bugs(at)postgresql(dot)org> |
| Subject: | Re: psql security fail? |
| Date: | 2013-11-05 20:15:42 |
| Message-ID: | CABUevEwOYZ0FUrX9v6hjwH=45k+YRj5sQvTdPn52tHRJFZv_vw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Tue, Nov 5, 2013 at 9:10 PM, John R Pierce <pierce(at)hogranch(dot)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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Maxy | 2013-11-05 20:19:01 | Re: psql security fail? |
| Previous Message | Sergey Konoplev | 2013-11-05 20:12:21 | Re: Completely broken replica after PANIC: WAL contains references to invalid pages |