I use the "db-control" program to handle an online (DB running) backup. db-control online-backup /local/backups/satellite-pgsql.$DATE 1>/dev/null
/Brian/ On Mon, Feb 26, 2018 at 1:23 PM, Nicole Beck <nsky...@syr.edu> wrote: > Hello! > > I’m trying to backup my postgress DB using the Spacewalk install > documentation at https://github.com/spacewalkproject/spacewalk/ > wiki/SpacewalkBackup, 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 github.com 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 > > 315.506.9744 <(315)%20506-9744> > nsky...@syr.edu > > 215 Machinery Hall, Syracuse, NY 13244 > syracuse.edu > > Syracuse University > > > > > > _______________________________________________ > Spacewalk-list mailing list > Spacewalk-list@redhat.com > https://www.redhat.com/mailman/listinfo/spacewalk-list >
_______________________________________________ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list