[Bacula-bugs] [bacula 0001609]: create_postgresql_database.in small fix since the version is not always reported in the first line

[Mantis B. T. <no...@bu...>]

The following issue has been SUBMITTED. 
====================================================================== 
http://bugs.bacula.org/view.php?id=1609 
====================================================================== 
Reported By:                ohauer
Assigned To:                
====================================================================== 
Project:                    bacula
Issue ID:                   1609
Category:                   PostgreSQL
Reproducibility:            always
Severity:                   minor
Priority:                   normal
Status:                     new
====================================================================== 
Date Submitted:             2010-07-17 20:22 BST
Last Modified:              2010-07-17 20:22 BST
====================================================================== 
Summary:                    create_postgresql_database.in small fix since the
version is not always reported in the first line
Description: 
correct scrip create_postgresql_database.in to resolve installed postgres
version


fix:
--- /dev/null   2010-07-17 20:57:00.000000000 +0200
+++ files/patch-src__cats__create_postgresql_database.in    2010-07-17
20:55:31.000000000 +0200
@@ -0,0 +1,11 @@
+--- ./src/cats/create_postgresql_database.in.orig  2010-04-27
21:58:29.000000000 +0200
++++ ./src/cats/create_postgresql_database.in   2010-07-17
20:48:50.000000000 +0200
+@@ -10,7 +10,7 @@
+ # use SQL_ASCII to be able to put any filename into
+ #  the database even those created with unusual character sets
+
+-PSQLVERSION=`$bindir/psql -d template1 -c 'select version()' | head -n1 
| cut -d ' ' -f 2 | cut -d '.' -f 1,2`
++PSQLVERSION=`$bindir/psql -d template1 -c 'select version()' | awk
'/PostgreSQL/ {print $2}' | cut -d '.' -f 1,2`
+
+ #
+ # Note, LC_COLLATE and LC_TYPE are needed on 8.4 and beyond, but are

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

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2010-07-17 20:22 ohauer         New Issue                                    
======================================================================