Re: [Bacula-users] 5.0.3 psql indexes after upgrade
2010-10-04 16:50:44
John Drescher schrieb:
> 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)
Hm, I'm missing some of the indexes:
file_pathid_idx
file_filenameid_idx
client_group_idx
client_group_member_idx
client_group_member_pkey
client_group_pkey
List of relations
Schema | Name | Type | Owner | Table
--------+-------------------------------+-------+----------+----------------
public | basefiles_jobid_idx | index | postgres | basefiles
public | basefiles_pkey | index | postgres | basefiles
public | cdimages_pkey | index | postgres | cdimages
public | client_name_idx | index | postgres | client
public | client_pkey | index | postgres | client
public | counters_pkey | index | postgres | counters
public | device_pkey | index | postgres | device
public | file_jobid_idx | index | postgres | file
public | file_jpfid_idx | index | postgres | file
public | file_pkey | index | postgres | file
public | filename_name_idx | index | postgres | filename
public | filename_pkey | index | postgres | filename
public | fileset_name_idx | index | postgres | fileset
public | fileset_pkey | index | postgres | fileset
public | job_media_job_id_media_id_idx | index | postgres | jobmedia
public | job_name_idx | index | postgres | job
public | job_pkey | index | postgres | job
public | jobhisto_idx | index | postgres | jobhisto
public | jobmedia_pkey | index | postgres | jobmedia
public | location_pkey | index | postgres | location
public | locationlog_pkey | index | postgres | locationlog
public | log_name_idx | index | postgres | log
public | log_pkey | index | postgres | log
public | media_pkey | index | postgres | media
public | media_volumename_id | index | postgres | media
public | mediatype_pkey | index | postgres | mediatype
public | path_name_idx | index | postgres | path
public | path_pkey | index | postgres | path
public | pathhierarchy_pkey | index | bacula | pathhierarchy
public | pathhierarchy_ppathid | index | bacula | pathhierarchy
public | pathvisibility_jobid | index | bacula | pathvisibility
public | pathvisibility_pkey | index | bacula | pathvisibility
public | pool_name_idx | index | postgres | pool
public | pool_pkey | index | postgres | pool
public | status_pkey | index | postgres | status
public | storage_pkey | index | postgres | storage
public | unsavedfiles_pkey | index | postgres | unsavedfiles
(37 rows)
Ralf
------------------------------------------------------------------------------
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
|
|
|