[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

LSMB 1.2 supported on Pgsql 9



Hi all;

I am pleased to state that after an initial series of tests,
PostgreSQL 9 appears to work on LedgerSMB 1.2.x with no changes. The
latest production version is fully supported on PostgreSQL 9.

There is however one minor difference to be aware of if you are a
PostgreSQL administrator and running LedgerSMB 1.2:

PostgreSQL 9 comes with PLPGSQL standard in all new databases.  This
means that the PostgreSQL "superuser" (needed to create a new
database) doesn't need to be a true database superuser any more but
only needs permission to create new databases.  This is a significant
change and may affect plans to move to that platform either way.  This
has implications for security of the database cluster from a LedgerSMB
perspective but on the whole these are probably very positive.

Also it's worth noting that if this behavior is not desired due to
specifics of your deployment, you may want to drop the plpgsql
language from template1.

These changes will be reflected in the documentation of future versions.

Best Wishes,
Chris Travers