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 debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org