Hello, I want to store the repository information into postgres and I installed Postgresql on my computer. Follow the turtorial, I configured server, port, username, password and database in Database tab of statistics gathering, but when I click the ‘Test connection’ button, what I can get is not ‘Tests passed’, but ‘Job table does not exists’. Is there any thing I can do to configure it properly.
Did you press the Create Database button first?
thinkboxsoftware.com/deadlin … a_Database
That should create the tables, and then you can confirm this by pressing Test Connection.
Cheers,
- Ryan
Thanks for your reply, rrussell, but It still doesn’t work when I click the ‘Create database’ button, what I can get is ‘ERROR:42704:role “postgres” does not exist’ and here ‘postgres’ is a database scheme which I created in my Postgres. Can you tell me what should I do and I just wondering whether Deadline5.2 is compatible with Postgres8.3 or is there any other databases that I can use?
Hmm, it appears there is a limitation (and likely it’s a bug) where the user name must match the database name (meaning there must be a role and a database in your postgress installation with the same name). Try creating a ‘postgres’ role and use that to create the database to see if that helps.
If it does, let me know, and I’ll log this as a bug.
Cheers,
- Ryan
Thanks, rrussel. It does work when I create a username with ‘postgres’ and use it to create a database named ‘postgres’. Thanks again