<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
<!DOCTYPE bugzilla SYSTEM "http://bugs.gentoo.org/bugzilla.dtd">

<bugzilla version="2.22.7"
          urlbase="http://bugs.gentoo.org/"
          maintainer="bugzilla@gentoo.org"
>

    <bug>
          <bug_id>124745</bug_id>
          
          <creation_ts>2006-03-02 23:40 0000</creation_ts>
          <short_desc>bacula postgres create database script</short_desc>
          <delta_ts>2006-03-26 16:48:58 0000</delta_ts>
          <reporter_accessible>1</reporter_accessible>
          <cclist_accessible>1</cclist_accessible>
          <classification_id>1</classification_id>
          <classification>Unclassified</classification>
          <product>Gentoo Linux</product>
          <component>Ebuilds</component>
          <version>2006.0</version>
          <rep_platform>x86</rep_platform>
          <op_sys>Linux</op_sys>
          <bug_status>RESOLVED</bug_status>
          <resolution>FIXED</resolution>
          
          
          
          <priority>P5</priority>
          <bug_severity>normal</bug_severity>
          <target_milestone>---</target_milestone>
          
          
          
          <everconfirmed>1</everconfirmed>
          <reporter>aron@aron.nu</reporter>
          <assigned_to>labmonkey@gentoo.org</assigned_to>
          <cc>app-backup@gentoo.org</cc>

      

      
          <long_desc isprivate="0">
            <who>aron@aron.nu</who>
            <bug_when>2006-03-02 23:40:39 0000</bug_when>
            <thetext>Only an annoyance really, but

Ebuild states:
 * If this is a new install, you must create the postgresql databases with:
 *  /var/lib/bacula/create_postgresql_database
 *  /var/lib/bacula/grant_postgresql_privileges
 *  /var/lib/bacula/make_postgresql_tables

But if it is entered in that order, the following happens when the second script is run:
CREATE USER
psql:&lt;stdin&gt;:5: ERROR:  relation &quot;unsavedfiles&quot; does not exist
psql:&lt;stdin&gt;:6: ERROR:  relation &quot;basefiles&quot; does not exist
psql:&lt;stdin&gt;:7: ERROR:  relation &quot;jobmedia&quot; does not exist
psql:&lt;stdin&gt;:8: ERROR:  relation &quot;file&quot; does not exist
psql:&lt;stdin&gt;:9: ERROR:  relation &quot;job&quot; does not exist
psql:&lt;stdin&gt;:10: ERROR:  relation &quot;media&quot; does not exist
psql:&lt;stdin&gt;:11: ERROR:  relation &quot;client&quot; does not exist
psql:&lt;stdin&gt;:12: ERROR:  relation &quot;pool&quot; does not exist
psql:&lt;stdin&gt;:13: ERROR:  relation &quot;fileset&quot; does not exist
psql:&lt;stdin&gt;:14: ERROR:  relation &quot;path&quot; does not exist
psql:&lt;stdin&gt;:15: ERROR:  relation &quot;filename&quot; does not exist
psql:&lt;stdin&gt;:16: ERROR:  relation &quot;counters&quot; does not exist
psql:&lt;stdin&gt;:17: ERROR:  relation &quot;version&quot; does not exist
psql:&lt;stdin&gt;:18: ERROR:  relation &quot;cdimages&quot; does not exist
psql:&lt;stdin&gt;:22: ERROR:  relation &quot;filename_filenameid_seq&quot; does not exist
psql:&lt;stdin&gt;:23: ERROR:  relation &quot;path_pathid_seq&quot; does not exist
psql:&lt;stdin&gt;:24: ERROR:  relation &quot;fileset_filesetid_seq&quot; does not exist
psql:&lt;stdin&gt;:25: ERROR:  relation &quot;pool_poolid_seq&quot; does not exist
psql:&lt;stdin&gt;:26: ERROR:  relation &quot;client_clientid_seq&quot; does not exist
psql:&lt;stdin&gt;:27: ERROR:  relation &quot;media_mediaid_seq&quot; does not exist
psql:&lt;stdin&gt;:28: ERROR:  relation &quot;job_jobid_seq&quot; does not exist
psql:&lt;stdin&gt;:29: ERROR:  relation &quot;file_fileid_seq&quot; does not exist
psql:&lt;stdin&gt;:30: ERROR:  relation &quot;jobmedia_jobmediaid_seq&quot; does not exist
psql:&lt;stdin&gt;:31: ERROR:  relation &quot;basefiles_baseid_seq&quot; does not exist
Privileges for bacula granted.


Suggestion:
List the scripts in the following order:
Ebuild states:
 * If this is a new install, you must create the postgresql databases with:
 *  /var/lib/bacula/create_postgresql_database
 *  /var/lib/bacula/make_postgresql_tables
 *  /var/lib/bacula/grant_postgresql_privileges</thetext>
          </long_desc>
          <long_desc isprivate="0">
            <who>jakub@gentoo.org</who>
            <bug_when>2006-03-03 00:06:49 0000</bug_when>
            <thetext>Wrong product, read the descriptions before filing a bug.</thetext>
          </long_desc>
          <long_desc isprivate="0">
            <who>labmonkey@gentoo.org</who>
            <bug_when>2006-03-26 16:48:58 0000</bug_when>
            <thetext>Fixed in cvs, thanks for reporting.</thetext>
          </long_desc>
      
    </bug>

</bugzilla>