I've had these erros before when I started using ACS/pg, here's a quick recipe:
- Destroy the db and recreated it. Remember to be logged in as the AOLserver user when doing this. (destroydb yourdb and createdb yourdb)
- Go to the www/doc/sql directory, edit the postgres.sql to point to your pgsql libraries (it comes set up for the compiled version of postgres). If you don't have this, the datamodel will die.
- Edit the file load-data-model.sql and uncomment the line "--i postgres65.sql" if you have it. It should not be commented, but some people may have downloaded ACS/pg like this. To uncomment, remove the "--" in front of the line.
- Make sure the user your loading the datamodel as is a postgres superuser (otherwise it won't have authority to create some stuff needed for ACS/pg.
- Reload the data model. I usually do a "psql -f load-data-model.sql mydb 2> datamodel.txt" , the "2> datamodel.txt" dumps the output to a file that can I edit and see if the datamodel was loaded right, or if I missed some step. I will add this to the documentation.
- If you are using AOLserver 3bx, MAKE SURE you downloaded and compiled the enhanced driver available at acspg.benadida.com. You need the postgresql-devel package and gcc, glibc, glibc-devel to compile it.
Let us know how it goes.
Roberto Mello
