Re: [otrs] Creating a postgres database

[peter McGregor]

On Saturday, February 28, 2004, at 03:29  AM, [EMAIL PROTECTED] 
wrote:

On Friday, February 27, 2004, at 05:01  AM, [EMAIL PROTECTED] 
wrote:

once the DB is created, login with user postgres and execute:

grant all on database otrs to otrs;


Thanks for the tip. I tried this command but its a postgres 7.3
command, not a 7.2 command
how about:
  grant all on otrs to otrs;
It complains about relation otrs not found

I'm not sure what the behaviour of 7.2 is, but I tested the situation 
with
7.4 and it allowed user otrs to create tables, etc.  ie, default
permission was open for the newly created 'otrs' db.

Is upgrading to 7.4.x out of the question?


I tried upgrading some time ago to postgres 7.3, but from what I can 
remember the rpm's wouldn't insert because of dependencies
in Redhat 7.3

We might try putting another box in though.

Thanks for your help

Peter McGregor

_______________________________________________
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
Support oder Consulting f�r Ihr OTRS System?
=> http://www.otrs.de/