[ale] Speaking of Postgresql...

[Lightner, Jeff]

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

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.
----------------------------------


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.ale.org/pipermail/ale/attachments/20110922/45b5810b/attachment-0001.html