Re: Full backup failed

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


You can do one thing delete the stanza and re create it , it will work .

On Mon, Feb 19, 2024, 1:14 PM Rajesh Kumar <rajeshkumar.dba09@xxxxxxxxx> wrote:
Archive command is set to pgbackrest --stanza=db archive-push "%p"

There were no such issue since last year.

In postgres logs, don't see anything related to archive. But I see, WARNING,0100, aborting backup due to backend exiting before pg_backup_stop was called....pgbackrest[backup] client backend, 58568621736954596

On Mon, 19 Feb 2024, 12:53 Laurenz Albe, <laurenz.albe@xxxxxxxxxxx> wrote:
On Mon, 2024-02-19 at 09:35 +0530, Rajesh Kumar wrote:
> 6time="2024-02-18T18:26:59Z" level=info msg="stderr=[ERROR: [082]: WAL segment 0000003F0000050A0000000C was not archived before the 60000ms timeout\n HINT: check the archive_command to ensure that all options are correct (especially --stanza).\n HINT: check the PostgreSQL server log for errors.\n HINT: run the 'start' command if the stanza was previously stopped.\n]"

Look into the PostgreSQL log for messages from the "archive_comand".

Laurenz Albe

[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