Re: Upgrading using pg_dumpall

Hello

On 09/04/2016 05:11 PM, Rich Shepard wrote:
> On Sun, 4 Sep 2016, Adrian Klaver wrote:
>
>> But the message you sent me offlist showed the 9.5 instance running.
>
> But now it's not running.
>
>> How are you starting the instance?
>
> As superuser poostgres: pg_ctl start -D /var/lib/pgsql/data &
>
> After removing an orphaned postmaster.pid the above seemed to have
> started
> postgres, but there's no postmaster process running.
>
>> Are you sure that the password being asked for is not for the OS user
>> you are using to run whatever start script you are using?
>
> Thinking postmaster is running I tried this:
>
> $ psql crm
> Password: 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"

Well, there you have it. As Adrian suggested you may set temporarily the
authentication method to trust, set yourself a password and change it
back to md5.

That should do.
Bye
Charles

>
> The crm database is owned by me.
>
>> I have never used it, but I am pretty sure that is not what -W means. It
>> looks to me that it asks you to create a password at init for the
>> database
>> superuser(in this case postgres) and only that user when that user tries
>> to use log into a database after the cluster is started.
>
> From man initdb:
>
> -W, --pwprompt
> Makes initdb prompt for a password to give the database
> superuser.
> If you don't plan on using password authentication, this is not
> important. Otherwise you won't be able to use password
> authentication until you have a password set up.
>
> The superuser already exists in /etc/passwd.
>
>> Do you remember what password you specified?
>
> Yes. It's the same password I use for logging in as a user. If it's the
> superuser password being requested, then that's the same as my user
> password.
>
> The Slackware rc.postgresql file for 9.5 has changed from 9.3 and
> earlier.
> It's asking for passwords:
>
> if [ ! -e $DATADIR/PG_VERSION ]; then
> echo "You should initialize the PostgreSQL database
> at location $DATADIR"
> echo "e.g. su postgres -c \"initdb -D $DATADIR
> --locale=en_US.UTF-8 -A md5 -W\""
> exit 6
> fi
>
> Note the '-W' at the end. But, I ran initdb from the command line as user
> postgres.
>
> 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 |
| |
+-----------------------+