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

On 5/2/20 7:30 AM, Matthias Apitz wrote:
> El día sábado, mayo 02, 2020 a las 03:23:52p. m. +0200, Paul Förster escribió:
>
>> /usr/local/sisis-pap/pgsql <= software with bin, lib64, share, etc...
>> /data/postgresql11/data <= PGDATA
>
> Exactly, his is the setup above.
>
> I will move /usr/local/sisis-pap/pgsql by tar; and I want to move some parts(!)
> of the cluster /data/postgresql11/data (configuration etc.), but not the databases
> included in /data/postgresql11/data, like the cluster(!) in PGDATA was before having
> created any database(!) in it.

That won't work for the following reasons:

1) A lot of the files/dirs included in /data/postgresql11/data are
specific to the files in /data/postgresql11/data/base as they where
created over time. They will fail when you try to merge them with new
data. More importantly see 2) below.

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/.

>
> As I said from the beginning: moving the cluster but without the
> databases in it.
>
> Thanks
>
> matthias
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com