I'm in the process of doing an OpenACS install under LinuxPPC, with PG
7.02. I don't know if this is an OS-version specific issue, but I'll
mention it here so that others can see how I worked around. This has
also been entered in the SDM bug database.
1) load-geo-tables
Running this script successfully created the parents spec'd in
acs_geo_parents.sql, and then hung on looping through the *.ctl files.
I don't know much about PG as yet, but these ctl files seem to be of
the form:
COPY (TABLENAME) FROM stdin USING ... etc
... with the requisite data appended below. The sequence was hanging
waiting for input to stdin. I had a couple of goes at copying and
pasting, but that got old real quick. I'd be interested to know
whether this is the intended behaviour?
Workaround I used was to extract the data (plus EOF marker .) from
each ctl file into a separate appropriately named data file and I
change the ctl file's command to:
COPY (TABLENAME) FROM 'FILENAME' USING ... etc
... which then worked just fine.
2) load-data-model.sql
In order to have the entire sequence work with no errors, I had to
remove the comments at the end of all i directives that had them eg,
what was:
i general-permissions.sql -- much bigger for ACS 3.2.0
caused an error along the lines of:
"can't find file general-permissions.sql -- much bigger for ACS
3.2.0"
so I changed it to:
i general-permissions.sql
Again, I'm not sure whether this is OS-specific and whether the psql
parser treats tabs followed by -- differently elsewhere, but here it
treated everything after i as the filename to be picked up.
Hope this helps someone.
Regards
S.
