You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
@ChakshuGautam, I would like your input on this suggestion. My suggestion is to use pgBarman (https://pgbarman.org/) in a separate container alongside our PostgreSQL installation. It enables Point-in-Time Recovery (PITR) for efficient data restoration during emergencies. Do you think this solution meets our requirements?
@PiyushRaj927 This is exactly what I was looking for. We have used Barman before and it works as expected. The wal logs are a bit too much in size so look for compression.
PGSQL has built-in support for compressing WAL.
We can control this using the wal_compression configuration parameter in the postgresql.conf file. When this parameter is set to on, PostgreSQL will try to compress WAL data when a full page image is written to the WAL. This can significantly reduce the amount of WAL data.
Activity
PiyushRaj927 commentedon May 29, 2023
Hi @ChakshuGautam, could you please provide more information on this issue? Thank you!
nitishmalang commentedon May 29, 2023
yes @ChakshuGautam please
PiyushRaj927 commentedon Jun 5, 2023
@ChakshuGautam, I would like your input on this suggestion. My suggestion is to use pgBarman (https://pgbarman.org/) in a separate container alongside our PostgreSQL installation. It enables Point-in-Time Recovery (PITR) for efficient data restoration during emergencies. Do you think this solution meets our requirements?
cc: @jayanth-kumar-morem @singhalkarun
ChakshuGautam commentedon Jun 5, 2023
@PiyushRaj927 This is exactly what I was looking for. We have used Barman before and it works as expected. The wal logs are a bit too much in size so look for compression.
jayanth-kumar-morem commentedon Jun 19, 2023
Hey @ChakshuGautam ,
PGSQL has built-in support for compressing WAL.
We can control this using the
wal_compressionconfiguration parameter in thepostgresql.conffile. When this parameter is set toon, PostgreSQL will try to compress WAL data when a full page image is written to the WAL. This can significantly reduce the amount of WAL data.jayanth-kumar-morem commentedon Jun 19, 2023
@PiyushRaj927 Have you started working on this? If not I can take this one up.
PiyushRaj927 commentedon Jun 19, 2023
No @jayanth-kumar-morem, I have not started working on the issue.
jayanth-kumar-morem commentedon Jun 19, 2023
Alright, I'll get on this