Fixing the upgrade procedure of WebCalendar 1.2 for PostgreSQL 7.4

When trying to upgrade WebCalendar to 1.2, I fell on a series of errors due to the fact that the upgrade script relies on a dependency to PostgreSQL 8.1, which allows much more ALTER TABLE syntaxes than PostgreSQL 7.4. Nevertheless, there are ways to make it work by updating the upgrade script a little to suit the new syntax. I'm giving bits of code here, which are directly based on the www/install/sql/update-postgres.sql script, and altered to make it work. This script can be executed manually as many times as you want with the PostgreSQL user you use for Webcalendar.

Running PostgreSQL on Solaris 8

This article was first written in February 2004 for
the BeezNest technical website (http://glasnost.beeznest.org/articles/107)
The default values for Shared Memory in Sun's Solaris (starting from 2.6, at least) are set too low to run. Here is how to change it (see also PostgreSQL's Admin Guide, Managing Kernel Ressources): The relevant settings can be changed in /etc/system, for example: set shmsys:shminfo_shmmax=0x2000000 set shmsys:shminfo_shmmin=1 set shmsys:shminfo_shmmni=256 set shmsys:shminfo_shmseg=256 set semsys:seminfo_semmap=256 set semsys:seminfo_semmni=512

HOWTO Fully Install PostgreSQL on Debian

This article was first written in March 2005 for the BeezNest technical
website (http://glasnost.beeznest.org/articles/218).
This is a short tutorial on how to fully install PostgreSQL (with ready-to-use user accounts and test table) on a simple Debian installation. When not specified otherwise by the command line prefix or by a full statement, you are supposed to have root permissions.

The packages

To install the PostgreSQL base system as well as a textual client, you need to issue the following command
apt-get install postgresql postgresql-client
This will ins

PostgreSQL Autodoc

This article was first written in June 2004 for the BeezNest technical
website (http://glasnost.beeznest.org/articles/134).
PostgreSQL Autodoc is a powerful and useful tool to document a PostgreSQL database. It is written in Perl and generates several outputs. Using it is as simple as launching it with the name of the DB, and user and password to connect to it.