Forum OpenACS Q&A: pg_dump error with 3.2.5 (ecommerce module)?

Collapse
1: pg_dump error with 3.2.5 (ecommerce module)?
Posted by Stan Kaufman on 08/29/01 09:18 PM
Attempting a backup with a vanilla 3.2.5 installation (with Postgresql 7.0.3 -- I'm getting ready to upgrade to 7.1), I get this error: 
dumpRules(): SELECT failed for table ec_items_money_view.
Explanation from backend: 'pqReadData() -- backend closed
the channel unexpectedly. This probably means the backend
terminated abnormally before or while processing the request.'
I find nothing related to this searching the bboard archives here. Any ideas what's going on?

Many thanks for any help!

Stan

Collapse
2: Response to pg_dump error with 3.2.5 (ecommerce module)? (response to 1)
Posted by Stan Kaufman on 08/29/01 10:01 PM
OK, I found a clue: bug 968 (https://openacs.org/sdm/one-baf.tcl?baf_id=968).

Dropping the offending view permits a successful pg_dump.