<div dir="ltr">Hello Matt<div><br></div><div>Recommend you use the db-control</div><div><br></div><div>- <span style="font-family:Calibri,sans-serif;font-size:11pt;line-height:115%">yum
install spacewalk-dobby -y</span></div><div><span style="font-family:Calibri,sans-serif;font-size:11pt;line-height:115%">- man db-control</span></div><div><span style="font-family:Calibri,sans-serif;font-size:11pt;line-height:115%"><br></span></div><div><span style="font-family:Calibri,sans-serif;font-size:11pt;line-height:115%">you can find more info here - </span><font face="Calibri, sans-serif"><span style="font-size:15px;line-height:16.8666667938232px"><a href="https://access.redhat.com/documentation/en-US/Red_Hat_Satellite/5.6/html-single/User_Guide/index.html#sect-Red_Hat_Satellite-User_Guide-Backing_up_a_Red_Hat_Satellite_Server">https://access.redhat.com/documentation/en-US/Red_Hat_Satellite/5.6/html-single/User_Guide/index.html#sect-Red_Hat_Satellite-User_Guide-Backing_up_a_Red_Hat_Satellite_Server</a></span></font></div><div><font face="Calibri, sans-serif"><span style="font-size:15px;line-height:16.8666667938232px"><br></span></font></div><div><font face="Calibri, sans-serif"><span style="font-size:15px;line-height:16.8666667938232px">Enjoy!</span></font></div></div><div class="gmail_extra"><br clear="all"><div><div class="gmail_signature"><div>______________<br>Atenciosamente<br>Waldirio<br>msn: <a href="mailto:waldirio@gmail.com" target="_blank">waldirio@gmail.com</a><br>Skype: waldirio<br>Site: <a href="http://www.waldirio.com.br" target="_blank">www.waldirio.com.br</a><br>Blog: <a href="http://blog.waldirio.com.br" target="_blank">blog.waldirio.com.br</a></div>
<div>LinkedIn: <a href="http://br.linkedin.com/pub/waldirio-pinheiro/22/b21/646" target="_blank">http://br.linkedin.com/pub/waldirio-pinheiro/22/b21/646</a><br>PGP: <a href="http://www.waldirio.com.br/public.html" target="_blank">www.waldirio.com.br/public.html</a></div></div></div>
<br><div class="gmail_quote">On Thu, Dec 18, 2014 at 8:38 AM, Matt Bayliss <span dir="ltr"><<a href="mailto:aarrgghh765@gmail.com" target="_blank">aarrgghh765@gmail.com</a>></span> wrote:<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div><div><div><div><div>Hi,<br><br>I'm trying to take a backup of the spacewalk db to flat file so that I can backup with another tool.<br><br></div>I've found the documentation for backing up a postgresql based installation <a href="https://fedorahosted.org/spacewalk/wiki/SpacewalkBackup" target="_blank">here</a> however the instruction says;<br><br></div><ol><li>stop spacewalk services (service-spacwalk stop)</li><li>Issue command to backup db</li></ol></div><br></div>I don't know too much about postgresql but it seems that you need it running to use the pg_dumpall command, a bit like mysqldump.  This has been stopped when I issued the spacewalk-service stop command [1].<br><br></div>With the postgresql service started, I get a problem with the documented backup command:<br><br><pre># su - postgres -c  'pg_dumpall > /var/lib/pgsql/backups/full_postgres_backup-`date +%Y%m%d`.sql'<br>        pg_dump: [archiver (db)] connection to database "template1" failed: FATAL:  no pg_hba.conf entry for host "[local]", user "postgres", database "template1", SSL off<br>pg_dumpall: pg_dump failed on database "template1", exiting<br><br></pre><pre><span style="font-family:arial,helvetica,sans-serif">I'm guessing that the installer modified the pg_hba.conf file in some way which makes the template db unbackupable (a new word which I've just invented, so there). I've tried replacing the all/all line to no<br>avail.<br></span></pre><pre><span style="font-family:arial,helvetica,sans-serif">Any tips on how I can avoid this error and get a nice hot backup for my dinner?<br></span></pre><pre><span style="font-family:arial,helvetica,sans-serif">Regards,<br><br>Matt<br></span></pre><div><br><br>[1]<br><br><span style="font-family:monospace"># spacewalk-service stop<br>Shutting down spacewalk services...<br>Stopping RHN Taskomatic...<br>Stopped RHN Taskomatic.<br>Stopping cobbler daemon:                                   [  OK  ]<br>Stopping rhn-search...<br>Stopped rhn-search.<br>Stopping MonitoringScout ...<br>[ OK ]<br>Stopping Monitoring ...<br>[ OK ]<br>Shutting down osa-dispatcher:                              [  OK  ]<br>Stopping httpd:                                            [  OK  ]<br>Stopping tomcat6:                                          [  OK  ]<br>Terminating jabberd processes ...<br>Stopping s2s:                                              [  OK  ]<br>Stopping c2s:                                              [  OK  ]<br>Stopping sm:                                               [  OK  ]<br>Stopping router:                                           [  OK  ]<br><span style="background-color:rgb(255,255,0)">Stopping postgresql service:                               [  OK  ]</span><br>Done.<br></span><br></div></div>
<br>_______________________________________________<br>
Spacewalk-list mailing list<br>
<a href="mailto:Spacewalk-list@redhat.com">Spacewalk-list@redhat.com</a><br>
<a href="https://www.redhat.com/mailman/listinfo/spacewalk-list" target="_blank">https://www.redhat.com/mailman/listinfo/spacewalk-list</a><br></blockquote></div></div>