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
