Re: [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  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-boun...@redhat.com [mailto:
> spacewalk-list-boun...@redhat.com] *On Behalf Of *Paul Robert Marino
> *Sent:* Friday, September 14, 2012 4:06 PM
> *To:* spacewalk-list@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" 
> 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.b...@peoplefluent.com 
>
>  
>
> [image: Description: Description: Description:
> cid:image001.png@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@redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list
>
> ___
> Spacewalk-list mailing list
> Spacewalk-list@redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list
>
<>___
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list

Re: [Spacewalk-list] PostGreSQL Maintenance Guidelines for Spacewalk

[Boyd, Robert]

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-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Paul Robert Marino
Sent: Friday, September 14, 2012 4:06 PM
To: spacewalk-list@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" 
mailto:robert.b...@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.b...@peoplefluent.com<mailto:michael.dileona...@peoplefluent.com>

[cid:image001.png@01CD9586.910B0FF0]



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@redhat.com<mailto:Spacewalk-list@redhat.com>
https://www.redhat.com/mailman/listinfo/spacewalk-list
<>___
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list

Re: [Spacewalk-list] PostGreSQL Maintenance Guidelines for Spacewalk

[Musayev, Ilya]

I'm with you, we (spacewalk community) definitely need something like that out 
there.


I was thinking of doing it aswell so I can educate admins in house, but why not 
share with the rest of the world :)

I can help with what I can.

Don't know if RedHat folks will like it, as I'm going to explain how to make 
RHEL works with Spacewalk.

If there are more volunteers, we can devide and conquer, if you want to do this 
by yourself - more power to you:)

On Sep 14, 2012, at 4:15 PM, "Paul Robert Marino" 
mailto:prmari...@gmail.com>> wrote:


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.b...@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.b...@peoplefluent.com





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@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list
___
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list
___
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list

Re: [Spacewalk-list] PostGreSQL Maintenance Guidelines for Spacewalk

[Paul Robert Marino]

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" 
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.b...@peoplefluent.com 
>
> ** **
>
> [image: Description: Description: Description:
> cid:image001.png@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@redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list
>
<>___
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list

[Spacewalk-list] PostGreSQL Maintenance Guidelines for Spacewalk

[Boyd, Robert]

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.b...@peoplefluent.com

[cid:image001.png@01CD9284.B2D69C80]



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@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list