From: | Ajay Kajla <ajaykajla(at)gmail(dot)com> |
---|---|
To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Facing issues with pgsql upgrade. |
Date: | 2022-04-18 05:54:38 |
Message-ID: | CAGBudonYXiFv=TGDmECu3gWS9113oU4jUSO_hbvsq15-xQeRDw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 Klaver <adrian(dot)klaver(at)aklaver(dot)com>
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 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(dot)klaver(at)aklaver(dot)com
>
--
From | Date | Subject | |
---|---|---|---|
Next Message | Pól Ua Laoínecháin | 2022-04-18 09:56:39 | Puzzline CROSS JOIN when doing RECURSIVE CTE |
Previous Message | Adrian Klaver | 2022-04-18 04:17:58 | Re: Facing issues with pgsql upgrade. |