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
