I changed the database from MariaDB to PostgreSQL "Now the backups no longer work"

[shar...@t-online.de]

Hi there,

after changing the database backend from MariaDB to PostgreSQL, all backups fail with the following error message:

...

backupadmin
MIME-Version: 1.0
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: 8bit

05-Nov 03:45 bareos-dir JobId 0: Fatal error: cats/sql_create.cc:536 cats/sql_create.cc:536 query SELECT ClientId,Uname FROM Client WHERE Name='bareos-fd' failed:
keine Verbindung mit dem Server

05-Nov 03:47 bareos-dir JobId 0: Error: cats/sql_create.cc:578 Create DB Client record INSERT INTO Client (Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES ('bareos-fd','',0,5184000,15552000) failed. ERR=keine Verbindung mit dem Server

05-Nov 03:48 bareos-dir JobId 0: Fatal error: Could not create Client record. ERR=Query failed: INSERT INTO Log (JobId, Time, LogText) VALUES (0,'2021-11-05 03:47:30','bareos-dir JobId 0: Error: cats/sql_create.cc:578 Create DB Client record INSERT INTO Client (Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES (''bareos-fd'','''',0,5184000,15552000) failed. ERR=keine Verbindung mit dem Server

'): ERR=keine Verbindung mit dem Server

...

Do you have a tip where I can look for the error?

Greetings from Stefan Harbich

[Kai Zimmer]

Hi Stefan,

instead of changing the backend i'd rather
- add another catalog in the bareos-dir configuration or
- convert the current database to postgres, and change the catalog configuration, there are scripts available from bareos for that (but can be quite time consuming)

Best regards,

Kai Zimmer

--
You received this message because you are subscribed to the Google Groups "bareos-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to bareos-users...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/bareos-users/0e88fb24-b110-48ae-9468-ed927abea0b6n%40googlegroups.com.