Forum OpenACS Development: pg-9.0 final released today; some facts you might consider...

Collapse
1: pg-9.0 final released today; some facts you might consider...
Posted by Jim Lynch on 09/21/10 03:19 AM
In previous versions of openacs and pg, you would have to alter postgresql.conf so it sets some backwards-compatible settings, some of which are not available in 9.0.

One of those settings that has been removed, is having pg supply any missing from clause; this is now gone.

Another removed setting is regex_flavor, which is now permanently set to 'advanced'. I'm told there's a way to change that per regex; there should be some time to consult the docs for that.

Default_with_oids is still present at least in the default postgresql.conf produced by initdb, but not totally sure it does anything. The sentiment among pg devs is "something else to get rid of" and "if we didn't forget, it would be gone now". So if I were to make a suggestion it would be to rid ourselves of dependency on oids.

Question, what part of openacs is dependent on oids? Just the old ecommerce package?

Collapse
2: Re: pg-9.0 final released today; some facts you might consider... (response to 1)
Posted by Tracy Adams on 09/21/10 03:22 AM
IVC sponsored a project to make sure OpenACS is compatible with 4.0. The core modules were tested and the required changes identified. It's in Don's hands to review and then recommend how to get in OpenAcs.
Collapse
3: Re: pg-9.0 final released today; some facts you might consider... (response to 2)
Posted by Jim Lynch on 09/21/10 03:57 AM
Tracy, it's probably a lot of work to do all that; on the irc channel today it was suggested that someone test to see if openacs HEAD (would be 5.7?) would work with pg-9, so I built a copy of pg9 just to see how it would go... that's when I noticed the missing options in postgresql.conf.

Do you know if the identified/required changes included consideration of the removal of these three backwards-compatible settings?

-Jim

Collapse
4: Re: pg-9.0 final released today; some facts you might consider... (response to 3)
Posted by Kenneth Wyrick on 10/06/10 10:42 PM
I've tried to install https://openacs.org/xowiki/debian and it goes all the way but errors during the http://localhost:8000 configuration and after rebooting several times it fails to access pg9.

I figure this is what the 3 items you referenced about pg9 are about. Would you please give me steps to follow to correct this situation? I also hope that Tracy or someone else will update the script so that it works with lucid.

thanks.

Collapse
5: Re: pg-9.0 final released today; some facts you might consider... (response to 4)
Posted by Victor Guerra on 10/06/10 11:06 PM
Kenneth,

PG 9.0 is already supported on HEAD.

http://fisheye.openacs.org/changelog/OpenACS/?cs=MAIN:victorg:20101004215919

Just core packages though.

Collapse
6: Re: pg-9.0 final released today; some facts you might consider... (response to 4)
Posted by Jim Lynch on 10/09/10 03:26 AM
Kenneth, for at least openacs-5.5 you will want pg-8.3.