Re: Upgrading using pg_dumpall - Mailing list pgsql-general

From Charles Clavadetscher
Subject Re: Upgrading using pg_dumpall
Date
Msg-id 5d264a82-b92d-83da-44da-4bb6cc8e6711@swisspug.org
Whole thread Raw
In response to Upgrading using pg_dumpall  (Rich Shepard <rshepard@appl-ecosys.com>)
Responses Re: Upgrading using pg_dumpall
List pgsql-general
Hello

On 09/04/2016 01:16 AM, 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: psql: FATAL:  password authentication failed
> for user "rshepard"

Does the user rshepard exist in the new 9.5 instance?

>
>> What was the error message?
>
>   As above.
>
> Thanks,
>
> Rich
>
>

--
Swiss PostgreSQL Users Group
c/o Charles Clavadetscher
Treasurer
Motorenstrasse 18
CH – 8005 Zürich

http://www.swisspug.org

+-----------------------+
|   ____  ______  ___   |
|  /    )/      \/   \  |
| (     / __    _\    ) |
|  \    (/ o)  ( o)   ) |
|   \_  (_  )   \ ) _/  |
|     \  /\_/    \)/    |
|      \/ <//|  |\\>    |
|           _|  |       |
|           \|_/        |
|                       |
| PostgreSQL 1996-2016  |
|  20 Years of Success  |
|                       |
+-----------------------+


pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Re: Upgrading using pg_dumpall
Next
From: Christoph Berg
Date:
Subject: Re: PGDATA / data_directory