On 26.11.2017 at 19:35 wrote oldtechaa: > On further investigation, all the database tables are owned by the user > "postgres". Is this correct and if not, how can I fix it and why did it > happen?
Typically, on Debian systems the owner is "bareos", as the database is created as unix user bareos. On other systems is it often postgres and the permissions to bareos are given by the /usr/lib/bareos/scripts/grant_bareos_privileges script. To alter the table, you must switch user to postgres. # su - postgres -s /bin/bash # psql bareos ALTER TABLE FileSet ADD COLUMN FileSetText TEXT DEFAULT ''; # /usr/lib/bareos/scripts/grant_bareos_privileges -- Jörg Steffens [email protected] Bareos GmbH & Co. KG Phone: +49 221 630693-91 http://www.bareos.com Fax: +49 221 630693-10 Sitz der Gesellschaft: Köln | Amtsgericht Köln: HRA 29646 Komplementär: Bareos Verwaltungs-GmbH Geschäftsführer: S. Dühr, M. Außendorf, Jörg Steffens, P. Storz -- 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 [email protected]. To post to this group, send email to [email protected]. For more options, visit https://groups.google.com/d/optout.
