Forum OpenACS Q&A: load of data model fails with suse7.1, openacs 3.2.5, aolserver3.4, pg7.1.1

Collapse
1: load of data model fails with suse7.1, openacs 3.2.5, aolserver3.4, pg7.1.1
Posted by Ebow Halm on 05/18/01 10:21 PM
I'm installing openacs 3.2.5 on a suse linux 7.1 system with aolserver
3.4, postgresql 7.1.1.  When I try to load the datamodel I get an
error at psql:homepage.sql:373 "pgReadData() backend closed channel
unexpectedly" and the postgres server dies and restarts.  When I log
into psql I can see the database with 216 tables created but I'm
unsure if those are all the tables.

It aborts each time at the same function hp_get_filesystem_root_node

Collapse
2: Response to load of data model fails with suse7.1, openacs 3.2.5, aolserver3.4, pg7.1.1 (response to 1)
Posted by Don Baccus on 05/18/01 10:55 PM
This is a bug in PG 7.1.1.  For now, go back to PG 7.1.  I don't know why the PG group doesn't have a big warning on their web page about this problem with PG 7.1.1.  It's minor (a select returning no rows in PL/pgSQL crashes the backend) and can't hurt your data etc etc but lots of people have run into it.

PG 7.1.2 is due out very shortly, and of course will have this problem  fixed.

Collapse
3: Response to load of data model fails with suse7.1, openacs 3.2.5, aolserver3.4, pg7.1.1 (response to 1)
Posted by David Kuczek on 05/18/01 11:36 PM
If you want really want to compile and install 7.1.1 today, you should check out this thread...

It worked fine for me. I haven't heard anyone talking on the pg-hackers list about 7.1.2 the last couple days...