I tend to use the custom foment mentioned here <a href="http://www.postgresql.org/docs/8.4/interactive/backup-dump.html#BACKUP-DUMP-LARGE">http://www.postgresql.org/docs/8.4/interactive/backup-dump.html#BACKUP-DUMP-LARGE</a> but its not bad to do a dump all because the standard pg_dump does not back up the database user names and passwords in general though its a good idea to read the full doc <a href="http://www.postgresql.org/docs/8.4/interactive/backup.html">http://www.postgresql.org/docs/8.4/interactive/backup.html</a> so you can find the right solution for you. Also its important to read the documents for your version the links I included are for 8.4 but some of the options changed in 9.x such as the warm standby and the addition of the hot standby. I usually read the version with comments because there usually aren't too many if any and they tend to be helpful. Finally If your not too familiar with how PostgreSQL works I highly suggest you read about vacuuming and analyzing <a href="http://www.postgresql.org/docs/8.4/interactive/maintenance.html">http://www.postgresql.org/docs/8.4/interactive/maintenance.html</a> this section is critical for long term performance especially if you are using the monitoring. one thing to note while auto vacuum helps reduce how often you need to do some of these things its not a full replacement for scheduling the tasks manually especially if there a lot of constant table updates which is the case if you have the monitoring feature turned on. I usually do a nightly standard non blocking vacuum analyze nightly and a full vacuum analyze weakly and and reindex every couple of months for good measure. but you will need to tune that based on you're environment there is always a bit of trial and error invloved in getting it right. Im going to start putting the first presentation together over the next month or so. ive already got a location and an artist to help me make the slides more interesting. Im going to wait on scheduleing and sending out the announcement though I have every thing ready for the presentation. <div class="gmail_quote">On Tue, Sep 18, 2012 at 10:15 AM, Boyd, Robert <<a href="mailto:Robert.Boyd@peoplefluent.com" target="_blank">Robert.Boyd@peoplefluent.com</a>> wrote: <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"> <div link="blue" vlink="purple" lang="EN-US"><div>Thank you for your reply. The idea of a video of your lectures sounds perfect. You could post the handouts to a website and put a link in the description/comments posted with the video. So, in the pgsql documentation I will find clear easy to follow instructions on how to make regular backups of the spacewalk database? Thank you, Robert <div style="border:none;border-top:solid #b5c4df 1.0pt;padding:3.0pt 0in 0in 0in">From: <a href="mailto:spacewalk-list-bounces@redhat.com" target="_blank">spacewalk-list-bounces@redhat.com</a> [mailto:<a href="mailto:spacewalk-list-bounces@redhat.com" target="_blank">spacewalk-list-bounces@redhat.com</a>] On Behalf Of Paul Robert Marino Sent: Friday, September 14, 2012 4:06 PM To: <a href="mailto:spacewalk-list@redhat.com" target="_blank">spacewalk-list@redhat.com</a> Subject: Re: [Spacewalk-list] PostGreSQL Maintenance Guidelines for Spacewalk </div><div><div class="h5"> Well you can find that scattered all over the web but. The best place is postgresqls documentation its self. That being said I'm considering doing a series of lectures starting with initial basic configuration and maitnence then eventialy doing one on streaming replication, possibly even one covering some more advanced stuff like plsql and plperl. If I do would it be helpfull to video tape the lectures and put them on youtube or simmilar streaming video site. My only problem with youtube is I can't attache the handouts directly to the video which is the only reason I would consider putting it somwhere else. <div>On Sep 14, 2012 2:29 PM, "Boyd, Robert" <<a href="mailto:Robert.Boyd@peoplefluent.com" target="_blank">Robert.Boyd@peoplefluent.com</a>> wrote:<div><div> Since I’m not an experienced PostGreSQL admin, where can I find guidelines, scripts, etc for doing routine maintenance tasks like DB backups, storage tuning, etc like there is for the users who have Oracle as their back end? Robert Boyd Senior Systems Engineer Phone: <a href="tel:919-645-2972" target="_blank">919-645-2972</a>Mobile: <a href="tel:919-306-4681" target="_blank">919-306-4681</a> Peoplefluent 434 Fayetteville Street Raleigh, NC 27601 <a href="mailto:michael.dileonardo@peoplefluent.com" target="_blank">robert.boyd@peoplefluent.com</a> <table cellpadding="0" cellspacing="8" border="0"><tbody><tr><td style="padding:0in 0in 0in 0in"> <img src="cid:image001.png@01CD9586.910B0FF0" alt="Description: Description: Description: cid:image001.png@01CC344B.23823870" height="65" width="179" border="0"></td><td style="padding:0in 0in 0in 0in"> </td></tr></tbody></table>This email message is for the sole use of the intended recipient(s) and may contain confidential information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. </div></div> _______________________________________________ Spacewalk-list mailing list <a href="mailto:Spacewalk-list@redhat.com" target="_blank">Spacewalk-list@redhat.com</a> <a href="https://www.redhat.com/mailman/listinfo/spacewalk-list" target="_blank">https://www.redhat.com/mailman/listinfo/spacewalk-list</a></div></div></div></div></div> _______________________________________________ Spacewalk-list mailing list <a href="mailto:Spacewalk-list@redhat.com">Spacewalk-list@redhat.com</a> <a href="https://www.redhat.com/mailman/listinfo/spacewalk-list" target="_blank">https://www.redhat.com/mailman/listinfo/spacewalk-list</a> </blockquote></div>