 |
Also the file backup_label is not created any more. It looks like the backup process has changed. https://www.postgresql.org/docs/current/continuous-archiving.html#BACKUP-BASE-BACKUP See 26.3.3 pg_backup_stop will return two fields, that has to be saved into files by the backup tool. (2-> backup_label, 3. -> tablespace_map). |
|
|
Seen by developer, but PR from external is welcomed too ;-) |
|
|
We have the same problem, we upgraded recently to postgresql 15.2 and no we cannot backup anything more, what can we do now? |
|
|
Using postgresql15 as database for bareos is possible but need new grant script which is proposed here future new grant script in https://github.com/bareos/bareos/pull/1449/files full file is https://github.com/bareos/bareos/blob/3660d4c4b59fd17052d663bd22927fa85b2398e6/core/src/cats/ddl/grants/postgresql.sql Backup & Restore PostgreSQL15 database with the postgresql plugin is not possible due to full changes of the backup API by PGDG group starting with 15. Contribution for improving the code is still awaited ... |
|
|
I checked, but we still use postgresql 14 for Bareos fortunately :) However our servers with postgresql 15 fail to backup. I checked and probably the easiest way is to switch to non exclusive backups for postgresql 15 as well. Most likely it could than function in the same way. The commands are renamed (easy) and the biggest difference for the rest is that the backup_label is no longer written to the file system but written when the "backup stop" is called. |
|
|
https://www.enterprisedb.com/blog/exclusive-backup-mode-finally-removed-postgres-15 https://www.cybertec-postgresql.com/en/exclusive-backup-deprecated-what-now/ The exclusive backup mode was deprecated since PostgreSQL 9.6 when non-exclusive backups were introduced. No idea why a brand new plugin was created with a method deprecated for more than 5 years! |
|
|
Hi, let us know if there is anything we can do to get the required changes. I think it must be pretty doable for the creator of the original plugin. As ar as I know the older PostgreSQL support even the same backup procedures (and even the same name: pg_backup_start etc) Maybe we can fund it a bit with the original requester of the functionality? |
|
|
To keep you informed: A new plugin will appear in 23 supporting PostgreSQL >= 10 The PR is available here https://github.com/bareos/bareos/pull/1541 Once build you can test with package located in https://download.bareos.org/experimental/PR-1541/ The new documentation will also appear into that repository. We will appreciate comments, remarks, and tests. |
|
|
Sorry took more time than expected, but finally the testing packages are now published. https://download.bareos.org/experimental/PR-1541/ Associated documentation is also available at that address https://download.bareos.org/experimental/PR-1541/BareosMainReference/TasksAndConcepts/Plugins.html#postgresql-plugin |
|
|
Dear community, it has been a long time since we were able to release a new set of binaries to test the new bareos-fd-postgresql plugin. You can now get the updated binaries directly from the experimental project https://download.bareos.org/experimental/PR-1541/ For those who have already installed and tested it, you should be able to simply update your test system with your operating system command like dnf, apt, zypper, etc. The plugin is now able to backup any PostgreSQL cluster from version 10 to 16, it will no longer complain if file/dir changes during the during the backup (as these changes are recorded in wal and saved at the end). We improved our system test to cover the case with cluster having activity or not, using tablespace, etc. We add to rename some configuration parameters to make the whole more coherent, check the documentation or code if you need to adapt. Reminder: the whole new documentation chapter about the plugin is available at https://download.bareos.org/experimental/PR-1541/BareosMainReference/TasksAndConcepts/Plugins.html#postgresql-plugin Thanks for any test you can do in your own environment, please report failure/success here on the mailing list, and any code improvements in the github comments here https://github.com/bareos/bareos/pull/1541/ Happy testing. |
|
|
Any news about your tests ? We would like to have the maximum of feedback, before going to merge the branch. |
|
|
Hi, can we "quickly" slip this plugin into the current bareos version? I believe we have also a new name for it right? |
|
|
As described in previous command the plugin will goes into Bareos 23 (which should be release in October, so really soon) It will not be backported to 22 it is called postgresql ( same package so if previous is installed the new one come with) but you have to configure it following the new documentation. Testing and reporting success or failure now is allowing a chance to have the fix get done quickly, after it will always take a bit of time. |
|
|
The new plugin code is now merged, and will be delivered with the soonish 23.0.0 build. |
- Anonymous
