pgsql_tmp consuming most of the space.

Hi all, In one of our production environment.. pgsql_tmp is taking about half of the space in FS. And temp files are from Jan 2024. Our data fs is about to reach 98% percent.. Kindly suggest us what should be done to resolve this issue? pgsql_tmp contains temperorary files during sub query ex

Can we directly upgrade postgresql from 13 to 15.4

Hi all, Can we upgrade postresql from 13 to 15.4 directly? Can we upgrade postgresql from 13 to 16 directly? Ideally how many major version can we jump to from older version ? Regards, Jayeshthakare 8828986182 Postgresql dba | Clover Infotech

Pg_basebackup failed or completed?

Hi Team, We have got below error while doing basebackup pg_basebackup: could not close file "0002022E00027": No error Can we assume that backup is completed successfully? Regards, Jayeshthakare Postgresql DBA 8828986182