This backend is very similar to the MySQL one, except that it uses PostgreSQL (and thus add constraints to ensure tables integrity). The PostgreSQL backend can (and should) be preferred to MySQL when possible, as the design is better done and uses the real possibilities of a database, like sequences, constraints, etc.
You should first create the wzdftpd user.
# su postgres $ psql -f createusers.sql template1You must allow the user wzdftpd to connect using a password: edit file
/etc/postgresql/pg_hba.confand add
host wzdftpd wzdftpd 127.0.0.1 255.255.255.255 md5Restart the server.
Create the initial table structure using the following:
$ psql -Uwzdftpd -f tables.sql wzdftpd Password:Default password is "wzdftpd" (you should change it in file createusers.sql !).
To use the PostgreSQL backend, add the following to you config file:
backend = /path/to/wzdftpd/share/wzdftpd/backends/libwzdpgsql.so backend_param_pgsql = login:password@host:base
Add comments on schema, constraints, etc. Work in progress !