<div dir="ltr">Hello Friends<div><br></div><div>Maybe what you are looking for is another way to do a cold backup. To do this you can do as bellow</div><div><br></div><div>1. Install the package spacewalk-dobby, if you don't have in your system the command db-control</div><div>2. Execute the command "spacewalk-service stop" to stop all SW environment / process</div><div>3. Execute the command "db-control backup <path to store your backup>"</div><div>4. Wait ... .... :)</div><div>5. Execute the command "spacewalk-service start" to start SW environment.</div><div><br></div><div>You can do a hot backup too ..., btw, you can check all options available in <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_an_Embedded_Database-Performing_Offline_Database_Backups">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_an_Embedded_Database-Performing_Offline_Database_Backups</a></div><div><br></div><div>If you need some help, let me know.</div><div><br></div><div>B' Regards</div><div>Waldirio</div><div><br></div><div><br></div></div><div class="gmail_extra"><br clear="all"><div><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>
<br><div class="gmail_quote">On Thu, Sep 25, 2014 at 5:17 PM, satheesh murugesan <span dir="ltr"><<a href="mailto:msatheeshsalem@gmail.com" target="_blank">msatheeshsalem@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Dear All,<div><br></div><div>Please help me to solve the issue.</div><div><br></div><div>I have installed spacewalk in centos 6.5 64 bit version</div><div><br></div><div>Spacewalk version :- 2.2 </div><div><br></div><div>Postrgress database :- postgres (PostgreSQL) 8.4.20</div><div><br></div><div>Installed spacewalk with embedded database.</div><div><br></div><div>While Backing up the database getting the error.</div><div><br></div><div>************************************************************************************************</div><div>WHILE DOING BACKUP IN OFFLINE MODE OF THE SPACEWALK SERVICE GETTING THIS ERROR </div><div><br></div><div><div>[root@spacewalk ~]# spacewalk-service stop</div><div>Shutting down spacewalk services...</div><div>Stopping RHN Taskomatic...</div><div>Stopped RHN Taskomatic.</div><div>Stopping cobbler daemon: [ OK ]</div><div>Stopping rhn-search...</div><div>Stopped rhn-search.</div><div>Stopping MonitoringScout ...</div><div>[ OK ]</div><div>Stopping Monitoring ...</div><div>[ OK ]</div><div>Shutting down osa-dispatcher: [ OK ]</div><div>Stopping httpd: [ OK ]</div><div>Stopping tomcat6: [ OK ]</div><div>Terminating jabberd processes ...</div><div>Stopping s2s: [ OK ]</div><div>Stopping c2s: [ OK ]</div><div>Stopping sm: [ OK ]</div><div>Stopping router: [ OK ]</div><div>Stopping postgresql service: [ OK ]</div><div>Done.</div><div>[root@spacewalk ~]# su - postgres -c 'pg_dumpall > /var/lib/pgsql/backups/full_ postgres_backup-`date +%Y%m%d`.sql'</div><div>pg_dumpall: could not connect to database "template1": could not connect to serv er: No such file or directory</div><div> Is the server running locally and accepting</div><div> connections on Unix domain socket "/tmp/.s.PGSQL.5432"?</div><div><br></div></div><div><br></div><div>*********************************************************************************************</div><div>WHILE DOING BACKUP IN SPACEWALK ONLINE MODE </div><div><br></div><div><div>[root@spacewalk ~]# spacewalk-service status</div><div>postmaster (pid 2625) is running...</div><div>router (pid 2643) is running...</div><div>sm (pid 2650) is running...</div><div>c2s (pid 2657) is running...</div><div>s2s (pid 2664) is running...</div><div>tomcat6 (pid 2734) is running... [ OK ]</div><div>httpd (pid 2881) is running...</div><div>osa-dispatcher (pid 2897) is running...</div><div>rhn-search is running (2947).</div><div>cobblerd (pid 2981) is running...</div><div>RHN Taskomatic is running (3005).</div></div><div><br></div><div><div>[root@spacewalk ~]# su - postgres -c 'pg_dumpall > /var/lib/pgsql/backups/full_postgres_backup-`date +%Y%m%d`.sql'</div><div>pg_dump: [archiver (db)] connection to database "template1" failed: FATAL: no pg_hba.conf entry for host "[local]", user "postgres", database "template1", SSL off</div><div>pg_dumpall: pg_dump failed on database "template1", exiting</div></div><div><br></div><div><br></div><div>Regards,</div><div>Satheesh Kumar</div><span class="HOEnZb"><font color="#888888"><div><br></div><div><div><br></div>-- <br>With Regards<br> Satheesh<br>
</div></font></span></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><br></div>