<html> <head> <meta http-equiv="Content-Type" content="text/html; charset=Windows-1252"> <style type="text/css" style="display:none;"></style> </head> <body dir="ltr"> <div id="divtagdefaultwrapper" style="font-size:12pt;color:#000000;font-family:'Trebuchet MS',Trebuchet,sans-serif;" dir="ltr"> Thanks everyone. There are a lot of different ways to do it! <div>The man page for pg_dumpall says "pg_dumpall also dumps global objects that are common to all databases. (pg_dump does not save these objects.) This currently includes information about database users and groups, tablespaces, and properties such as access permissions that apply to databases as a whole." Is that something we have to worry about if we just use the "pg_dump rhnschema" method to backup? Spacewalk is the only database I have. </div> Nicole <div style="color: rgb(0, 0, 0);"> <hr tabindex="-1" style="display:inline-block; width:98%"> <div id="divRplyFwdMsg" dir="ltr">From: spacewalk-list-bounces@redhat.com <spacewalk-list-bounces@redhat.com> on behalf of Brian Long <briandlong@gmail.com> Sent: Tuesday, February 27, 2018 10:49 AM To: spacewalk-list@redhat.com Subject: Re: [Spacewalk-list] postgres DB backup question <div> </div> </div> <div> <div dir="ltr">I use the "db-control" program to handle an online (DB running) backup. <div>db-control online-backup /local/backups/satellite-pgsql.$DATE 1>/dev/null </div> <div> </div> <div>/Brian/</div> </div> <div class="gmail_extra"> <div class="gmail_quote">On Mon, Feb 26, 2018 at 1:23 PM, Nicole Beck <<a href="mailto:nskyrca@syr.edu" target="_blank">nskyrca@syr.edu</a>> wrote: <blockquote class="gmail_quote" style="margin:0 0 0 .8ex; border-left:1px #ccc solid; padding-left:1ex"> <div lang="EN-US"> <div class="m_3770126169640865472WordSection1"> Hello! I’m trying to backup my postgress DB using the Spacewalk install documentation at <a href="https://github.com/spacewalkproject/spacewalk/wiki/SpacewalkBackup" target="_blank"> https://github.com/spacewalkproject/spacewalk/wiki/SpacewalkBackup</a>, and it fails with the errors below. If I try it without spacewalk running, it gives an error and creates an empty backup file. If I try it with spacewalk running, it creates a 3.9 GB backup file, but I can’t restore it. Spacewalk is the only thing using this database. How do you all do your database backups? Errors when spacewalk not running(creates empty backup file): [root@spacewalk ~]# spacewalk-service stop Shutting down spacewalk services... Redirecting to /bin/systemctl stop taskomatic.service Stopping cobblerd (via systemctl): [ OK ] Redirecting to /bin/systemctl stop rhn-search.service Redirecting to /bin/systemctl stop osa-dispatcher.service Redirecting to /bin/systemctl stop httpd.service Redirecting to /bin/systemctl stop tomcat.service Redirecting to /bin/systemctl stop jabberd.service Redirecting to /bin/systemctl stop postgresql.service 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 server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"? [root@spacewalk ~]# ls -al /var/lib/pgsql/backups total 0 drwx------ 2 postgres postgres 47 Feb 26 12:32 . drwx------ 6 postgres postgres 122 Nov 1 14:55 .. -rw-r--r-- 1 postgres postgres 0 Feb 26 12:32 full_postgres_backup-20180226.sql Errors when spacewalk running [root@spacewalk ~]# spacewalk-service start Starting spacewalk services... Redirecting to /bin/systemctl start Redirecting to /bin/systemctl start postgresql.service Redirecting to /bin/systemctl start jabberd.service Redirecting to /bin/systemctl start tomcat.service Waiting for tomcat to be ready ... Redirecting to /bin/systemctl start httpd.service Redirecting to /bin/systemctl start osa-dispatcher.service Redirecting to /bin/systemctl start rhn-search.service Starting cobblerd (via systemctl): [ OK ] Redirecting to /bin/systemctl start taskomatic.service Done. [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 [root@spacewalk backups]# ls -al total 3910032 drwx------ 2 postgres postgres 47 Feb 26 12:32 . drwx------ 6 postgres postgres 122 Nov 1 14:55 .. -rw-r--r-- 1 postgres postgres 4003869597 Feb 26 12:40 full_postgres_backup-20180226.sql But you can’t restore per the <a href="http://github.com" target="_blank">github.com</a> directions: [root@spacewalk backups]# su - postgres Last login: Mon Feb 26 12:38:18 EST 2018 on pts/0 -bash-4.2$ SPACEWALK_DB_NAME=spacewalkdb -bash-4.2$ ls /var/lib/pgsql/backups full_postgres_backup-20180226.sql -bash-4.2$ SPACEWALK_DB_BACKUPFILE=/var/lib/pgsql/backups/full_postgres_backup-20180226.sql -bash-4.2$ full_postgres_backup-20180226.sql^C -bash-4.2$ id uid=26(postgres) gid=26(postgres) groups=26(postgres) -bash-4.2$ dropdb $SPACEWALK_DB_NAME dropdb: could not connect to database template1: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"? Thanks! Nicole Nicole Beck Information Technology Analyst Information Technolgy Services – Core Infrustructure Services - Unix <a href="tel:(315)%20506-9744" value="+13155069744" target="_blank">315.506.9744</a> <a href="mailto:nskyrca@syr.edu" target="_blank">nskyrca@syr.edu</a> 215 Machinery Hall, Syracuse, NY 13244 <a href="http://syracuse.edu" target="_blank">syracuse.edu</a> Syracuse University </div> </div> _______________________________________________ Spacewalk-list mailing list <a href="mailto:Spacewalk-list@redhat.com">Spacewalk-list@redhat.com</a> <a href="https://www.redhat.com/mailman/listinfo/spacewalk-list" rel="noreferrer" target="_blank">https://www.redhat.com/mailman/listinfo/spacewalk-list</a> </blockquote> </div> </div> </div> </div> </div> </body> </html>