On Wed, Sep 15, 2010 at 09:01:41AM +0200, Olivier Berger wrote:
>
> Continuing installation of the package after having worked-around the failing
> postgresql-8.4 reload (see #596929), I now get database creation errors.
>
> Actually, they result from :
> # /usr/share/gforge/bin/install-db.sh configure
> Cannot create PostgreSQL database... This shouldn't have happened.
> Maybe a problem in your PostgreSQL configuration?
> Please report a bug to the Debian bug tracking system
> Please include the following output:
> CREATE DATABASE's STDOUT:
> SET
> CREATE DATABASE's STDERR:
> ERROR: new encoding (UTF8) is incompatible with the encoding of the template
> database (SQL_ASCII)
> HINT: Use the same encoding as in the template database, or use template0 as
> template.
>
> I guess this may be related to the fact I have already installed postgres and
> used it before installing fusionforge, but this exhibits lack of testing in
> squeeze environment I guess :-(
>
Patching /usr/share/gforge/bin/install-db.sh this way seems to solved the
issue, at least as the installation will perform to its end. Dunno if side
effects induced, though :-/ :
--- /usr/share/gforge/bin/install-db.sh 2010-09-15 09:16:26.000000000 +0200
+++ /usr/share/gforge/bin/install-db.sh~ 2010-03-01 21:15:27.000000000
+0100
@@ -190,7 +190,7 @@
if su -s /bin/sh postgres -c "/usr/bin/psql template1" 1> $tmp1
2> $tmp2 <<EOF \
&& [ "$(tail -n +2 $tmp1 | head -1)" = 'CREATE DATABASE' ]
;
SET LC_MESSAGES = 'C' ;
-CREATE DATABASE $db_name WITH TEMPLATE template0 ENCODING 'UNICODE';
+CREATE DATABASE $db_name WITH ENCODING 'UNICODE';
EOF
then
# Creation OK
Hope this helps.
Best regards,
--
To UNSUBSCRIBE, email to [email protected]
with a subject of "unsubscribe". Trouble? Contact [email protected]
