[Bacula-bugs] [bacula 0000079]: problems while creating tables

[<bac...@li...>]

A BUGNOTE has been added to this bug.
======================================================================
http://bugs.bacula.org/bug_view_advanced_page.php?bug_id=0000079
======================================================================
Reported By:                scoopex
Assigned To:                Dan Langille
======================================================================
Project:                    bacula
Bug ID:                     79
Category:                   PostgreSQL
Reproducibility:            always
Severity:                   feature
Priority:                   normal
Status:                     assigned
======================================================================
Date Submitted:             08-09-2004 02:45 GMT
Last Modified:              08-09-2004 06:38 GMT
======================================================================
Summary:                    problems while creating tables
Description: 
all of the scripts use statements like that:
--
root@backup3: # grep psql *
create_postgresql_database:if $bindir/psql template1 $* -f - <<END-OF-DATA
drop_postgresql_tables:if $bindir/psql $* -f - <<END-OF-DATA
grant_postgresql_privileges:if $bindir/psql $* bacula -f - <<END-OF-DATA
make_catalog_backup:#     psql bacula <bacula.sql
make_postgresql_tables:if $bindir/psql $* bacula -f - <<END-OF-DATA
update_postgresql_tables:if $bindir/psql $* -f - <<END-OF-DATA
--
PostgreSQL 7.4.3 doesn´t know/allow "-f -" - this is 
a fragment of the mysql-install-process - so the execution failed. ()as
described in the install-manual of postgresql)
PostgreSQL mostly uses the user "postgres" for performing
database-operations - doing this operations with the
"root"-user sometimes does not work.


Removing "-f -" solved my problem.
Maybe using "createuser" and "creatdb" would be a also a option.

======================================================================

----------------------------------------------------------------------
 scoopex - 08-09-2004 03:09 GMT 
----------------------------------------------------------------------
Sorry, this is not a feature-request -  it´s a bug :-)
I forgot to change the report-type....

----------------------------------------------------------------------
 kern - 08-09-2004 06:36 GMT 
----------------------------------------------------------------------
Can I assume that since you created the scripts, found the problem, and
propose removing the -f option, that you will be submitting a patch?

Concerning createuser and createdb -- maybe but if it is not *absolutely*
necessary, I would prefer not as it will complicated the documentation and
the scripts, especially concerning other DBs.

----------------------------------------------------------------------
 kern - 08-09-2004 06:38 GMT 
----------------------------------------------------------------------
Oops -- I saw Dan's name, and mistakenly assumed he was the author of the
bug -- not true. Please ignore my previous comment concerning submitting a
fix.  The second comment still applies.

Bug History
Date Modified  Username       Field                    Change              
======================================================================
08-09-04 02:45 scoopex        New Bug                                      
08-09-04 03:09 scoopex        Bugnote Added: 0000154                       
08-09-04 06:36 kern           Bugnote Added: 0000155                       
08-09-04 06:38 kern           Bugnote Added: 0000156                       
======================================================================