Bacula-users

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

2010-10-04 16:42:09
Subject: Re: [Bacula-users] 5.0.3 psql indexes after upgrade
From: Rory Campbell-Lange <rory AT campbell-lange DOT net>
To: Ralf Gross <Ralf-Lists AT ralfgross DOT de>
Date: Mon, 4 Oct 2010 21:39:19 +0100
On 04/10/10, 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?

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
rory AT campbell-lange DOT 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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users

<Prev in Thread] Current Thread [Next in Thread>