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

From: Matthias Apitz <guru(at)unixarea(dot)de>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: How to move a 11.4 cluster to another Linux host, but empty?
Date: 2020-05-01 08:10:29
Message-ID: 20200501081029.GA3261@c720-r342378
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)unixarea(dot)de, http://www.unixarea.de/ +49-176-38902045
Public GnuPG key: http://www.unixarea.de/key.pub

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Paul Förster 2020-05-01 08:23:37 Re: How to move a 11.4 cluster to another Linux host, but empty?
Previous Message Tom Lane 2020-04-30 22:26:48 Re: pg_stat_statements : how to catch non successfully finished statements ?