El día sábado, mayo 02, 2020 a las 08:23:52a. m. -0700, Adrian Klaver escribió:
> On 5/2/20 8:02 AM, Paul Förster wrote:
> > Hi Adrian,
> >
> >> On 02. May, 2020, at 16:59, Adrian Klaver <adrian.kla...@aklaver.com>
> >> wrote:
> >> 2) To create a new base/ you will need to initdb data/ and that is not
> >> possible as initdb will not work on a populated data/.
> >
> > you do the initdb and then copy the *.conf files from the tar over the
> > newly created ones. After that, launch the cluster.
>
> Yeah I know, I do that on a fairly regular basis. The intent was to let
> the OP know that ripping base/ out of cluster and transplanting a new
> one in is not possible.
OK, lesson learned: Next time I will do a tar backup of PGDATA after
the configuration of the cluster and before creating any database in it.
Thanks
matthias
--
Matthias Apitz, ✉ g...@unixarea.de, http://www.unixarea.de/ +49-176-38902045
Public GnuPG key: http://www.unixarea.de/key.pub
