Re: Move datapath - Mailing list pgsql-admin

From Rajesh Kumar
Subject Re: Move datapath
Date
Msg-id CAJk5AtY5Z4W3wbJjbaYDT_HsVaO8ZGAYpts66fepwMx_gMfiDw@mail.gmail.com
Whole thread Raw
In response to Re: Move datapath  (Mohit Mishra <mohitmishra786687@gmail.com>)
Responses Re: Move datapath
List 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@gmail.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.dba09@gmail.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 .

pgsql-admin by date:

Previous
From: Alex Balashov
Date:
Subject: Re: Need an idea to operate massive delete operation on big size table.
Next
From: Rui DeSousa
Date:
Subject: Re: Need an idea to operate massive delete operation on big size table.