How to perform PITR when all of the logs won't fit on the drive

2018-03-01 Thread Tony Sullivan
Hello, I have a situation where something was deleted from a database that shouldn't have been so I am having to take a base backup and perform a point-in-time-recovery. The problem I have is that the decompressed WAL files will not fit on the drive of the machine I am trying to do the restore on.

Multiple PostgreSQL instances on one machine

2018-06-08 Thread Tony Sullivan
I am trying to consolidate some machines in my server room particularly in the testing environment and I was hoping someone could point me in the right direction. I currently have three machines running PostgreSQL for testing purposes. Each week a backup is made of the production database and this