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-01 08:59:06
Message-ID: 2A3EB078-C20F-4DB6-8EDA-FD267B733284@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Matthias,

> On 01. May, 2020, at 10:31, Matthias Apitz <guru(at)unixarea(dot)de> wrote:
>
> I don't. The software is below
>
> /usr/local/sisis-pap/pgsql
>
> and the cluster is below
>
> /data/postgres11.4/data.

in this case, all you'd have to do is:

tar cvf software.tar /usr/local/sisis-pap/pgsql

to only copy the software. You don't even need to stop the database cluster for this because nothing is ever changed inside the software tree by a running database cluster. Changes are only done in PGDATA.

Cheers,
Paul

In response to

Browse pgsql-general by date

  From Date Subject
Next Message legrand legrand 2020-05-01 09:26:13 Re: pg_stat_statements : how to catch non successfully finished statements ?
Previous Message Matthias Apitz 2020-05-01 08:31:48 Re: How to move a 11.4 cluster to another Linux host, but empty?