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 ------------------------------------------------------------------------------ Start uncovering the many advantages of virtual appliances and start using them to simplify application deployment and accelerate your shift to cloud computing. http://p.sf.net/sfu/novell-sfdev2dev _______________________________________________ Ledger-smb-devel mailing list Ledger-smb-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
