Re: Move datapath

From: Rajesh Kumar <rajeshkumar(dot)dba09(at)gmail(dot)com>
To: Mohit Mishra <mohitmishra786687(at)gmail(dot)com>
Cc: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Move datapath
Date: 2025-01-15 23:00:47
Message-ID: CAJk5AtY5Z4W3wbJjbaYDT_HsVaO8ZGAYpts66fepwMx_gMfiDw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi Mohit, pg24 seems to be crashed and could not connect to take back up
and all.

Also I understand it care about datadir only. But at this point, what's the
best possible way to solve this?

The old data is in /data/pg24 , can I load this in /data/pg25 and need to
reinitialize the wal db checkpoint

On Thu, 16 Jan 2025, 01:04 Mohit Mishra, <mohitmishra786687(at)gmail(dot)com>
wrote:

> Hello Rajesh,
>
> did you try doing backup from pg24 and then restoring it in pg25 ---> you
> can use pg_dum or pg_restore
>
> Regards,
>
> Mohit
>
> On Thu, 16 Jan 2025, 00:55 Rajesh Kumar, <rajeshkumar(dot)dba09(at)gmail(dot)com>
> wrote:
>
>> Hi all,
>>
>> I have a postgres database 15.3 that ran on kubernetes and the pod had
>> crashbackloop error.
>>
>> And devops looks like created another datapath and now pod is running.
>>
>> Now when connect to terminal of that pod I could see two folders 1.
>> Postgresql-24 (old data path that has data and looks like not running ) 2.
>> Postgresql-25 (new data path which seems to be running currently)
>>
>> Now I want to have data in postgresql-25. How do I get it from
>> postgresql-24? Kindly help me .
>>
>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Rui DeSousa 2025-01-16 00:06:59 Re: Need an idea to operate massive delete operation on big size table.
Previous Message Alex Balashov 2025-01-15 21:24:53 Re: Need an idea to operate massive delete operation on big size table.