Forum OpenACS Q&A: Re: sitemap broken after db import

Collapse
2: Re: sitemap broken after db import (response to 1)
Posted by Tilmann Singer on 04/19/03 04:35 PM
Before restoring a pg dump file from an openacs instance you have to load packages/acs-kernel/sql/postgresql/postgresql.sql manually, otherwise these tree_sortkey functions (and lots in oacs depends on them, this error is not the only one you will run into) won't be created.
Collapse
3: Re: sitemap broken after db import (response to 2)
Posted by Tom Lazar on 04/19/03 06:56 PM
tilmann,

does this mean, that i first need to initialise the local version using an empty oacs 4.6.2 and *then* run the abovementioned sql script and *then* import the dump?

or do i just run the script from the copied oacs installation?

and finally, do i 'run' that script by doing

psql tomsterorg < packages/acs-kernel/sql/postgresql/postgresql.sql

?

did i miss this bit somewhere in the documentation or is one just supposed to know?

thanks,

T.