Re: Performance issues during backup

saturating the write capacity of your disks. > From: Rene Romero Benavides [mailto:rene.romer...@gmail.com] > Sent: Wednesday, 21 February 2018 1:37 AM > To: Laurenz Albe <laurenz.a...@cybertec.at> > Cc: Dylan Luong <dylan.lu...@unisa.edu.au>; pgsql-general@lists.postgresql

RE: Performance issues during backup

Benavides [mailto:rene.romer...@gmail.com] Sent: Wednesday, 21 February 2018 1:37 AM To: Laurenz Albe <laurenz.a...@cybertec.at> Cc: Dylan Luong <dylan.lu...@unisa.edu.au>; pgsql-general@lists.postgresql.org Subject: Re: Performance issues during backup What about sending the backup to

Re: Performance issues during backup

Greetings, * Dylan Luong (dylan.lu...@unisa.edu.au) wrote: > We perform nighty base backup of our production PostgreSQL instance. We have > a script that basically puts the instance into back mode and then backs up > (tar) the /Data directory and then takes it out of backup mode. > Ie, > psql

Re: Performance issues during backup

What about sending the backup to a different server? through ssh / rsync or something, that would save lots of IO activity 2018-02-20 2:02 GMT-06:00 Laurenz Albe : > Dylan Luong wrote: > > We perform nighty base backup of our production PostgreSQL instance. We > have a