Re: Do backups on slave. Is it OK?

From: Stéphane KANSCHINE <stephane(at)hexack(dot)fr>
To: Artem Tomyuk <admin(at)leboutique(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Do backups on slave. Is it OK?
Date: 2017-05-18 04:30:35
Message-ID: 20170518043035.r6r2a22y3kxjfp27@office.hexack.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Le mer. 17 mai, vers 18:27, Artem Tomyuk exprimait :

> Hi.

Hey !

> In my setup i currently have standard streaming replication. Currently all
> backups are done from master.

Standard means synchrone, asynchrone ? Is your secondary open to
SELECT ?

> Is it correct to schedule nightly backups only from slave, i want my master
> to be 24/7 accessible for clients?

You can do your backup while your primary cluster is up.

Regards,
--
Stéphane KANSCHINE - http://www.hexack.fr./ - http://www.nuajik.com./
＠ stephane(at)hexack(dot)fr
 +33 6 64 31 72 52

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message YangBy 2017-05-18 05:38:39 Recovey on Master / Primary Server
Previous Message Artem Tomyuk 2017-05-17 18:27:56 Do backups on slave. Is it OK?