[ale] Speaking of Postgresql...

[planas]

Jeff

On Thu, 2011-09-22 at 20:56 +0000, Lightner, Jeff wrote: 

> Initial searching found there is a project called pg-rman:
> 
> http://code.google.com/p/pg-rman/
> 
>  
> 
> Also I found a good page talking about various methods for backup:
> 
> http://www.postgresql.org/docs/8.4/static/backup.html
> 

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.

> 
> 
> Anyone using the above please let me know of any gotchas you’ve found.
> Anyone using a different methodology don’t hesitate to share.
> 
>  
> 
> 
>                                    
> ______________________________________________________________________
> 
> From: ale-bounces at ale.org [mailto:ale-bounces at ale.org] On Behalf Of
> Lightner, Jeff
> Sent: Thursday, September 22, 2011 4:29 PM
> To: Atlanta Linux Enthusiasts
> Subject: [ale] Speaking of Postgresql...
> 
> 
>  
> 
> We had setup a couple of installs last year but never setup backup
> jobs for them.
> 
>  
> 
> 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.)  
> 
>  
> 
> 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?  
> 
>  
> 
>   
> 
>  
> 
>  
> 
>  
> 
>  
> 
>  
> 
>  
> 
> Proud partner. Susan G. Komen for the Cure.
> 
>  
> 
>  Please consider our environment before printing this e-mail or
> attachments. 
> 
> ----------------------------------
> 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.
> ----------------------------------
> 
>  
> 
> 
> 
> _______________________________________________
> Ale mailing list
> Ale at ale.org
> http://mail.ale.org/mailman/listinfo/ale
> See JOBS, ANNOUNCE and SCHOOLS lists at
> http://mail.ale.org/mailman/listinfo



-- 
Jay Lozier
jslozier at gmail.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.ale.org/pipermail/ale/attachments/20110922/1097777f/attachment.html