Search Postgresql Archives

Re: How to move a 11.4 cluster to another Linux host, but empty?

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

 



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.klaver@xxxxxxxxxxx> 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, ✉ guru@xxxxxxxxxxx, http://www.unixarea.de/ +49-176-38902045
Public GnuPG key: http://www.unixarea.de/key.pub





[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 Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux