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
nsky...@syr.edu<mailto: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
