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

From: Paul Förster <paul(dot)foerster(at)gmail(dot)com>
To: Matthias Apitz <guru(at)unixarea(dot)de>
Cc: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: How to move a 11.4 cluster to another Linux host, but empty?
Date: 2020-05-02 13:23:52
Message-ID: 6DC33DF2-120E-4EA7-B764-F1770EB66EE9@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Matthias,

> On 02. May, 2020, at 12:23, Matthias Apitz <guru(at)unixarea(dot)de> wrote:
> $ /usr/local/sisis-pap/pgsql/bin/pg_ctl -D /data/prosgresql11/data initdb

I don't get it. Is the setup now as follows

/data/postgresql11 <= software with bin, lib64, share, etc...
/data/postgresql11/data <= PGDATA

or

/usr/local/sisis-pap/pgsql <= software with bin, lib64, share, etc...
/data/postgresql11/data <= PGDATA

?

In the first case, your tar command would be:
tar cvf /tmp/postgresql11.tar --exclude=/data/postgresql11/data /data/postgresql11

Note that the --exclude option must appear BEFORE the directory tree to archive in the command line! => man tar

In the second case, your tar command would be:
tar cvf /tmp/postgresql11.tar /usr/local/sisis-pap/pgsql

to package the software only without the database.

Cheers,
Paul

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Matthias Apitz 2020-05-02 14:30:31 Re: How to move a 11.4 cluster to another Linux host, but empty?
Previous Message Matthias Apitz 2020-05-02 10:23:29 Re: How to move a 11.4 cluster to another Linux host, but empty?