[Bacula-users] 5.0.3 psql indexes after upgrade

2010-10-04 Thread Ralf Gross
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

Re: [Bacula-users] 5.0.3 psql indexes after upgrade

2010-10-04 Thread Rory Campbell-Lange
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 |

Re: [Bacula-users] 5.0.3 psql indexes after upgrade

2010-10-04 Thread Ralf Gross
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.

Re: [Bacula-users] 5.0.3 psql indexes after upgrade

2010-10-04 Thread John Drescher
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 up

Re: [Bacula-users] 5.0.3 psql indexes after upgrade

2010-10-04 Thread Rory Campbell-Lange
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 rel

Re: [Bacula-users] 5.0.3 psql indexes after upgrade

2010-10-04 Thread Ralf Gross
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 problem