Re: Move datapath

Поиск
Список
Период
Сортировка
От Rajesh Kumar
Тема Re: Move datapath
Дата
Msg-id CAJk5AtY5Z4W3wbJjbaYDT_HsVaO8ZGAYpts66fepwMx_gMfiDw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Move datapath  (Mohit Mishra <mohitmishra786687@gmail.com>)
Ответы Re: Move datapath
Список 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 по дате отправления: