FrontPage
»
Setup_School_Servers
»
PostgresSQL
SQL Database Postgresql on Debian with Zope
- apt-get install postgresql postgresql-client postgresql-contrib (version 7.1)
- Caveat the default now requires an identd server and disables any other access that from the machine with matching linux login / postgresql login names; change /etc/postgresql/pg_hda.conf appropriately
- I stuggled with a bug in midentd debian package. The solution was to dpkg-statoverride --remove /var/run/identd
- By default, only user postgres can do anything. Solution: su - postgres and createuser someone_else or do all your work as user postgres