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?
Thanks, oldtechaa On Sun, Nov 26, 2017 at 11:24 AM, oldtechaa <[email protected]> wrote: > Sorry, I'm not too experienced with SQL. I hadn't put a semicolon on it > before. Now when I do add a semicolon, it gives me: > > ERROR: must be owner of relation fileset > > > On Sat, Nov 25, 2017 at 10:44 AM, Jörg Steffens <[email protected] > > wrote: > >> On 25.11.2017 at 04:16 wrote oldtechaa: >> > I inspected the contents of the database and here is the output: >> > >> > For the list of tables: >> > >> > List of relations >> > Schema | Name | Type | Owner >> > --------+--------------------+-------+---------- >> > public | basefiles | table | postgres >> > public | client | table | postgres >> > public | counters | table | postgres >> > public | device | table | postgres >> > public | devicestats | table | postgres >> > public | file | table | postgres >> > public | filename | table | postgres >> > public | fileset | table | postgres >> > public | job | table | postgres >> > public | jobhisto | table | postgres >> > public | jobmedia | table | postgres >> > public | jobstats | table | postgres >> > public | location | table | postgres >> > public | locationlog | table | postgres >> > public | log | table | postgres >> > public | media | table | postgres >> > public | mediatype | table | postgres >> > public | ndmpjobenvironment | table | postgres >> > public | ndmplevelmap | table | postgres >> > public | path | table | postgres >> > public | pathhierarchy | table | postgres >> > public | pathvisibility | table | postgres >> > public | pool | table | postgres >> > public | quota | table | postgres >> > public | restoreobject | table | postgres >> > public | status | table | postgres >> > public | storage | table | postgres >> > public | tapealerts | table | postgres >> > public | unsavedfiles | table | postgres >> > public | version | table | postgres >> > (30 rows) >> > >> > For the structure of the fileset table: >> > >> > Table >> > "public.fileset" >> > Column | Type | >> > Modifiers | Storage | Stats target | >> Description >> > ------------+-----------------------------+----------------- >> --------------------------------------------+----------+---- >> ----------+------------- >> > filesetid | integer | not null default >> > nextval('fileset_filesetid_seq'::regclass) | plain | | >> > fileset | text | not >> > null | extended >> > | | >> > md5 | text | not >> > null | extended >> > | | >> > createtime | timestamp without time zone | not >> > null | plain >> > | | >> > Indexes: >> > "fileset_pkey" PRIMARY KEY, btree (filesetid) >> > "fileset_name_idx" btree (fileset) >> > >> > Everything looks fine except for FileSetText not existing. >> >> So, if it is missing, adding it using >> >> ALTER TABLE FileSet ADD COLUMN FileSetText TEXT DEFAULT '' >> >> has obliviously failed. >> Please apply it again and check for error messages. >> >> -- >> 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 a topic in the >> Google Groups "bareos-users" group. >> To unsubscribe from this topic, visit https://groups.google.com/d/to >> pic/bareos-users/5LEeq_-gWu0/unsubscribe. >> To unsubscribe from this group and all its topics, 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. >> > > -- 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.
