On 04/10/10, Ralf Gross (ralf-li...@ralfgross.de) wrote: > Hi, > > I just updated from 3.0.3 to 5.0.3. I know that there have been problems with > the update_postgresql_tables script. Here are my indexes: > > > bacula=# select * from pg_indexes where tablename='file'; > schemaname | tablename | indexname | tablespace | > indexdef > ------------+-----------+----------------+------------+----------------------------------------------------------------------------- > public | file | file_pkey | | CREATE UNIQUE INDEX > file_pkey ON file USING btree (fileid) > public | file | file_jobid_idx | | CREATE INDEX > file_jobid_idx ON file USING btree (jobid) > public | file | file_jpfid_idx | | CREATE INDEX > file_jpfid_idx ON file USING btree (jobid, pathid, filenameid) > (3 Zeilen) > > > Can anyone confirm that these indexes are correct. Looking at the manual, they > look ok to me. > > http://www.bacula.org/5.0.x-manuals/en/main/main/Catalog_Maintenance.html#SECTION004591000000000000000
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. Cheers Rory bacula=> \di List of relations Schema | Name | Type | Owner | Table --------+-------------------------------+-------+--------+---------------- public | basefiles_jobid_idx | index | bacula | basefiles public | basefiles_pkey | index | bacula | basefiles public | cdimages_pkey | index | bacula | cdimages public | client_name_idx | index | bacula | client public | client_pkey | index | bacula | client public | counters_pkey | index | bacula | counters public | device_pkey | index | bacula | device public | file_jobid_idx | index | bacula | file public | file_jpfid_idx | index | bacula | file public | file_pkey | index | bacula | file public | filename_name_idx | index | bacula | filename public | filename_pkey | index | bacula | filename public | fileset_name_idx | index | bacula | fileset public | fileset_pkey | index | bacula | fileset public | job_media_firstindex | index | bacula | jobmedia public | job_media_job_id_media_id_idx | index | bacula | jobmedia public | job_media_lastindex | index | bacula | jobmedia public | job_name_idx | index | bacula | job public | job_pkey | index | bacula | job public | jobhisto_idx | index | bacula | jobhisto public | jobmedia_pkey | index | bacula | jobmedia public | location_pkey | index | bacula | location public | locationlog_pkey | index | bacula | locationlog public | log_name_idx | index | bacula | log public | log_pkey | index | bacula | log public | media_pkey | index | bacula | media public | media_volumename_id | index | bacula | media public | mediatype_pkey | index | bacula | mediatype public | path_name_idx | index | bacula | path public | path_pkey | index | bacula | 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 | bacula | pool public | pool_pkey | index | bacula | pool public | status_pkey | index | bacula | status public | storage_pkey | index | bacula | storage public | unsavedfiles_pkey | index | bacula | unsavedfiles -- Rory Campbell-Lange r...@campbell-lange.net Campbell-Lange Workshop www.campbell-lange.net 0207 6311 555 3 Tottenham Street London W1T 2AF Registered in England No. 04551928 ------------------------------------------------------------------------------ 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users