[bareos-users] Re: Unable to update database in remote server
Thank you Bruno! You led me in the right direction. One thing to notice is that setting the database name with the environment variable PGDATABASE does not work (I suspect this is not the expected behavior). The obvious workaround was to edit the script and hard code the database name. It would be great if the script prompted for each of the variables, maybe displaying the defaults with brackets in each prompt, so the user could hit enter to accept the proposed values or type the one it wishes to use. If setting environment variables is the recommended way to use the script, maybe the documentation at the Updating Bareos Tutorial <https://docs.bareos.org/IntroductionAndTutorial/UpdatingBareos.html> should reflect that. Anyway, thanks again for your help! On Thursday, March 6, 2025 at 4:50:25 PM UTC-5 Bruno Friedmann (bruno-at-bareos) wrote: > You can use the PG env variables to achieve this PGHOST PGPORT PGUSER > https://www.postgresql.org/docs/17/libpq-envars.html > > You're going to have a line similar to ... > PGHOST=remotehost /usr/lib/bareos/scripts/update_bareos_tables > > On Thursday, 6 March 2025 at 19:52:57 UTC+1 marcelo.j...@gmail.com wrote: > >> Hi Bareos Community, >> >> I have the PostgreSQL database on a different machine and I just upgraded >> Bareos to version 24. In past versions I was able to execute the script to >> upgrade the database tables like this: >> >> ./update_bareos_tables --host=[my database host here] --port=[my database >> port here] --user=[my database user here] >> >> With version 24, when I execute the script I get the following error: >> >> Error: db_type --host=[my database host here] is no more supported, only >> postgresql >> >> How do I solve this? >> >> Thank you! >> >> -- 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+unsubscr...@googlegroups.com. To view this discussion visit https://groups.google.com/d/msgid/bareos-users/e21dd72c-436c-40ba-aa96-54e3cfe76165n%40googlegroups.com.
[bareos-users] Re: Unable to update database in remote server
Yes, I totally missed that section: I was focused on following the Updating Bareos Section. Anyway, I guess my only suggestion then would be to include a reference to the Catalog Maintenance in the Updating Bareos Section. Again, thanks for the help! On Thursday, March 6, 2025 at 6:48:33 PM UTC-5 Bruno Friedmann (bruno-at-bareos) wrote: > you shouldn't never edit the script, but if you had check it, you would > have been able to find out that having db_name in your env variable would > have done the trick ;-) > we don't want to have an interactive script, that's kill automation :-) > > About the documentation you mean that section ? > > https://docs.bareos.org/TasksAndConcepts/CatalogMaintenance.html#remote-postgresql-database > > Because it is indicated in the upgrade db as link > > On Friday, 7 March 2025 at 00:31:11 UTC+1 marcelo.j...@gmail.com wrote: > >> Thank you Bruno! You led me in the right direction. >> One thing to notice is that setting the database name with the >> environment variable PGDATABASE does not work (I suspect this is not the >> expected behavior). The obvious workaround was to edit the script and hard >> code the database name. >> It would be great if the script prompted for each of the variables, maybe >> displaying the defaults with brackets in each prompt, so the user could hit >> enter to accept the proposed values or type the one it wishes to use. >> If setting environment variables is the recommended way to use the >> script, maybe the documentation at the Updating Bareos Tutorial >> <https://docs.bareos.org/IntroductionAndTutorial/UpdatingBareos.html> >> should reflect that. >> Anyway, thanks again for your help! >> On Thursday, March 6, 2025 at 4:50:25 PM UTC-5 Bruno Friedmann >> (bruno-at-bareos) wrote: >> >>> You can use the PG env variables to achieve this PGHOST PGPORT PGUSER >>> https://www.postgresql.org/docs/17/libpq-envars.html >>> >>> You're going to have a line similar to ... >>> PGHOST=remotehost /usr/lib/bareos/scripts/update_bareos_tables >>> >>> On Thursday, 6 March 2025 at 19:52:57 UTC+1 marcelo.j...@gmail.com >>> wrote: >>> >>>> Hi Bareos Community, >>>> >>>> I have the PostgreSQL database on a different machine and I just >>>> upgraded Bareos to version 24. In past versions I was able to execute the >>>> script to upgrade the database tables like this: >>>> >>>> ./update_bareos_tables --host=[my database host here] --port=[my >>>> database port here] --user=[my database user here] >>>> >>>> With version 24, when I execute the script I get the following error: >>>> >>>> Error: db_type --host=[my database host here] is no more supported, >>>> only postgresql >>>> >>>> How do I solve this? >>>> >>>> Thank you! >>>> >>>> -- 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+unsubscr...@googlegroups.com. To view this discussion visit https://groups.google.com/d/msgid/bareos-users/3b217707-bea8-4251-b210-db52ef3aa128n%40googlegroups.com.
[bareos-users] Unable to update database in remote server
Hi Bareos Community, I have the PostgreSQL database on a different machine and I just upgraded Bareos to version 24. In past versions I was able to execute the script to upgrade the database tables like this: ./update_bareos_tables --host=[my database host here] --port=[my database port here] --user=[my database user here] With version 24, when I execute the script I get the following error: Error: db_type --host=[my database host here] is no more supported, only postgresql How do I solve this? Thank you! -- 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+unsubscr...@googlegroups.com. To view this discussion visit https://groups.google.com/d/msgid/bareos-users/8bb2d483-3418-4c05-abe4-00bf49b6b150n%40googlegroups.com.
