diff options
| author | ivan <ivan> | 1999-04-06 08:55:12 +0000 |
|---|---|---|
| committer | ivan <ivan> | 1999-04-06 08:55:12 +0000 |
| commit | 17af0cfbc879299b4a5a063929b05ef042ca724e (patch) | |
| tree | 57a02a9ddaac338048516aa930d54a1f9051c1b1 /htdocs | |
| parent | 1b8a83fba8cbe60b403fce17836c94170fa9c7f5 (diff) | |
postgres notes
Diffstat (limited to 'htdocs')
| -rw-r--r-- | htdocs/docs/install.html | 2 | ||||
| -rwxr-xr-x | htdocs/docs/postgresql.html | 23 |
2 files changed, 24 insertions, 1 deletions
diff --git a/htdocs/docs/install.html b/htdocs/docs/install.html index 90211884d..7aaad14ae 100644 --- a/htdocs/docs/install.html +++ b/htdocs/docs/install.html @@ -8,7 +8,7 @@ Before installing, you need: <li>A web server, such as <a href="http://www.apache-ssl.org">Apache-SSL</a> or <a href="http://www.apache.org">Apache</a> <li><a href="ftp://ftp.cs.hut.fi/pub/ssh/">SSH</a> <li><a href="http://www.perl.com/CPAN/doc/relinfo/INSTALL.html">Perl</a> (at least 5.004_04) - <li>A database engine supported by Perl's <a href="http://www.hermetica.com/technologia/DBI/">DBI</a>, such as <a href="http://www.tcx.se/">MySQL</a> or <a href="http://www.postgresql.org/">PostgreSQL</a> + <li>A database engine supported by Perl's <a href="http://www.hermetica.com/technologia/DBI/">DBI</a>, such as <a href="http://www.tcx.se/">MySQL</a> or <a href="http://www.postgresql.org/">PostgreSQL</a> (see the <a href="postgresql.html">PostgreSQL notes</a>) <li>Perl modules <ul> <li><a href="http://www.perl.com/CPAN/modules/by-module/Array/">Array-PrintCols</a> diff --git a/htdocs/docs/postgresql.html b/htdocs/docs/postgresql.html new file mode 100755 index 000000000..151081176 --- /dev/null +++ b/htdocs/docs/postgresql.html @@ -0,0 +1,23 @@ +<head> + <title>PostgreSQL notes</title> +</head> +<body> + <h1>PostgreSQL notes</h1> +<p> +PostgreSQL ships by default with a maximum of 31 character column names. If +you use arbitrary RADIUS attributes longer than 9 characters, fs-setup will +fail with `duplicate column' errors (in the part_svc table). +Solution: use a different database +engine, or recompile PostgreSQL with 64 character column names. +</p> +Future versions of Freeside will keep all column names under 31 characters to +avoid this problem. +</p> +<p> +( I've personally been unable to get PostgreSQL working with larger column names, +though the process does look like it should be straightforward. If anyone is +interested in assisting me with this, please get in touch. + -Ivan <a href="mailto:ivan@sisd.com"><ivan@sisd.com</a>> ) +</p> +</body> + |