Do backups on slave. Is it OK?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: "pgsql-admin@xxxxxxxxxxxxxx" <pgsql-admin@xxxxxxxxxxxxxx>
Subject: Do backups on slave. Is it OK?
From: Artem Tomyuk <admin@xxxxxxxxxxxxxx>
Date: Wed, 17 May 2017 18:27:56 +0000
Arc-authentication-results: i=1; mx.google.com; dkim=fail header.i=@leboutique.com; spf=pass (google.com: best guess record for domain of pgsql-admin-owner+m46671=spinic=gmail.com@xxxxxxxxxxxxxx designates 2a02:16a8:dc51::56 as permitted sender) smtp.mailfrom=pgsql-admin-owner+M46671=spinic=gmail.com@xxxxxxxxxxxxxx; dmarc=fail (p=NONE sp=NONE dis=NONE) header.from=leboutique.com
Arc-message-signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20160816; h=sender:precedence:list-unsubscribe:list-subscribe:list-post :list-owner:list-id:list-help:list-archive:to:subject:message-id :date:from:mime-version:dkim-signature:arc-authentication-results; bh=ay3oeIyWcwTzNVupcc5RJTpQUkk/ILLYdk2Nlvy366A=; b=Zz3ijVA5KTk6KXoPQ45+al6P8GzAKIdY+BC9HOOiqMUTCYbWa6uAzWvHnZ5gjpFKe+ hrqBO0+UhfRqxsUjfeHCjKQJLz+piySRcK0OY+r6ZtvkOV9w9WmYInwYQIV6nMU0/FHl EtdWAIzAqGHl9gpL2SoGOYk6SpZ1O0H50YKYaBkoK+0ehJUwzhsOTsw7vL9GHm1d9AuI EfGmBLh6Xd2xuYcd3JnQFZLGtmCUx7+EUddzFoELuivKNGbUe0KDLT2DmcrHxRoS+PNA X0UbAU5zD75GerX5YRCqy+XXyLHR6QD10QkQOHhCkqaZ0zv/AHMFjxii+YRUO6zE76BW vg1Q==
Arc-seal: i=1; a=rsa-sha256; t=1495045729; cv=none; d=google.com; s=arc-20160816; b=NOEtlEYajJ1goEVFjqn7l7HPR+iJOSWa8ZWtwGaORMNN1iNJ9tZX5dtT3ndezbS+Et GqVx5I7DCvru/aE0LZAKPpiZu5xprPPNr1aSCUENWFRcbXLs6Rc6GRPtcNev/412yuvS zqQl/MvDzht/66GzjmPhXFwS0AoVag+iBFTnbLXr98NXPhkll/PVQSkQQGZJAB33rhaV awh015wjYw5ygKHwsb0Fax5x6l4s1O4YpqpLHY0vfv5yjTmY0FGO7Etuq0s+4OPbiV1R bcDYPpVXp0KFqjywcb0YZziY2orGPSOt+k/3/A7ptXEL01N/hjnRjkcUeCnaHTIK3nx3 6Yug==

Hi.

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

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

Thanks!

Follow-Ups:
- Re: Do backups on slave. Is it OK?
  - From: Stéphane KANSCHINE

Prev by Date: Fwd: issue 2017-01-09: Recycle(Delete) Applicationlog(Pgadmin4.log) after hitting certain MB
Next by Date: Re: Do backups on slave. Is it OK?
Previous by thread: Fwd: issue 2017-01-09: Recycle(Delete) Applicationlog(Pgadmin4.log) after hitting certain MB
Next by thread: Re: Do backups on slave. Is it OK?
Index(es):
- Date
- Thread

[Index of Archives] [KVM ARM] [KVM ia64] [KVM ppc] [Virtualization Tools] [Spice Development] [Libvirt] [Libvirt Users] [Linux USB Devel] [Linux Audio Users] [Yosemite Questions] [Linux Kernel] [Linux SCSI] [XFree86]