History for PostgresSQL
??changed:
-
**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