[Spacewalk-list] PostGreSQL Maintenance Guidelines for Spacewalk

[Paul Robert Marino]

I tend to use the custom foment mentioned here
http://www.postgresql.org/docs/8.4/interactive/backup-dump.html#BACKUP-DUMP-LARGE
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
http://www.postgresql.org/docs/8.4/interactive/backup.html 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
http://www.postgresql.org/docs/8.4/interactive/maintenance.html 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.


On Tue, Sep 18, 2012 at 10:15 AM, Boyd, Robert <Robert.Boyd at peoplefluent.com
> wrote:

> 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****
>
> ** **
>
> *From:* spacewalk-list-bounces at redhat.com [mailto:
> spacewalk-list-bounces at redhat.com] *On Behalf Of *Paul Robert Marino
> *Sent:* Friday, September 14, 2012 4:06 PM
> *To:* spacewalk-list at redhat.com
> *Subject:* Re: [Spacewalk-list] PostGreSQL Maintenance Guidelines for
> Spacewalk****
>
> ** **
>
> 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.****
>
> On Sep 14, 2012 2:29 PM, "Boyd, Robert" <Robert.Boyd at peoplefluent.com>
> wrote:****
>
> 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: 919-645-2972****
>
> Mobile: 919-306-4681****
>
> Peoplefluent****
>
> 434 Fayetteville Street ****
>
> Raleigh, NC  27601****
>
>
> robert.boyd at peoplefluent.com <michael.dileonardo at peoplefluent.com>****
>
>  ****
>
> [image: Description: Description: Description:
> cid:image001.png at 01CC344B.23823870]****
>
>  ****
>
> 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.****
>
>  ****
>
>
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list****
>
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20120918/e72b3923/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 4488 bytes
Desc: not available
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20120918/e72b3923/attachment.png>