[Spacewalk-list] Documentation error and backup question

[Matt Bayliss]

Thanks Waldirio,

Works a treat.

Matt

On 18 December 2014 at 11:11, Waldirio Manhães Pinheiro <waldirio at gmail.com>
wrote:
>
> Hello Matt
>
> Recommend you use the db-control
>
> - yum install spacewalk-dobby -y
> - man db-control
>
> you can find more info here -
> 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
>
> Enjoy!
>
> ______________
> Atenciosamente
> Waldirio
> msn: waldirio at gmail.com
> 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, Dec 18, 2014 at 8:38 AM, Matt Bayliss <aarrgghh765 at gmail.com>
> wrote:
>
>> Hi,
>>
>> I'm trying to take a backup of the spacewalk db to flat file so that I
>> can backup with another tool.
>>
>> I've found the documentation for backing up a postgresql based
>> installation here
>> <https://fedorahosted.org/spacewalk/wiki/SpacewalkBackup> however the
>> instruction says;
>>
>>
>>    1. stop spacewalk services (service-spacwalk stop)
>>    2. Issue command to backup db
>>
>>
>> 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].
>>
>> With the postgresql service started, I get a problem with the documented
>> backup command:
>>
>> # 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
>>
>> 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
>> avail.
>>
>> Any tips on how I can avoid this error and get a nice hot backup for my dinner?
>>
>> Regards,
>>
>> Matt
>>
>>
>>
>> [1]
>>
>> # 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.
>>
>>
>> _______________________________________________
>> Spacewalk-list mailing list
>> Spacewalk-list at redhat.com
>> https://www.redhat.com/mailman/listinfo/spacewalk-list
>>
>
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20141218/981c5086/attachment.htm>