Cannot back up PostgreSQL database with smdba

SUSE Manager
1

Running SUMA 3.1.5. I am getting an error when trying to back up the database:

# smdba backup-hot --enable=on --backup-dir=/var/spacewalk/db-backup pg_basebackup: initiating base backup, waiting for checkpoint to complete pg_basebackup: could not initiate base backup: ERROR: syntax error INFO: Finished

Any ideas?

2

Is this a new setup, or one that has been around for a while and upgrade?
A test setup or prod, and can you duplicate it anywhere else?

Does anything via the smdba command work, e.g.:

smdba db-stop     #stopping the database
smdba db-start    #restarting it

Is the /var/spacewalk/db-backup directly owned by, presumably, the
postgres user and group?

I do not know that it matters, but the database connection information in
etc/rhn/rhn.conf may be worth reviewing to see if anything is blatantly
incorrect. Presumable your SUSE Manager installation is working, so is
probably unlikely.

–
Good luck.

If you find this post helpful and are logged into the web interface,
show your appreciation and click on the star below.

If you want to send me a private message, please let me know in the
forum as I do not use the web interface often.

3

The system was originally installed with SUMA 3.0 and upgraded to 3.1.5.

This is the only SUMA server we have so nothing else to test against.

[QUOTE]Does anything via the smdba command work, e.g.:

smdba db-stop #stopping the database smdba db-start #restarting it [/QUOTE]

I was able to run “[FONT=Courier New]smdba space-overview[/FONT]”, “[FONT=Courier New]smdba db-status[/FONT]”, and “[FONT=Courier New]smdba space-tables[/FONT]” without any problems.

[QUOTE]Is the /var/spacewalk/db-backup directly owned by, presumably, the
postgres user and group?[/QUOTE]

Yes, permissions on [FONT=Courier New]/var/spacewalk/db-backup[/FONT] are ok.

[QUOTE]I do not know that it matters, but the database connection information in
etc/rhn/rhn.conf may be worth reviewing to see if anything is blatantly
incorrect. Presumable your SUSE Manager installation is working, so is
probably unlikely.[/QUOTE]

The settings in [FONT=Courier New]/etc/rhn/rhn.conf[/FONT] look ok.