I tried what Don said:
I get
RROR: pg_proc: Permission denied.
DROP
ERROR: Function 'tree_ancestor_keys(varbit, int4)' does not exist
Unable to identify a function that satisfies the given argument types
You may need to add explicit typecasts
CREATE
CREATE
create_user_col_comments
--------------------------
t
(1 row)
DROP
CREATE
NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index 'acs_function_args_pk' for table 'acs_function_args'
NOTICE: CREATE TABLE/UNIQUE will create implicit index 'acs_function_args_un' for table 'acs_function_args'
similar to what I get in the log when I tried to start it after deleting the db.
before this I just did:
dropdb mysite
createdb -U nsadmin mysite
createlang plpgsql mysite
other ideas?