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/ > topic/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.
