<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"> <head> <meta http-equiv="Content-Type" content="text/html; charset=us-ascii"> <meta name="Generator" content="Microsoft Word 15 (filtered medium)"> <style></style> </head> <body lang="EN-US" link="#0563C1" vlink="#954F72"> <div class="WordSection1"> Hello!<o:p></o:p> I’m trying to backup my postgress DB using the Spacewalk install documentation at <a href="https://github.com/spacewalkproject/spacewalk/wiki/SpacewalkBackup">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? <o:p></o:p> <o:p> </o:p> Errors when spacewalk not running(creates empty backup file):<o:p></o:p> <o:p> </o:p> [root@spacewalk ~]# spacewalk-service stop<o:p></o:p> Shutting down spacewalk services...<o:p></o:p> Redirecting to /bin/systemctl stop taskomatic.service<o:p></o:p> Stopping cobblerd (via systemctl): [ OK ]<o:p></o:p> Redirecting to /bin/systemctl stop rhn-search.service<o:p></o:p> Redirecting to /bin/systemctl stop osa-dispatcher.service<o:p></o:p> Redirecting to /bin/systemctl stop httpd.service<o:p></o:p> Redirecting to /bin/systemctl stop tomcat.service<o:p></o:p> Redirecting to /bin/systemctl stop jabberd.service<o:p></o:p> Redirecting to /bin/systemctl stop postgresql.service<o:p></o:p> Done.<o:p></o:p> [root@spacewalk ~]# su - postgres -c 'pg_dumpall > /var/lib/pgsql/backups/full_postgres_backup-`date +%Y%m%d`.sql'<o:p></o:p> pg_dumpall: could not connect to database "template1": could not connect to server: No such file or directory<o:p></o:p> Is the server running locally and accepting<o:p></o:p> connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?<o:p></o:p> [root@spacewalk ~]# ls -al /var/lib/pgsql/backups<o:p></o:p> total 0<o:p></o:p> drwx------ 2 postgres postgres 47 Feb 26 12:32 .<o:p></o:p> drwx------ 6 postgres postgres 122 Nov 1 14:55 ..<o:p></o:p> -rw-r--r-- 1 postgres postgres 0 Feb 26 12:32 full_postgres_backup-20180226.sql<o:p></o:p> <o:p> </o:p> <o:p> </o:p> Errors when spacewalk running <o:p></o:p> <o:p> </o:p> [root@spacewalk ~]# spacewalk-service start<o:p></o:p> Starting spacewalk services...<o:p></o:p> Redirecting to /bin/systemctl start<o:p></o:p> Redirecting to /bin/systemctl start postgresql.service<o:p></o:p> Redirecting to /bin/systemctl start jabberd.service<o:p></o:p> Redirecting to /bin/systemctl start tomcat.service<o:p></o:p> Waiting for tomcat to be ready ...<o:p></o:p> Redirecting to /bin/systemctl start httpd.service<o:p></o:p> Redirecting to /bin/systemctl start osa-dispatcher.service<o:p></o:p> Redirecting to /bin/systemctl start rhn-search.service<o:p></o:p> Starting cobblerd (via systemctl): [ OK ]<o:p></o:p> Redirecting to /bin/systemctl start taskomatic.service<o:p></o:p> Done.<o:p></o:p> [root@spacewalk ~]# su - postgres -c 'pg_dumpall > /var/lib/pgsql/backups/full_postgres_backup-`date +%Y%m%d`.sql'<o:p></o:p> pg_dump: [archiver (db)] connection to database "template1" failed: FATAL: no pg_hba.conf entry for host "[local]", user "postgres", database "template1", SSL off<o:p></o:p> pg_dumpall: pg_dump failed on database "template1", exiting<o:p></o:p> [root@spacewalk backups]# ls -al<o:p></o:p> total 3910032<o:p></o:p> drwx------ 2 postgres postgres 47 Feb 26 12:32 .<o:p></o:p> drwx------ 6 postgres postgres 122 Nov 1 14:55 ..<o:p></o:p> -rw-r--r-- 1 postgres postgres 4003869597 Feb 26 12:40 full_postgres_backup-20180226.sql<o:p></o:p> <o:p> </o:p> But you can’t restore per the github.com directions:<o:p></o:p> <o:p> </o:p> [root@spacewalk backups]# su - postgres<o:p></o:p> Last login: Mon Feb 26 12:38:18 EST 2018 on pts/0<o:p></o:p> -bash-4.2$ SPACEWALK_DB_NAME=spacewalkdb<o:p></o:p> -bash-4.2$ ls /var/lib/pgsql/backups<o:p></o:p> full_postgres_backup-20180226.sql<o:p></o:p> -bash-4.2$ SPACEWALK_DB_BACKUPFILE=/var/lib/pgsql/backups/full_postgres_backup-20180226.sql<o:p></o:p> -bash-4.2$ full_postgres_backup-20180226.sql^C<o:p></o:p> -bash-4.2$ id<o:p></o:p> uid=26(postgres) gid=26(postgres) groups=26(postgres)<o:p></o:p> -bash-4.2$ dropdb $SPACEWALK_DB_NAME<o:p></o:p> dropdb: could not connect to database template1: could not connect to server: No such file or directory<o:p></o:p> Is the server running locally and accepting<o:p></o:p> connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?<o:p></o:p> <o:p> </o:p> Thanks!<o:p></o:p> Nicole<o:p></o:p> <o:p> </o:p> <o:p> </o:p> Nicole Beck Information Technology Analyst Information Technolgy Services – Core Infrustructure Services - Unix<o:p></o:p> 315.506.9744 <a href="mailto:nskyrca@syr.edu">nskyrca@syr.edu</a><o:p></o:p> 215 Machinery Hall, Syracuse, NY 13244 syracuse.edu<o:p></o:p> Syracuse University<o:p></o:p> <o:p> </o:p> <o:p> </o:p> </div> </body> </html>