Re: Facing issues with pgsql upgrade. - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Facing issues with pgsql upgrade.
Date
Msg-id 8997b6a9-14ee-086d-8840-0516f91163bd@aklaver.com
Whole thread Raw
In response to Facing issues with pgsql upgrade.  (Ajay Kajla <ajaykajla@gmail.com>)
Responses Re: Facing issues with pgsql upgrade.
List pgsql-general
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 restore them if we have a folder backup of the data directory?

When was the backup done and how?

Are you sure it is a complete backup?

Do you have tablespaces,other then the default, in use?


> 
> Regards,
> Ajay
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com



pgsql-general by date:

Previous
From: Ajay Kajla
Date:
Subject: Re: Facing issues with pgsql upgrade.
Next
From: Ajay Kajla
Date:
Subject: Re: Facing issues with pgsql upgrade.