PostgreSQL

17 Dec 2024 13:42

https://postgresqlco.nf/doc/en/param/wal_keep_size/

PostgreSQL

17 Dec 2024 13:41

The archived WAL segments will be considered for deleting after two checkpoints. You can see where the archiver is currently working on by checking aforementioned view. *Did you?*

PostgreSQL

17 Dec 2024 13:41

It should decrease automatically, assuming postgresql believes that the wal has been archived and there is no pending replication slot

PostgreSQL

17 Dec 2024 13:38

So how can I reduce the space of pg_wall directory in master database? It is 539 GB space occupied

PostgreSQL

17 Dec 2024 13:35

And after archiving wal files to remote server , all 539 gb files will copy to remote server or only recent files?

PostgreSQL

17 Dec 2024 13:33

If it doesn't something is not setup correctly

PostgreSQL

17 Dec 2024 13:29

I have a question. In master server I established archive command to another remote server. pg_wal on master contains the 6 months old wal files till today's files and size of pg_wal is 539 GB. I have set max_wa_size 10 GB. My question is after archiving the files to remote server , would pg_wal directory space decreased or anything other I need to do?

PostgreSQL

17 Dec 2024 11:31

archive command is returning 0, and wal files successfully copied to remote location, but on source location copied wal files still did not removed?

PostgreSQL

17 Dec 2024 11:19

Old wal files are not removed if:
- the archive command is not returning status 0
- there is a standing replication slot without a connected server that has reported succesful wal replay

PostgreSQL

17 Dec 2024 11:12

So just curious about how wal files get archived and deleted in a replication setup. If anybody knows plz help

PostgreSQL

17 Dec 2024 11:09

archive command is not running properly if I set it, then will it delete old wal files?

PostgreSQL

17 Dec 2024 11:07

I have set archive_mode on and set archive_command and max_wal_size is 10 GB. But the size of pg_wal directory is 539 GB. How to handle this situation?

PostgreSQL

16 Dec 2024 20:54

Thank you. Anyway this doesn't work: bash: /usr/share/postgresql-common/pgdg/apt.postgresql.org.sh: No such file or directory - even if the dir exist

PostgreSQL

16 Dec 2024 20:49

this folder exist: /usr/share/postgresql-common/pgdg/

PostgreSQL

16 Dec 2024 20:41

You forgot the "bash" part...

PostgreSQL

17 Dec 2024 13:41

Then what is role of wal keep size

PostgreSQL

17 Dec 2024 13:41

Aka, as i said earlier:
- check that your archive command is returning status correctly
- check that you don't have any replication slots that have been left abandoned

PostgreSQL

17 Dec 2024 13:39

Sir how it will decrease automatically. Is there any specific parameter for this?

PostgreSQL

17 Dec 2024 13:36

The archiver will archive everything that hasn't been archived yet. Check pg_stat_archiver

PostgreSQL

17 Dec 2024 13:33

So would I need to set wal_keep_size value or not?

PostgreSQL

17 Dec 2024 13:32

Yes it should decrease automatically

PostgreSQL

17 Dec 2024 11:32

Check the second one

PostgreSQL

17 Dec 2024 11:19

Hello All,

In our environment, PostgreSQL is currently running on lower versions, ranging from 9 to 11. We are planning to upgrade to the latest version, and I have a few questions regarding the process.

What are the key considerations or checks we need to perform before the upgrade?

Can we directly upgrade from version 9 to 15, or is a step-by-step upgrade required?
How should we handle extensions during the upgrade process?

What challenges or issues should we anticipate during or after the upgrade?

If anyone with experience in upgrading Postgres, please share your guidance.

PostgreSQL

17 Dec 2024 11:17

Sir pls help. I have manually copied some wal files to a remote location and executed the checkpoint; but the copied wal files did not get deleted from pg_wal? Why Plz explain

PostgreSQL

17 Dec 2024 11:11

I have tested it by manually copying wal files to remote location and manually executed checkpoint; but old wal files did not removed

PostgreSQL

17 Dec 2024 11:07

Check that your archive command is returning properly.

PostgreSQL

16 Dec 2024 22:12

Mind running this:

dpkg -L postgresql-common | grep pgdg

PostgreSQL

16 Dec 2024 20:50

Please look up linux and command line basics

PostgreSQL

16 Dec 2024 20:43

bash: /usr/share/postgresql-common/pgdg/apt.postgresql.org.sh: No such file or directory

PostgreSQL

16 Dec 2024 20:40

sudo: /usr/share/postgresql-common/pgdg/apt.postgresql.org.sh: command not found