Build courier-authlib 0.60.2-0hcoop6.
[hcoop/debian/courier-authlib.git] / README.authpostgres.html
CommitLineData
d9898ee8 1<?xml version="1.0" encoding="iso-8859-1"?>
2<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
3 "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
4<html xmlns="http://www.w3.org/1999/xhtml">
5<head>
6 <title>Courier PostgreSQL authentication module</title>
7 <meta name="MSSmartTagsPreventParsing" content="TRUE" />
8</head>
9
10<body text="#000000" bgcolor="#FFFFFF" link="#0000EE" vlink="#551A8B"
11alink="#FF0000">
12<h1>Courier PostgreSQL authentication module</h1>
13
14<p>Please read <a href="README.authmysql.html">README.authmysql.html</a>
15since almost all information there applies to postgres as well, but with
16postgres change the schema to:</p>
17<pre>CREATE TABLE passwd (
18 id varchar(128) DEFAULT '' NOT NULL,
19 crypt varchar(128) DEFAULT '' NOT NULL,
20 clear varchar(128) DEFAULT '' NOT NULL,
21 name varchar(128) DEFAULT '' NOT NULL,
22 uid int DEFAULT 65534 NOT NULL,
23 gid int DEFAULT 65534 NOT NULL,
24 home varchar(255) DEFAULT '' NOT NULL,
25 maildir varchar(255) DEFAULT '' NOT NULL,
26 defaultdelivery varchar(255) DEFAULT '' NOT NULL,
27 quota varchar(255) DEFAULT '' NOT NULL,
28 CONSTRAINT id PRIMARY KEY (id)
29);</pre>
30</body>
31</html>