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