<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http://www.w3.org/TR/REC-html40" xmlns:ns13="urn:schemas-microsoft-com:office:smarttags">
<head>
<!-- Template generated by Exclaimer Mail Disclaimers on 04:28:51 Thursday, 22 September 2011 -->
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<style type="text/css">P.33cb67cd-47c7-4452-ac5f-290b0a7e977f {
MARGIN: 0cm 0cm 0pt
}
LI.33cb67cd-47c7-4452-ac5f-290b0a7e977f {
MARGIN: 0cm 0cm 0pt
}
DIV.33cb67cd-47c7-4452-ac5f-290b0a7e977f {
MARGIN: 0cm 0cm 0pt
}
TABLE.33cb67cd-47c7-4452-ac5f-290b0a7e977fTable {
MARGIN: 0cm 0cm 0pt
}
DIV.Section1 {
page: Section1
}
</style>
<meta name="Generator" content="Microsoft Word 11 (filtered medium)">
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang="EN-US" link="blue" vlink="purple">
<p class="33cb67cd-47c7-4452-ac5f-290b0a7e977f"></p>
<div class="Section1">
<p class="MsoNormal"><font size="2" face="Arial"><span style="font-size:10.0pt;
font-family:Arial">We had setup a couple of installs last year but never setup backup jobs for them.<o:p></o:p></span></font></p>
<p class="MsoNormal"><font size="2" face="Arial"><span style="font-size:10.0pt;
font-family:Arial"><o:p> </o:p></span></font></p>
<p class="MsoNormal"><font size="2" face="Arial"><span style="font-size:10.0pt;
font-family:Arial">Does postgresql have a hot backup mode similar to Oracles wherein one can backup files while the DB is still running? (In Oracle this means transactions are
being logged rather than committed and then get committed after it is taken out of hot backup mode.)
<o:p></o:p></span></font></p>
<p class="MsoNormal"><font size="2" face="Arial"><span style="font-size:10.0pt;
font-family:Arial"><o:p> </o:p></span></font></p>
<p class="MsoNormal"><font size="2" face="Arial"><span style="font-size:10.0pt;
font-family:Arial">If not how are people doing backups of their postgresql databases? Shutting it down completely and backing up the filesystem? Data dumps and backing up the
dumps? Something similar to Oracle RMAN? <o:p></o:p></span></font></p>
<p class="MsoNormal"><font size="2" face="Arial"><span style="font-size:10.0pt;
font-family:Arial"><o:p> </o:p></span></font></p>
<ns13:PersonName w:insAuthor="Jeff Lightner" w:insDate="2011-09-22T16:23:00Z" w:endInsAuthor="Jeff Lightner" w:endInsDate="2011-09-22T16:23:00Z">
<p class="MsoNormal"><font size="2" face="Arial"><span style="font-size:10.0pt;
font-family:Arial"> <u2:p></u2:p></span></font><o:p></o:p></p>
</ns13:PersonName>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:
12.0pt"><o:p> </o:p></span></font></p>
</div>
<p></p>
<p class="33cb67cd-47c7-4452-ac5f-290b0a7e977f"> </p>
<p class="33cb67cd-47c7-4452-ac5f-290b0a7e977f"> </p>
<p class="33cb67cd-47c7-4452-ac5f-290b0a7e977f"></p>
<p class="33cb67cd-47c7-4452-ac5f-290b0a7e977f"> </p>
<p class="33cb67cd-47c7-4452-ac5f-290b0a7e977f"> </p>
<p class="33cb67cd-47c7-4452-ac5f-290b0a7e977f"> </p>
<p style="MARGIN: 0in 0in 0pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal">
<span style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">Proud partner. Susan G. Komen for the Cure.</span></p>
<p style="MARGIN: 0in 0in 0pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal">
<span style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"><o:p></o:p></span> </p>
<p style="MARGIN: 0in 0in 0pt" class="MsoNormal"> <i><span style="FONT-FAMILY: Arial; COLOR: green; FONT-SIZE: 7.5pt; mso-bidi-font-size: 12.0pt">Please consider our environment before printing this e-mail or attachments.</span></i>
</p>
<p style="MARGIN: 0in 0in 0pt" class="MsoNormal"><span style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">----------------------------------<br>
CONFIDENTIALITY NOTICE: This e-mail may contain privileged or confidential information and is for the sole use of the intended recipient(s). If you are not the intended recipient, any disclosure, copying, distribution, or use of the contents of this information
is prohibited and may be unlawful. If you have received this electronic transmission in error, please reply immediately to the sender that you have received the message in error, and delete it. Thank you.<br>
----------------------------------</span><span style="FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt"><o:p></o:p></span></p>
<p> </p>
</body>
</html>