From 1797682f476e3866488aa0b19898695b084a94df Mon Sep 17 00:00:00 2001
From: Dan Langille <dan@langille.org>
Date: Wed, 2 Dec 2009 11:30:12 +0100
Subject: [PATCH] Apply Postgres 8.4 SQL_ASCII fix

---
 bacula/src/cats/create_postgresql_database.in | 2 +-
 bacula/src/cats/make_catalog_backup.in        | 2 +-
 2 files changed, 2 insertions(+), 2 deletions(-)

diff --git a/bacula/src/cats/create_postgresql_database.in b/bacula/src/cats/create_postgresql_database.in
index 152eab8e41..624a8f1aba 100644
--- a/bacula/src/cats/create_postgresql_database.in
+++ b/bacula/src/cats/create_postgresql_database.in
@@ -25,7 +25,7 @@ ENCODING="ENCODING 'SQL_ASCII'"
 #   CREATE DATABASE ${db_name} $ENCODING TEMPLATE template0
 #
 if $bindir/psql -f - -d template1 $* <<END-OF-DATA
-CREATE DATABASE ${db_name} $ENCODING;
+CREATE DATABASE ${db_name} $ENCODING TEMPLATE template0;
 ALTER DATABASE ${db_name} SET datestyle TO 'ISO, YMD';
 END-OF-DATA
 then
diff --git a/bacula/src/cats/make_catalog_backup.in b/bacula/src/cats/make_catalog_backup.in
index a9643a12a9..b27ffb77d9 100755
--- a/bacula/src/cats/make_catalog_backup.in
+++ b/bacula/src/cats/make_catalog_backup.in
@@ -68,6 +68,6 @@ fi
 #  To read back a PostgreSQL database use:
 #     cd @working_dir@
 #     dropdb bacula
-#     createdb bacula -E SQL_ASCII
+#     createdb bacula -T template0 -E SQL_ASCII
 #     psql bacula <bacula.sql
 #
-- 
2.39.5