Re: Facing issues with pgsql upgrade. - Mailing list pgsql-general

From David G. Johnston
Subject Re: Facing issues with pgsql upgrade.
Date
Msg-id CAKFQuwZ35FN3LB7nfX_oW27hTcZx5AGgPGz+0hXCkuwbToenQA@mail.gmail.com
Whole thread Raw
In response to Facing issues with pgsql upgrade.  (Ajay Kajla <ajaykajla@gmail.com>)
List pgsql-general
On Sun, Apr 17, 2022 at 8:53 AM Ajay Kajla <ajaykajla@gmail.com> wrote:


I'm facing the following issue while upgrading pgsql 9.6 to pgsql 13. 

It's saying database "template0" "template1" does not exist on source 9.6, please advise.



You might want to just forget doing a pg_upgrade migration and do a pg_dumpall one instead.  The missing template databases on the existing cluster shouldn't be noticed.

You can decide how important missing the directories are to you, since that shouldn't happen outside someone going in and "rm'ing" them.

David J.

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Facing issues with pgsql upgrade.
Next
From: Ajay Kajla
Date:
Subject: Re: Facing issues with pgsql upgrade.