Facing issues with pgsql upgrade.

2022-04-17 Thread Ajay Kajla
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

Re: Facing issues with pgsql upgrade.

2022-04-18 Thread Ajay Kajla
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, > > > &g

Re: Facing issues with pgsql upgrade.

2022-04-18 Thread Ajay Kajla
Klaver wrote: > 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 databa