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