Re: Upgrading PG11 to PG17 without dump/restore

2025-05-01 Thread Ron Johnson
On Thu, May 1, 2025 at 9:06 AM Durumdara wrote: > Hello! > > There is a heavily used server, with older debian, and PG11. > The data is more than 1,2 TB. > The PG_Upgrade is not possible because of lesser space and too old debian. > > As we see now we have only one way to move this server. > 1.)

Pgbackrest : Resumable backup of same type exists

2025-05-01 Thread KK CHN
Hi, Due to a backup failure in my Reposerver, the storage disk ran out of space, fixed later. I reschedule the cron job to take a full backup but it show for the last 3 hours 025-05-01 09:30:16.377 P00 WARN: resumable backup 20250425-115723F of same type exists -- invalid files will be removed

Re: Upgrading PG11 to PG17 without dump/restore

2025-05-01 Thread Adrian Klaver
On 5/1/25 06:06, Durumdara wrote: Hello! There is a heavily used server, with older debian, and PG11. The data is more than 1,2 TB. The PG_Upgrade is not possible because of lesser space and too old debian. 1) Specify what the old and new versions of Debian are. 2) I don't understand what the

Upgrading PG11 to PG17 without dump/restore

2025-05-01 Thread Durumdara
Hello! There is a heavily used server, with older debian, and PG11. The data is more than 1,2 TB. The PG_Upgrade is not possible because of lesser space and too old debian. As we see now we have only one way to move this server. 1.) Installing a new server with actual debian. 2.) Installing the n

Re: Pgbackrest : Resumable backup of same type exists

2025-05-01 Thread Abdul Sayeed
Hello, This warning message indicates that a *resumable backup*, labeled 20250425-115723F, already exists from a previous attempt. The backup system has detected it and will do the following: - *Remove any invalid or corrupted files* from that existing backup attempt. - *Resume*

Re: Pgbackrest : Resumable backup of same type exists

2025-05-01 Thread Greg Sabino Mullane
On Thu, May 1, 2025 at 9:08 AM Abdul Sayeed wrote: > Hello, > > This warning message indicates that a *resumable backup*, > (plus lots more ChatGPT crap) Please do not use LLMs to answer questions here. If the original poster wanted that, they could have done it themselves. Further, you are poll

Is anyone up for hosting the online PG game "Schemaverse"?

2025-05-01 Thread Justin Clift
Hi all, The PostgreSQL game "Schemaverse" was removed from the PostgreSQL website's links a few months ago because it no longer had hosting. Does anyone around have spare server/vm/something that could be used to host it (for free)? Details in the forwarded message below. :) Regards and best

Re: Upgrading PG11 to PG17 without dump/restore

2025-05-01 Thread Justin Clift
On 2025-05-01 23:06, Durumdara wrote: The PG_Upgrade is not possible because of lesser space and too old debian. As a data point, pg_upgrade has an option to do an in-place upgrade which reuses the vast majority of the data files as they are on disk, rather than making a copy. It's useful

Re: Pgbackrest : Resumable backup of same type exists

2025-05-01 Thread Abdul Sayeed
Hi Greg, My apologies but the above answer which i gave was not from chatgpt, I had face similar situation in one of our env. Deleting failed backup helped me. To be honest I did use chathpt to paraphrase my sentences before posting in general mail list. Thanks & Regards, Abdul Sayeed On Thu,

Re: Pgbackrest : Resumable backup of same type exists

2025-05-01 Thread KK CHN
Thanks for the helpful hints. The backup finished successfully : 20250425-115723F timestamp start/stop: 2025-05-01 09:31:36+05:30 / 2025-05-01 14:13:08+ The log doesn't show anything other than (025-05-01 09:30:16.377 P00 WARN: resumable backup 20250425-115723F of same type exists -