he 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
> Cc: Dylan Luong ; pgsql-general@lists.postgresql.org
> Subject: Re: Performance issues during backup
>
> What about sen
Benavides [mailto:rene.romer...@gmail.com]
Sent: Wednesday, 21 February 2018 1:37 AM
To: Laurenz Albe
Cc: Dylan Luong ; pgsql-general@lists.postgresql.org
Subject: Re: Performance issues during backup
What about sending the backup to a different server? through ssh / rsync or
something, that
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 -c
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 script that basically puts
Dylan Luong 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 -c "SELECT pg_start_backup('${DATE}');"
>
