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(dot)klaver(at)aklaver(dot)com