The Toolkit for Online Communities
17462 Community Members, 3 members online, 649 visitors today
Log In Register
OpenACS Home : Forums : OpenACS Q&A : Backups with OACS4-5 : One Message

Forum OpenACS Q&A: Response to Backups with OACS4-5

Posted by Tilmann Singer on
I think it is not the pg_dump ordering problem that shows up here (well, maybe that too) but the fact that in PG the function tree_ancestor_keys(varbit, integer) is not restorable. postgresql.sql executes create_tree_ancestor_keys(), so after calling it the function exists and the restore works fine.

Not that this would change anything - psql -f postgresql.sql does the trick.