Forum OpenACS Q&A: Response to Running Postgres 7.0.3 and 7.1 on one box HOWTO

Collapse
Posted by Don Baccus on
Oh ... from reading your HOWTO it sounds like the only problem you had  was with the well-known ordering problem with functions that plagues the PG 7.0 (and older) pg_dump.  That's known and can be worked around easily enough, normally by just doing a psql -f postgresql.sql from the OpenACS and then ignoring the dupe define errors you get while restoring your dump.

I would *strongly* recommend that your samples not use /usr/local/pgsql, even though you explain that you'd installed your PG  7.0 elsewhere via the RPMs so had /usr/local/psql free.  If someone forgets and does a little cut-and-paste of your command snippets in order to run them they could easily hose their existing PG 7.0 installation if they installed from source...

There are a couple of minor English language type clean-ups that could be done but this is a draft so I imagine you'll be cleaning it up a little bit later, right?  Or do you want such comments (I'd pass them in e-mail rather than clutter up the bboard).