PostgreSQL notes

From 17af0cfbc879299b4a5a063929b05ef042ca724e Mon Sep 17 00:00:00 2001 From: ivan Date: Tue, 6 Apr 1999 08:55:12 +0000 Subject: [PATCH] postgres notes --- htdocs/docs/install.html | 2 +- htdocs/docs/postgresql.html | 23 +++++++++++++++++++++++ 2 files changed, 24 insertions(+), 1 deletion(-) create mode 100755 htdocs/docs/postgresql.html 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:

A web server, such as Apache-SSL or Apache

SSH

Perl (at least 5.004_04) -

A database engine supported by Perl's DBI, such as MySQL or PostgreSQL +

A database engine supported by Perl's DBI, such as MySQL or PostgreSQL (see the PostgreSQL notes)

Perl modules

Array-PrintCols 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 @@ + + PostgreSQL notes + + +
PostgreSQL notes
+
+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. +
+Future versions of Freeside will keep all column names under 31 characters to +avoid this problem. +
+
+( 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 <ivan@sisd.com> ) +
+ + -- 2.11.0