Horde won't install correctly

[andrew.clark@technologist.com]

I've been trying to get Horde to install on my unstable machine, and I've been having no end of problems.  Whenever the postinst script runs, either during a fresh install or a dpkg-reconfigure I get the following error message:

	pgsql extension for php4 found.
	Include of /etc/horde/apache.conf found in apache config files.
	index.php settings in /etc/apache/srm.conf found!
	index.php3 settings in /etc/apache/srm.conf found!
	Error when trying to connect to the pgsql database.
	This error can occur if you have no database to connect to, or
	if the password was incorrect.
	use: dpkg-reconfigure -plow packagename to reconfigure.
	Error when trying to connect to the pgsql database.
	This error can occur if you have no database to connect to, or
	if the password was incorrect.
	use: dpkg-reconfigure -plow packagename to reconfigure.

Looking through the postinst script, it seems that /usr/share/wwwconfig-common/pgsql-createdb and pqsql-createuser are both failing.

I tried to run these manually, and all is well until I get to

	elif ! $pgsqlcmd $systemdb -c "" >/dev/null 2>&1 ; then

Which I think would expand to:

	psql template1 -c ""

or

	psql template1 -c "" -U postgres

Which exit with:

	psql: FATAL 1:  user "root" does not exist

or

	psql: Peer authentication failed for user 'postgres'

respectivly.

If the later is run as the postgres user, it works fine.

I'm running:
	Package: postgresql
	Status: install ok installed
	Priority: optional
	Section: non-US
	Installed-Size: 7948
	Maintainer: Oliver Elphick <Oliver.Elphick@lfix.co.uk>
	Version: 7.1release-4

	Package: postgresql-client
	Status: install ok installed
	Priority: optional
	Section: non-US
	Installed-Size: 676
	Maintainer: Oliver Elphick <Oliver.Elphick@lfix.co.uk>
	Source: postgresql
	Version: 7.1release-4

	Package: wwwconfig-common
	Status: install ok installed
	Priority: optional
	Section: web
	Installed-Size: 169
	Maintainer: Ola Lundqvist <opal@debian.org>
	Version: 0.0.10

	Package: horde
	Status: install ok installed
	Priority: optional
	Section: web
	Installed-Size: 1735
	Maintainer: Ola Lundqvist <opal@debian.org>
	Version: 3:1.2.6-1


I can't figure out what's wrong, can anyone else?

Please CC any replies to andrew.clark@technologist.com

R,

AJFC