From: | Charles Clavadetscher <clavadetscher(at)swisspug(dot)org> |
---|---|
To: | Rich Shepard <rshepard(at)appl-ecosys(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Upgrading using pg_dumpall |
Date: | 2016-09-04 15:19:15 |
Message-ID: | f35abe7f-a5a7-acaf-f6ae-2779aef591a7@swisspug.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi
On 09/04/2016 05:16 PM, Charles Clavadetscher wrote:
> Hi
>
> On 09/04/2016 05:14 PM, Rich Shepard wrote:
>> On Sat, 3 Sep 2016, Adrian Klaver wrote:
>>
>>> Or if you are fine running the 9.5 instance at port 5432, what happens
>>> if you do?:
>>>
>>> psql -d postgres -U some_user -p 5432
>>
>> $ psql -d postgres -U rshepard -p 5432
>> Password for user rshepard: FATAL: password authentication failed for
>> user "rshepard"
>> DETAIL: User "rshepard" has no password assigned.
>> Connection matched pg_hba.conf line 80: "local all all
>> md5"
>> psql: FATAL: password authentication failed for user "rshepard"
>>
>> but,
>>
>> $ psql -d postgres -U postgres -p 5432
>> Password for user postgres: psql (9.5.4)
>> Type "help" for help.
>>
>> postgres=#
>>
>> So, it appears to be a password issue. Please advise me how to get the
>> running postmaster process to accept my accessing databases without a
>> password being required.
>
> Adrian already answered that. You can set the connection authentication
> method to trust. This can have some risks, however.
You may also consider using a .pgpass file:
https://www.postgresql.org/docs/9.5/static/libpq-pgpass.html
Bye
Charles
>
> Bye
> Charles
>
>>
>> Thanks again,
>>
>> Rich
>>
>>
>
--
Swiss PostgreSQL Users Group
c/o Charles Clavadetscher
Treasurer
Motorenstrasse 18
CH – 8005 Zürich
+-----------------------+
| ____ ______ ___ |
| / )/ \/ \ |
| ( / __ _\ ) |
| \ (/ o) ( o) ) |
| \_ (_ ) \ ) _/ |
| \ /\_/ \)/ |
| \/ <//| |\\> |
| _| | |
| \|_/ |
| |
| PostgreSQL 1996-2016 |
| 20 Years of Success |
| |
+-----------------------+
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2016-09-04 15:26:46 | Re: Upgrading using pg_dumpall |
Previous Message | Charles Clavadetscher | 2016-09-04 15:16:54 | Re: Upgrading using pg_dumpall |