[Spacewalk-list] postgres DB backup question

[Brian Long]

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 <nskyrca at 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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>
> nskyrca at syr.edu
>
> 215 Machinery Hall, Syracuse, NY 13244
> syracuse.edu
>
> Syracuse University
>
>
>
>
>
> _______________________________________________
> 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/20180227/4224c63a/attachment.htm>