Hello Friends Maybe what you are looking for is another way to do a cold backup. To do this you can do as bellow
1. Install the package spacewalk-dobby, if you don't have in your system the command db-control 2. Execute the command "spacewalk-service stop" to stop all SW environment / process 3. Execute the command "db-control backup <path to store your backup>" 4. Wait ... .... :) 5. Execute the command "spacewalk-service start" to start SW environment. You can do a hot backup too ..., btw, you can check all options available in 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 If you need some help, let me know. B' Regards Waldirio ______________ Atenciosamente Waldirio msn: [email protected] Skype: waldirio Site: www.waldirio.com.br Blog: blog.waldirio.com.br LinkedIn: http://br.linkedin.com/pub/waldirio-pinheiro/22/b21/646 PGP: www.waldirio.com.br/public.html On Thu, Sep 25, 2014 at 5:17 PM, satheesh murugesan < [email protected]> wrote: > Dear All, > > Please help me to solve the issue. > > I have installed spacewalk in centos 6.5 64 bit version > > Spacewalk version :- 2.2 > > Postrgress database :- postgres (PostgreSQL) 8.4.20 > > Installed spacewalk with embedded database. > > While Backing up the database getting the error. > > > ************************************************************************************************ > WHILE DOING BACKUP IN OFFLINE MODE OF THE SPACEWALK SERVICE GETTING THIS > ERROR > > [root@spacewalk ~]# spacewalk-service stop > Shutting down spacewalk services... > Stopping RHN Taskomatic... > Stopped RHN Taskomatic. > Stopping cobbler daemon: [ OK ] > Stopping rhn-search... > Stopped rhn-search. > Stopping MonitoringScout ... > [ OK ] > Stopping Monitoring ... > [ OK ] > Shutting down osa-dispatcher: [ OK ] > Stopping httpd: [ OK ] > Stopping tomcat6: [ OK ] > Terminating jabberd processes ... > Stopping s2s: [ OK ] > Stopping c2s: [ OK ] > Stopping sm: [ OK ] > Stopping router: [ OK ] > Stopping postgresql service: [ OK ] > Done. > [root@spacewalk ~]# su - postgres -c 'pg_dumpall > > /var/lib/pgsql/backups/full_ > postgres_backup-`date +%Y%m%d`.sql' > pg_dumpall: could not connect to database "template1": could not connect > to serv > er: No such file or directory > Is the server running locally and accepting > connections on Unix domain socket "/tmp/.s.PGSQL.5432"? > > > > ********************************************************************************************* > WHILE DOING BACKUP IN SPACEWALK ONLINE MODE > > [root@spacewalk ~]# spacewalk-service status > postmaster (pid 2625) is running... > router (pid 2643) is running... > sm (pid 2650) is running... > c2s (pid 2657) is running... > s2s (pid 2664) is running... > tomcat6 (pid 2734) is running... [ OK ] > httpd (pid 2881) is running... > osa-dispatcher (pid 2897) is running... > rhn-search is running (2947). > cobblerd (pid 2981) is running... > RHN Taskomatic is running (3005). > > [root@spacewalk ~]# su - postgres -c 'pg_dumpall > > /var/lib/pgsql/backups/full_postgres_backup-`date +%Y%m%d`.sql' > pg_dump: [archiver (db)] connection to database "template1" failed: FATAL: > no pg_hba.conf entry for host "[local]", user "postgres", database > "template1", SSL off > pg_dumpall: pg_dump failed on database "template1", exiting > > > Regards, > Satheesh Kumar > > > -- > With Regards > Satheesh > > _______________________________________________ > Spacewalk-list mailing list > [email protected] > https://www.redhat.com/mailman/listinfo/spacewalk-list >
_______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
