<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/3.32.2">
</HEAD>
<BODY LINK="#0000ff">
Jeff<BR>
<BR>
On Thu, 2011-09-22 at 20:56 +0000, Lightner, Jeff wrote: <BR>
<BLOCKQUOTE TYPE=CITE>
<FONT SIZE="2"><FONT COLOR="#000080">Initial searching found there is a project called pg-rman:</FONT></FONT><BR>
<BR>
<FONT SIZE="2"><FONT COLOR="#000080">http://code.google.com/p/pg-rman/</FONT></FONT><BR>
<BR>
<FONT SIZE="2"><FONT COLOR="#000080"> </FONT></FONT><BR>
<BR>
<FONT SIZE="2"><FONT COLOR="#000080">Also I found a good page talking about various methods for backup:</FONT></FONT><BR>
<BR>
<FONT SIZE="2"><FONT COLOR="#000080">http://www.postgresql.org/docs/8.4/static/backup.html</FONT></FONT><BR>
<BR>
</BLOCKQUOTE>
You might check general user list archives or the forums at postgresql.org. Some tools might be available at pgfoundry. I looked through my emails from the general list and did not see anything the seemed to fit.<BR>
<BLOCKQUOTE TYPE=CITE>
<BR>
<BR>
<FONT SIZE="2"><FONT COLOR="#000080">Anyone using the above please let me know of any gotchas you’ve found. Anyone using a different methodology don’t hesitate to share.</FONT></FONT><BR>
<BR>
<FONT SIZE="2"><FONT COLOR="#000080"> </FONT></FONT><BR>
<BR>
</BLOCKQUOTE>
<BLOCKQUOTE TYPE=CITE>
<DIV ALIGN=center>
<HR ALIGN="center">
</DIV>
</BLOCKQUOTE>
<BLOCKQUOTE TYPE=CITE>
<B><FONT SIZE="2">From:</FONT></B><FONT SIZE="2"> ale-bounces@ale.org [mailto:ale-bounces@ale.org] </FONT><B><FONT SIZE="2">On Behalf Of </FONT></B><FONT SIZE="2">Lightner, Jeff</FONT><BR>
<B><FONT SIZE="2">Sent:</FONT></B><FONT SIZE="2"> Thursday, September 22, 2011 4:29 PM</FONT><BR>
<B><FONT SIZE="2">To:</FONT></B><FONT SIZE="2"> Atlanta Linux Enthusiasts</FONT><BR>
<B><FONT SIZE="2">Subject:</FONT></B><FONT SIZE="2"> [ale] Speaking of Postgresql...</FONT><BR>
<BR>
<BR>
<BR>
<BR>
<FONT SIZE="2">We had setup a couple of installs last year but never setup backup jobs for them.</FONT><BR>
<BR>
<FONT SIZE="2"> </FONT><BR>
<BR>
<FONT SIZE="2">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.) </FONT><BR>
<BR>
<FONT SIZE="2"> </FONT><BR>
<BR>
<FONT SIZE="2">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? </FONT><BR>
<BR>
<FONT SIZE="2"> </FONT><BR>
<BR>
<FONT SIZE="2"> </FONT><BR>
<BR>
<BR>
<BR>
<BR>
<BR>
<BR>
<BR>
<BR>
<BR>
<BR>
<BR>
<BR>
<BR>
<FONT SIZE="2">Proud partner. Susan G. Komen for the Cure.</FONT><BR>
<BR>
<BR>
<BR>
<I><FONT SIZE="1"><FONT COLOR="#00ff00">Please consider our environment before printing this e-mail or attachments.</FONT></FONT></I> <BR>
<BR>
<FONT SIZE="2">----------------------------------</FONT><BR>
<FONT SIZE="2">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.</FONT><BR>
<FONT SIZE="2">----------------------------------</FONT><BR>
<BR>
<BR>
<BR>
<BR>
<PRE>
_______________________________________________
Ale mailing list
<A HREF="mailto:Ale@ale.org">Ale@ale.org</A>
<A HREF="http://mail.ale.org/mailman/listinfo/ale">http://mail.ale.org/mailman/listinfo/ale</A>
See JOBS, ANNOUNCE and SCHOOLS lists at
<A HREF="http://mail.ale.org/mailman/listinfo">http://mail.ale.org/mailman/listinfo</A>
</PRE>
</BLOCKQUOTE>
<BR>
<BR>
<TABLE CELLSPACING="0" CELLPADDING="0" WIDTH="100%">
<TR>
<TD>
-- <BR>
<FONT SIZE="4">Jay Lozier</FONT><BR>
<FONT SIZE="4">jslozier@gmail.com</FONT>
</TD>
</TR>
</TABLE>
</BODY>
</HTML>