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 .
>>
>
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. |