[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-admin
Subject:    Re: Backups
From:       Aldo Sarmiento <aldo () bigpurpledot ! com>
Date:       2018-01-19 2:19:38
Message-ID: CAHX=r6yPw-AirfnRCMG=NrTyRM0O9_HHiSCYS9r_ZU+XNaX=hQ () mail ! gmail ! com
[Download RAW message or body]

I have had lots of success using streaming replication for potential
failover as well as read only hot stand by to assist with my master db.

Additionally we use pg backrest for PITR in the event that we need to roll
back for some unforeseen reason (hacking, corruption, etc).

*Aldo Sarmiento*
President & CTO



8687 Research Dr, Irvine, CA 92618
*O*: (949) 223-0900 - *F: *(949) 727-4265
aldo@bigpurpledot.com | www.bigpurpledot.com

On Thu, Jan 18, 2018 at 6:16 PM, Azimuddin Mohammed <azimeiu@gmail.com>
wrote:

> Hello admins,
> What is thr best backup strategy?
> I am planning to setup my pg cluster with streaming replication.
> My criteria
> 1. I should not be restarting my master server and slave.
> 2. Shiuld take a huge performace cpu or memory (Ram) consumption.
> 3. Compression is ok.
>

[Attachment #3 (text/html)]

<div dir="ltr">I have had lots of success using streaming replication for potential \
failover as well as read only hot stand by to assist with my master \
db.<div><br></div><div>Additionally we use pg backrest for PITR in the event that we \
need to roll back for some unforeseen reason (hacking, corruption, \
etc).</div></div><div class="gmail_extra"><br clear="all"><div><div \
class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div \
dir="ltr"><div><div dir="ltr"><div><font color="#000000" face="arial black, \
sans-serif" size="4"><b>Aldo Sarmiento</b></font><br><div><span \
style="font-size:14px"><font color="#000000">President &amp; \
CTO</font></span></div></div><p \
style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px"><img \
src="http://www.bigpurpledot.com/assets/search_engine/search-mod-logo.png" \
width="200" height="35" style="font-family:arial,helvetica,sans-serif"><br></p><p \
style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px"><br></p><div><font \
color="#000000" face="arial, helvetica, sans-serif">8687 Research Dr</font><span \
style="font-family:arial,helvetica,sans-serif"><font color="#000000">, Irvine, CA \
92618</font></span><br></div><div><b \
style="font-family:arial,helvetica,sans-serif"><font \
color="#000000">O</font></b><span \
style="font-family:arial,helvetica,sans-serif"><font color="#000000">:</font><font \
color="#500050">  </font><a value="+19492230900" style="color:rgb(17,85,204)">(949) \
223-0900</a><font color="#500050">  </font><font color="#000000">-  </font></span><b \
style="font-family:arial,helvetica,sans-serif"><font color="#000000">F: \
</font></b><span style="color:rgb(80,0,80);font-family:arial,helvetica,sans-serif"><a \
value="+19497274265" style="color:rgb(17,85,204)">(949) \
727-4265</a></span><br></div><div style="font-size:12.727272033691406px"><span \
style="font-size:small;font-family:arial,helvetica,sans-serif"><a \
href="mailto:aldo@bigpurpledot.com" \
target="_blank">aldo@bigpurpledot.com</a><span></span><span></span><a></a>  |  \
</span><a href="http://www.bigpurpledot.com/" \
style="font-size:small;font-family:arial,helvetica,sans-serif;color:rgb(17,85,204)" \
target="_blank">www.bigpurpledot.com</a></div></div></div></div></div></div></div></div>
 <br><div class="gmail_quote">On Thu, Jan 18, 2018 at 6:16 PM, Azimuddin Mohammed \
<span dir="ltr">&lt;<a href="mailto:azimeiu@gmail.com" \
target="_blank">azimeiu@gmail.com</a>&gt;</span> wrote:<br><blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"><div dir="auto">Hello admins,<div dir="auto">What is thr best \
backup strategy?</div><div dir="auto">I am planning to setup my pg cluster with \
streaming replication.</div><div dir="auto">My criteria  </div><div dir="auto">1. I \
should not be restarting my master server and slave.</div><div dir="auto">2. Shiuld \
take a huge performace cpu or memory (Ram) consumption.</div><div dir="auto">3. \
Compression is ok.</div></div> </blockquote></div><br></div>



[prev in list] [next in list] [prev in thread] [next in thread]