Search Postgresql Archives

Re: Facing issues with pgsql upgrade.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Thanks Adrian,

1. What if we re-create template0 and template1?

2. how to restore them if we have a folder backup of the data directory?

Regards,
Ajay


On Sun, Apr 17, 2022 at 9:29 PM Adrian Klaver <adrian.klaver@xxxxxxxxxxx> wrote:
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@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.klaver@xxxxxxxxxxx


--


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux