On 11/11/18 11:21 AM, Rich Shepard wrote:
My current desktop server/workstation is running version 10.5. I'm
configuring a replacement desktop and have installed version 11.1 on it. To
copy all databases from the 10.5 version to the 11.1 version I assume
that I
should do a pg_dumpall on the current host and read in that file on the
replacement host. Is this the proper procedure?
See Andrew's reply for pg_dumpall advice.
Not sure if you have any extensions or not, but the part I often skip is
installing extensions in the new cluster before running the dump restore.
TIA,
Rich
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
