| From: | Matthias Apitz <guru(at)unixarea(dot)de> |
|---|---|
| To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
| Cc: | Paul Förster <paul(dot)foerster(at)gmail(dot)com>, Matthias Apitz <guru(at)unixarea(dot)de>, 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 18:58:23 |
| Message-ID: | 20200502185823.GA3774@c720-r342378 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(dot)klaver(at)aklaver(dot)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 populated data/.
> >
> > 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(at)unixarea(dot)de, http://www.unixarea.de/ +49-176-38902045
Public GnuPG key: http://www.unixarea.de/key.pub
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Paul Förster | 2020-05-02 19:10:06 | Re: How to move a 11.4 cluster to another Linux host, but empty? |
| Previous Message | David G. Johnston | 2020-05-02 17:06:22 | Re: Checking for Presence of Required Libraries Fails during PostgreSQL Upgrade |