Re: WAL Archive Cleanup?

QBR On Mon, Mar 25, 2019 at 10:21 AM Foo Bar wrote: > Hello All, > > Wow! Lots of awesome replies, Went away for the weekend thinking my email > had been rejected and come back to a full inbox. Thanks for all the help! > > >> Postgres version? > > 9.6.11 >

Re: WAL Archive Cleanup?

ly like to be able to support is to give developers a replica of the production database, which this seems like it might not be the ideal way to go for that?) Thanks! - QBR On Mon, Apr 1, 2019 at 10:24 AM Foo Bar wrote: > Hello All, > > Ok, so maybe something helpful? On my master

Re: WAL Archive Cleanup?

the above cluster, run `pg_archivecleanup /pgbackup/archive $(find /pgbackup/base_backup/ -name '*.backup')` (i.e. "find the .backup file from `base_backup/` and remove any archive files?) Then I effectively have a place to do point-in-time restores from? Thanks, - QBR On Mo

Re: WAL Archive Cleanup?

Hello All, Wow! Lots of awesome replies, Went away for the weekend thinking my email had been rejected and come back to a full inbox. Thanks for all the help! >> Postgres version? 9.6.11 Doh. Fairly important detail there. :) >> FYI, psql is the Postgres client program, Postgres(ql) is the

WAL Archive Cleanup?

Hello, We're evaluating PostgreSQL for use with Artifactory in our environment. PostgreSQL seems like the obvious choice because it provides hot-standby replication. I've followed several guides I've found by googling "postgres replication how to" (i.e.: this one from DigitalOcean