On Fri, Sep 30, 2011 at 6:07 PM, David A. Bandel <[email protected]> wrote: > Folks, > > OK, have just "successfully" installed LedgerSMB-1.3.0-RC4.
Good to know, based on the feedback below. > > Methodology: > As I'm a glutton for punishment, decided to put up a new VirtualBox > install w/ Debian Wheezy. Basic install w/ only Apache2, > Postgresql-9.1.0, etc. ok. > > Started install. Had to backtrack and install: > postgresql-server-dev-9.1 and latex-make (this installs all > tetex-latex-recommended plus a little more) > > Had to install CPAN Module::Install module > > After that, all seemed to install (all CPAN modules d/l and installed). > > Now, it seems Postgresql has changed things around again. > > Previously, I would install the tablefunc, tsearch2, and pg_trgm > stored procedures into template1 and have them in any new db I > created. > > Well, the create-company script can not be used with postgresql-9.1.0 > until you've installed the new extensions. And apparently, installing > them in template1 does NOT insure they are installed in new dbs. That's interesting. > > What worked -- ran the create-company script once (lots of errors -- > missing all the stored procedures); used psql on the testinc database > and ran: create extension xyz; (xyz being the three stored procedures, > tablefunc, tsearch2, and pg_tgrm). Ran the create-company script > again -- only errors were "blah already exists". Success -- have all > stored procedures, tables, etc. I can think of two actual solutions here. tsearch2 can be omitted if you are on Pg 8.3 or higher. I am thinking about getting rid of the pg_trgm dependency since it is not currently exposed to the front-end and would probably be better handled by an add-on anyway. That leaves tablefunc. It seems we need some sort of compatibility routine for 9.1, maybe in Pg database creating the extension outside of a transaction? However, in trunk I have already gotten rid of *all* contrib dependencies, but the downside is it only runs on Pg 8.4 or higher. I am not sure we want to require Pg 8.4 for 1.3.0. Best Wishes, Chris Travers ------------------------------------------------------------------------------ All of the data generated in your IT infrastructure is seriously valuable. Why? It contains a definitive record of application performance, security threats, fraudulent activity, and more. Splunk takes this data and makes sense of it. IT sense. And common sense. http://p.sf.net/sfu/splunk-d2dcopy2 _______________________________________________ Ledger-smb-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
