http://www.trackplus.com/forum/posts/list/1.page JForum - http://www.jforum.net
1) In dbase\postgres\track-schema.sql, all refernces to the 'group' column should be 'thegroup'

2) Indbase\postgres\permissions.sql, the script needed the following additions:

GRANT ALL PRIVILEGES ON TATTRIBUTE TO friedj;
GRANT ALL PRIVILEGES ON TREPORTLAYOUT TO friedj;
GRANT ALL PRIVILEGES ON TWORKFLOW TO friedj;
GRANT ALL PRIVILEGES ON TPLISTTYPE TO friedj;
GRANT ALL PRIVILEGES ON TSITE TO friedj;
GRANT ALL PRIVILEGES ON TPROJECTTYPE TO friedj;

Just wanted to share our findings for those trying to use postgresql.

Thanks!]]> http://www.trackplus.com/forum/posts/preList/95/264.page http://www.trackplus.com/forum/posts/preList/95/264.page GMT
]]> http://www.trackplus.com/forum/posts/preList/95/277.page http://www.trackplus.com/forum/posts/preList/95/277.page GMT
1) In dbase\postgres\track-schema.sql, all refernces to the 'group' column should be 'thegroup'

2) Indbase\postgres\permissions.sql, the script needed the following additions:

GRANT ALL PRIVILEGES ON TATTRIBUTE TO friedj;
GRANT ALL PRIVILEGES ON TREPORTLAYOUT TO friedj;
GRANT ALL PRIVILEGES ON TWORKFLOW TO friedj;
GRANT ALL PRIVILEGES ON TPLISTTYPE TO friedj;
GRANT ALL PRIVILEGES ON TSITE TO friedj;
GRANT ALL PRIVILEGES ON TPROJECTTYPE TO friedj;

Just wanted to share our findings for those trying to use postgresql.

Thanks![/quote]
With regard to step #2, has something changed? I see no mention of a "friedj" user in the installation docs. The only user mentioned is "trackp", the owner of the database.]]> http://www.trackplus.com/forum/posts/preList/95/410.page http://www.trackplus.com/forum/posts/preList/95/410.page GMT
See:
http://www.trackplus.com/forum/posts/list/36.page]]> http://www.trackplus.com/forum/posts/preList/95/422.page http://www.trackplus.com/forum/posts/preList/95/422.page GMT With regard to step #2, has something changed? I see no mention of a "friedj" user in the installation docs. The only user mentioned is "trackp", the owner of the database.
[/quote]

No, not really. Since 3.2 the user manual has changed the database user from friedj to trackp. However, the privileges script still had friedj in there.

The name really doesn't matter, as long as it is the same here, in the Torque.properties file, and the database system.]]> http://www.trackplus.com/forum/posts/preList/95/431.page http://www.trackplus.com/forum/posts/preList/95/431.page GMT