Re: Move datapath

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: pgsql-admin@xxxxxxxxxxxxxxxxxxxx
Subject: Re: Move datapath
From: Andreas Froede <pgsql@xxxxxxxxxxxxxxxxxxxxx>
Date: Mon, 20 Jan 2025 14:01:11 +0100
In-reply-to: <CAJk5AtY5Z4W3wbJjbaYDT_HsVaO8ZGAYpts66fepwMx_gMfiDw@mail.gmail.com>
References: <CAJk5AtaMf=i4mUnK5vA=mG2V+rdYjNaKUncuMaQDV6_W0fRG4A@mail.gmail.com> <CAGB=j7oSVSQZ+i2n5xMTbei3BiyytGdx+-6-Z269j-RX7ry5Pw@mail.gmail.com> <CAJk5AtY5Z4W3wbJjbaYDT_HsVaO8ZGAYpts66fepwMx_gMfiDw@mail.gmail.com>
User-agent: Mozilla Thunderbird

Hi

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



If you copy the datadir, you have probably moved the problem 1:1 to pg25.

You should use your daily backup from pg24 or fix the issue in pg24.

What do your logs say about the problem on pg24?



CIAO
andreas

References:
- Move datapath
  - From: Rajesh Kumar
- Re: Move datapath
  - From: Mohit Mishra
- Re: Move datapath
  - From: Rajesh Kumar

Prev by Date: Re: Commit with wait event on advisory lock!
Next by Date: High Disk Utilization Due to Query on Large Table
Previous by thread: Re: Move datapath
Next by thread: vacuuming taking long time for pg_attribute
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Home] [Postgresql General] [Postgresql Performance] [Postgresql PHP] [Postgresql Jobs] [PHP Users] [PHP Databases] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Databases] [Yosemite Forum]

Powered by Linux