[ postfixadmin-Bugs-2894287 ] Postgres installation broken on Ubuntu/Deb

[SourceForge.net <no...@so...>]

Bugs item #2894287, was opened at 2009-11-08 13:39
Message generated for change (Tracker Item Submitted) made by phord
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2894287&group_id=191583

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Database
Group: v 2.3
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Phil Hord (phord)
Assigned to: Nobody/Anonymous (nobody)
Summary: Postgres installation broken on Ubuntu/Deb

Initial Comment:
Postgres install fails in .deb package (and in other scripts) because "postfixadmin" user is not the owner of the "postfixadmin" database.  The database should be created "with owner postfixadmin;"

Not sure if this is relevant: Ubuntu default uses "ident" authentication on Postgres.  The "postgres" user is the only super-user.

When I installed PostfixAdmin using the .deb, it did create the database and user but it did not create any tables.  I tried dpkg-reconfigure several times to rebuild the database.  I finally figured out what was wrong by running upgrade.php?debug=1.  Then I modified the database to have owner postfixadmin:
postgres:~$ psql
Welcome to psql 8.3.8, the PostgreSQL interactive terminal.
postgres=# alter database postfixadmin owner to postfixadmin;
ALTER DATABASE
postgres=# \q

I ran the dpkg-reconfigure script again; I also ran the upgrade script, which reported it had more to do.  Not sure if this is because I had used other DB's in the process.

I had more trouble trying to run setup.php.  I didn't realize I needed to.  I should find the documentation, I guess.  It just seemed like this is what dpkg-reconfigure was doing.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2894287&group_id=191583