From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Ajay Kajla <ajaykajla(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Facing issues with pgsql upgrade. |
Date: | 2022-04-17 15:59:29 |
Message-ID: | 10dcd957-dc0b-9e94-1508-0a3c958ff924@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 4/16/22 22:30, Ajay Kajla wrote:
> Hello All,
>
>
> 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.
>
>
> image.png
>
From the below it looks like something/someone deleted the template0
and template1 directories in the data directory. Is there a file backup
of the data directory?
>
> [postgres(at)htf:/var/lib/pgsql]$ psql
>
> psql (9.2.24, server 9.6.24)
>
> WARNING: psql version 9.2, server version 9.6.
>
> Some psql features might not work.
>
> Type "help" for help.
>
> postgres=# \c template0
>
> FATAL: database "template0" does not exist
>
> DETAIL: The database subdirectory "base/13268" is missing.
>
> Previous connection kept
>
> postgres=# \c template1
>
> FATAL: database "template1" does not exist
>
> DETAIL: The database subdirectory "base/1" is missing.
>
> Previous connection kept
>
> postgres=#
>
>
>
> With Regards,
>
> Ajay Kajla
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2022-04-17 16:55:24 | Re: Facing issues with pgsql upgrade. |
Previous Message | Tom Lane | 2022-04-17 15:09:46 | Re: Error dydl : image not found when trying to install pg on Catalina |