Hello, Im encountering an issue with postgreSQL version 15 setup. The

Question

Hello, Im encountering an issue with postgreSQL version 15 setup. The

pg_wal directory on the secondary server is getting full, retaining WAL files from the past four months. However, on the primary server its fine, the pg_wal size is only 1.5GB, whereas the secondary has grown to 28GB.
I confirmed that the configuration parameters are identical on both servers, so Im unsure why this is happening only on the secondary.
Could you suggest anything on that?

#programming #russian

0

15.10.2024

7 ответов

2 просмотра

Jaisankar Автор вопроса

Stefanie Janine Stölting
Do you have a backup running against the secondary...

Yes

0

20 дней назад

Stefanie Janine Stölting

Jaisankar
Yes

Than that backup might have caused the WAL backlog. Which software is it?

0

20 дней назад

Jaisankar Автор вопроса

Stefanie Janine Stölting
Than that backup might have caused the WAL backlog...

It's taking by crontab

0

20 дней назад

Stefanie Janine Stölting

Jaisankar
It's taking by crontab

That's only executing the backup tool. Question is still which backup tool?

0

20 дней назад

Jaisankar Автор вопроса

Stefanie Janine Stölting
That's only executing the backup tool. Question is...

Pg_basebackup and pg_dump

0

20 дней назад

Stefanie Janine Stölting

Jaisankar
Pg_basebackup and pg_dump

Then it's probably a WAL lag of pg_basebackup. You need to take care of finishing the following of backups yourself, it is not managed. Think about using https://pgbackrest.org/, it will take of cleaning up itself as it stops following WAL automatically as configured.

0

20 дней назад

Stefanie Janine Stölting · Accepted Answer

Stefanie Janine Stölting

Do you have a backup running against the secondary?

0

20 дней назад

169 похожих чатов

Hello, Im encountering an issue with postgreSQL version 15 setup. The

7 ответов

Похожие вопросы