#166 Postgres installation broken on Ubuntu/Deb

v_2.3
open
nobody
Database (41)
5
2013-01-23
2009-11-08
Phil Hord
No

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.

Discussion

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks