Forum OpenACS Q&A: Installing Postgres 7.2

Posted by Andrew Zeon on 09/18/02 03:37 PM

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.

2: Response to Installing Postgres 7.2 (response to 1)

Posted by defunct defunct on 09/18/02 04:33 PM

I did with no problems :) So i guess the answer is yes

3: Response to Installing Postgres 7.2 (response to 1)

Posted by Cathy Sarisky on 09/18/02 04:37 PM

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.

4: Response to Installing Postgres 7.2 (response to 1)

Posted by Stan Kaufman on 09/18/02 04:44 PM

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.

5: Response to Installing Postgres 7.2 (response to 1)

Posted by Andrew Zeon on 09/18/02 05:39 PM

Are there any dramatic differences between Postgres 7.2, 7.2.1 & 7.2.2? Which one works best on OACS 4.6?

6: Response to Installing Postgres 7.2 (response to 1)

Posted by Stan Kaufman on 09/18/02 05:59 PM

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

7: Response to Installing Postgres 7.2 (response to 1)

Posted by Ben Adida on 09/18/02 06:02 PM

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

8: Response to Installing Postgres 7.2 (response to 1)

Posted by Andrew Zeon on 09/18/02 06:15 PM

So, 7.2.2 would be the best one to go for?

9: Response to Installing Postgres 7.2 (response to 1)

Posted by Rafael Calvo on 09/19/02 06:53 AM

Anrew

The one I installed at school is 7.2.1