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

16 Dec 2024 15:35

...because that's one of the HA solutions that EDB has helped customers to set up?

PostgreSQL

16 Dec 2024 14:43

Well, I know if ur have skilled Engineers to setup the environment for you, then yeah u don't need EDB.
But my question is more in technical level, why still some companies prefer Patroni to EDB, and both they have support and also skilled engineers?

Which is better, and has more to offer?

PostgreSQL

16 Dec 2024 14:23

Just a random question, why I have seen couples of companies still use Patroni in their HA, even though they have support from EDB?

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

PostgreSQL

16 Dec 2024 14:59

Aurora or Neon serverless is better.

PostgreSQL

16 Dec 2024 14:39

Patroni is free open source HA solution. Comparing with EDB is like apples to oranges. Besides if company can recruit skilled postgres dba why would they pay to third party?

PostgreSQL

16 Dec 2024 11:55

sudo apt install postgresql-common
sudo bash /usr/share/postgresql-common/pgdg/apt.postgresql.org.sh
sudo apt update
sudo apt upgrade # will probably refresh some packages
sudo apt install postgresql-17 # or whichever release you want