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 02:11:17 |
Message-ID: | CAGBudo=Ws+FsYJERG51a=XKEKNcMOwmgiQjq5TFCHeir0JBwrQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 <adrian(dot)klaver(at)aklaver(dot)com>
wrote:
> 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
> and template1 directories in the data directory. Is there a file backup
> of the data directory?
>
> >
> > [postgres(at)htf:/var/lib/pgsql]$ psql
> >
> > psql (9.2.24, server 9.6.24)
> >
> > WARNING: psql version 9.2, server version 9.6.
> >
> > Some psql features might not work.
> >
> > Type "help" for help.
> >
> > postgres=# \c template0
> >
> > FATAL: database "template0" does not exist
> >
> > DETAIL: The database subdirectory "base/13268" is missing.
> >
> > Previous connection kept
> >
> > 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
> >
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>
--
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2022-04-18 04:17:58 | Re: Facing issues with pgsql upgrade. |
Previous Message | David G. Johnston | 2022-04-17 16:55:24 | Re: Facing issues with pgsql upgrade. |