Hi Adrian,
Command \l gives the list of db available DBs in the cluster including
template0 and template1, I can connect to other DBs and run queries as
well.
My motive is just to upgrade pgsql from 9.6 to 13 using the pg_upgrade
command.
Regards,
Ajay
On Mon, Apr 18, 2022 at 9:48 AM Adrian Kla
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
wrote:
> On 4/16/22 22:30, Ajay Kajla wrote:
> > Hello All,
> >
> >
> > I'm facing the followin
On 4/17/22 22:54, Ajay Kajla wrote:
Hi Adrian,
Command \l gives the list of db available DBs in the cluster including
template0 and template1, I can connect to other DBs and run queries as
well.
My motive is just to upgrade pgsql from 9.6 to 13 using the pg_upgrade
command.
Do you have fi
On 4/17/22 19:11, Ajay Kajla wrote:
Thanks Adrian,
1. What if we re-create template0 and template1?
First I would determine what else might be missing?
In psql what happens if you do:
\l
to get a list of databases?
And can you connect to the databases other then postgres?
2. how to rest
On Sun, Apr 17, 2022 at 8:53 AM Ajay Kajla 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_
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
