On Wed, 14 Nov 2018, Rich Shepard wrote:
> I think that I FUBARed the upgrade from 10.3 to 11.1. I've removed both
> packages and am rebuilding 11.1. I'll install it, run initdb on it, then
> re-run pg_dumpall on the 10.5 data directory on the old desktop. Starting
> from scratch on this new desktop will save time for all of us.
All fixed now. To complete the thread this is what I did:
1) Removed Slackware packages for postgresql-10.3 and -11.1.
2) Removed /var/lib/pgsql/10.3 and 11.1.
3) Re-built postgresql-11.1 and re-installed it.
4) As user 'postgres' ran initdb and pg_ctl start pointing to
/var/lib/pgsql/11/data.
5) Edited postgresql.conf and pg_hba.conf to accept connections from all
hosts on the LAN.
6) Re-started postgres.
7) As 'postgre' ran
pg_dumpall -h salmo -c -f pg-all-2018-11-14.sql
8) Then postgres ran
psql -f pg-all-2018-11-14.sql
Now I, as a user, can access my databases without a password.
Thank you, Adrian, for your patient help. And you, Tom, for your helpful
comment.
Best regards,
Rich