Backups over slave instead master?

From: Edson Richter <edsonrichter(at)hotmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Backups over slave instead master?
Date: 2014-05-01 15:31:17
Message-ID: BLU0-SMTP535E6778CEE22323BE6D51CF400@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I've a basic setup with async replication between two distant,
geographically separated servers over vpn.
Replication happens every 0.5 seconds or so, and is incredible reliable.
Today, I've been using backup on master server every twelve hours.
I'm wondering if would be possible to execute these backups in the slave
server instead, so I can avoid the overhead of backups on master system?

Thanks,

Edson

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Shaun Thomas 2014-05-01 15:54:46 Re: Backups over slave instead master?
Previous Message Hengky Liwandouw 2014-05-01 15:04:02 Re: Return and sql tuple descriptions are incompatible