[GENERAL] How to reduce WAL files in Point in time recovery

Hi, I have setup PITR in PostgreSQL. I am taking base backup at every specific interval and also kept WAL files of size 16 MB each. Now the situation is that even there is no any major change in database, it suddenly started creating too many WAL files. I have gathered statistics with c

[GENERAL] Major Version Upgradation from 9.4 to 9.6 in Replication Environment

[Quipment Logo] Hello, We have a windows setup where we have 2 node primary-slave setup which comprises Async Replication + Log Shipping on slave. Now we want to upgrade it from 9.4 to 9.6 version. Do we need to upgrade slave to 9.6, upgrade master to 9.6 and setup replication again from scra

[GENERAL] Major Version Upgradation from 9.4 to 9.6

[Quipment Logo] Hello, We have a windows setup for PostgreSQL(Version 9.4). Now we are upgrading Major version 9.4 to 9.6. Total Database size - 421 GB RAM - 16 GB Core - 8 Size of Data Directory Drive - 500 GB We have 3 database in 421 GB. 1)X database size - 12 GB 2)Y database siz