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

[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
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] Error while executing packages action: empty transaction [[6]]

[Milan Zazrivec]

> Hi,
> 
> I am new with Spacewalk. I have successfully set-up a spacewalk server
> running with Fedora 15 (Linux dunedin 2.6.43.8-1.fc15.i686.PAE #1 SMP Mon
> Jun 4 20:21:39 UTC 2012 i686 i686 i386 GNU/Linux) and a spacewalk client
> running with Fedora 14 (Linux spacewclient 2.6.35.6-45.fc14.i686 #1 SMP Mon
> Oct 18 23:56:17 UTC 2010 i686 i686 i386 GNU/Linux). When I tried to do
> package upgrade installation on the client it failed with the following
> error details.
> 
> This action will be executed after 09/17/12 6:27:26 PM HKT.
> 
> This action's status is: Failed.
> The client picked up this action on 09/17/12 9:42:24 PM HKT.
> The client completed this action on 09/17/12 9:42:25 PM HKT.
> Client execution returned *"Error while executing packages action: empty
> transaction [[6]]" (code -1)*
> Packages Scheduled:
> 
> Can you help me check what would be the problem. Thanks!

Try

yum clean all

on the client and repeat.

Regards
-Milan Zázrivec

___
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list