Home
The Toolkit for Online Communities
17477 Community Members, 1 member online, 1925 visitors today
Log In Register
OpenACS Home : Forums : OpenACS Q&A : Installing Postgres 7.2

Forum OpenACS Q&A: Installing Postgres 7.2

Icon of envelope Request notifications

Collapse
Posted by Andrew Zeon on
I'm about to install Postgres 7.2. Is there any difference between
installing 7.1.3 and 7.2? Would it be safe to follow the same
instructions that are posted for 7.1.3?
(http://openacs.org/doc/openacs-4/postgres.html)?

Thanks.

Collapse
Posted by defunct defunct on
I did with no problems :) So i guess the answer is yes
Collapse
Posted by Cathy Sarisky on
Yup, those directions work fine.  Do watch out, however, when you get to installing the OpenFTS driver.  The gotchas are fairly well documented down in the reader's comments section.
Collapse
Posted by Stan Kaufman on
FWIW if you're using Debian, woody installs PG 7.2.1 and this works fine with OACS 4.5. You don't need to compile PG yourself and you get to stay within Debian's incomparable upgrade system.
Collapse
Posted by Andrew Zeon on
Are there any dramatic differences between Postgres 7.2, 7.2.1 & 7.2.2? Which one works best on OACS 4.6?
Collapse
Posted by Stan Kaufman on
Too bad Don is off with the hawks this week; he usually seems to know most about all the inner goings-on with PG. I personally can vouch for 7.2.1 since that's in the current woody distro.

You can read about all the PG releases here: http://developer.postgresql.org/docs/postgres/release.html

Collapse
Posted by Ben Adida on
There is an unhappy functionality bug in 7.2 which makes 7.2.1 far nicer (sequence numbers go backwards after a crash). 7.2.2 fixes a couple of security bugs and doesn't require a dump/restore.

Check the details out at http:// postgresql.org/news.html

Collapse
Posted by Andrew Zeon on
So, 7.2.2 would be the best one to go for?
Collapse
Posted by Rafael Calvo on
Anrew

The one I installed at school is 7.2.1