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

Поиск
Список
Период
Сортировка
От Matthias Apitz
Тема Re: How to move a 11.4 cluster to another Linux host, but empty?
Дата
Msg-id 20200502185823.GA3774@c720-r342378
обсуждение исходный текст
Ответ на Re: How to move a 11.4 cluster to another Linux host, but empty?  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы Re: How to move a 11.4 cluster to another Linux host, but empty?
Re: How to move a 11.4 cluster to another Linux host, but empty?
Список pgsql-general
El día sábado, mayo 02, 2020 a las 08:23:52a. m. -0700, Adrian Klaver escribió:

> On 5/2/20 8:02 AM, Paul Förster wrote:
> > Hi Adrian,
> > 
> >> On 02. May, 2020, at 16:59, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
> >> 2) To create a new base/ you will need to initdb data/ and that is not possible as initdb will not work on a
populateddata/.
 
> > 
> > you do the initdb and then copy the *.conf files from the tar over the newly created ones. After that, launch the
cluster.
> 
> Yeah I know, I do that on a fairly regular basis. The intent was to let 
> the OP know that ripping base/ out of cluster and transplanting a new 
> one in is not possible.

OK, lesson learned: Next time I will do a tar backup of PGDATA after
the configuration of the cluster and before creating any database in it.

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 по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: Checking for Presence of Required Libraries Fails duringPostgreSQL Upgrade
Следующее
От: Paul Förster
Дата:
Сообщение: Re: How to move a 11.4 cluster to another Linux host, but empty?