On 5/2/20 11:58 AM, Matthias Apitz wrote:
> 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.
As Paul said this is probably more then you want to do. If for no other
reason then that the env(in particular locale) where you untar the
PGDATA may be different from where you tar(ed) it. This will leave you
with cluster that is out of sync with its environment.
>
> Thanks
>
> matthias
>
--
Adrian Klaver
adrian.klaver@aklaver.com