Re: Move cluster to new host, upgraded version [DONE]

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