Re: [Bacula-users] 5.0.3 psql indexes after upgrade
John Drescher schrieb: > On Mon, Oct 4, 2010 at 3:01 PM, Ralf Gross wrote: > > Rory Campbell-Lange schrieb: > >> On 04/10/10, Ralf Gross (ralf-li...@ralfgross.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
Re: [Bacula-users] 5.0.3 psql indexes after upgrade
On 04/10/10, Ralf Gross (ralf-li...@ralfgross.de) wrote: > Rory Campbell-Lange schrieb: > > On 04/10/10, Ralf Gross (ralf-li...@ralfgross.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? I must have done, as I have a large query which outputs the media of each backed-up file. Sorry about that. I note that the indexes aren't mentioned at http://www.bacula.org/manuals/en/developers/developers/Database_Tables.html -- might be useful if they did. -- 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
Re: [Bacula-users] 5.0.3 psql indexes after upgrade
On Mon, Oct 4, 2010 at 3:01 PM, Ralf Gross wrote: > Rory Campbell-Lange schrieb: >> On 04/10/10, Ralf Gross (ralf-li...@ralfgross.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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] 5.0.3 psql indexes after upgrade
Rory Campbell-Lange schrieb: > On 04/10/10, Ralf Gross (ralf-li...@ralfgross.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? 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] 5.0.3 psql indexes after upgrade
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#SECTION004591000 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