On Mon, Oct 4, 2010 at 3:01 PM, Ralf Gross <Ralf-Lists AT ralfgross DOT de> 
wrote:
> Rory Campbell-Lange schrieb:
>> On 04/10/10, Ralf Gross (Ralf-Lists AT ralfgross DOT de) wrote:
>>
>> All of the indexes are below; you seem to have the correct ones for the file 
>> table.
>>
>> The Debian problems with 5.0.3 were/are related to the upgrade trying to 
>> create
>> an index that already exists. See  Bug#591293.
>>  ...
>>  public | job_media_firstindex          | index | bacula | jobmedia
>>  ...
>>  public | job_media_lastindex           | index | bacula | jobmedia
>
> I don't have these two indexes, did you add them?
>

Here is what I have on gentoo. And no I did not add any index for many years.


bacula-# \di
                               List of relations
 Schema |             Name              | Type  |  Owner  |        Table
--------+-------------------------------+-------+---------+---------------------
 public | basefiles_jobid_idx           | index | hbroker | basefiles
 public | basefiles_pkey                | index | hbroker | basefiles
 public | cdimages_pkey                 | index | hbroker | cdimages
 public | client_group_idx              | index | hbroker | client_group
 public | client_group_member_idx       | index | hbroker | client_group_member
 public | client_group_member_pkey      | index | hbroker | client_group_member
 public | client_group_pkey             | index | hbroker | client_group
 public | counters_pkey                 | index | hbroker | counters
 public | device_pkey                   | index | hbroker | device
 public | file_filenameid_idx           | index | hbroker | file
 public | file_jobid_idx                | index | hbroker | file
 public | file_jpfid_idx                | index | hbroker | file
 public | file_pathid_idx               | index | hbroker | file
 public | file_pkey                     | index | hbroker | file
 public | filename_name_idx             | index | hbroker | filename
 public | filename_pkey                 | index | hbroker | filename
 public | fileset_name_idx              | index | hbroker | fileset
 public | fileset_pkey                  | index | hbroker | fileset
 public | job_media_job_id_media_id_idx | index | hbroker | jobmedia
 public | job_name_idx                  | index | hbroker | job
 public | job_pkey                      | index | hbroker | job
 public | jobhisto_idx                  | index | hbroker | jobhisto
 public | jobmedia_pkey                 | index | hbroker | jobmedia
 public | location_pkey                 | index | hbroker | location
 public | locationlog_pkey              | index | hbroker | locationlog
 public | log_name_idx                  | index | hbroker | log
 public | log_pkey                      | index | hbroker | log
 public | media_pkey                    | index | hbroker | media
 public | media_volumename_id           | index | hbroker | media
 public | mediatype_pkey                | index | hbroker | mediatype
 public | path_name_idx                 | index | hbroker | path
 public | path_pkey                     | index | hbroker | path
 public | pathhierarchy_pkey            | index | hbroker | pathhierarchy
 public | pathhierarchy_ppathid         | index | hbroker | pathhierarchy
 public | pathvisibility_jobid          | index | hbroker | pathvisibility
 public | pathvisibility_pkey           | index | hbroker | pathvisibility
 public | pool_name_idx                 | index | hbroker | pool
 public | pool_pkey                     | index | hbroker | pool
 public | status_pkey                   | index | hbroker | status
 public | storage_pkey                  | index | hbroker | storage
 public | unsavedfiles_pkey             | index | hbroker | unsavedfiles
(41 rows)

------------------------------------------------------------------------------
Virtualization is moving to the mainstream and overtaking non-virtualized
environment for deploying applications. Does it make network security 
easier or more difficult to achieve? Read this whitepaper to separate the 
two and get a better understanding.
http://p.sf.net/sfu/hp-phase2-d2d
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users