Search Postgresql Archives

Re: Facing issues with pgsql upgrade.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.klaver@xxxxxxxxxxx> 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.klaver@xxxxxxxxxxx


--


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux