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

Поиск
Список
Период
Сортировка
От Matthias Apitz
Тема How to move a 11.4 cluster to another Linux host, but empty?
Дата
Msg-id 20200501081029.GA3261@c720-r342378
обсуждение исходный текст
Ответы Re: How to move a 11.4 cluster to another Linux host, but empty?
Список pgsql-general
Hello,

I've a 11.4 cluster on a Linux host with 3 production database, all
below /data/postgresql11.4/ (i.e. the cluster itself is
/data/postgresql11.4/data) fully configured an running fine. I want to
move it "cold" (i.e. when it is shutdown) by tar to another host, BUT
without the database (due to PII and GDPR relevant data). Between the
source and target host there is no network.

Of course I could, after moving all the PostgreSQL software (all is below a top
level directory /usr/local/sisis-pap/pgsql, compiled by me) and setup the
cluster from scratch on the other host, but I wanted to have it all in one shoot by tar.

Is there a way to exclude the databases from the move by tar, or by some
sophisticated pg_* command?

Thanks

    matthias
-- 
Matthias Apitz, ✉ guru@unixarea.de, http://www.unixarea.de/ +49-176-38902045
Public GnuPG key: http://www.unixarea.de/key.pub



В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: pg_stat_statements : how to catch non successfully finished statements ?
Следующее
От: Paul Förster
Дата:
Сообщение: Re: How to move a 11.4 cluster to another Linux host, but empty?