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