[rt-users] postgres permission denied

Kevin Falcone falcone at bestpractical.com
Thu Jan 30 10:39:31 EST 2014


On Wed, Jan 29, 2014 at 08:33:41PM +0000, Thomas Krichel wrote:
> > Also - connecting as the rtuser may be insufficient to fix
> > permissions.  I suspect you actually need to run the acl fixes in RT
> > as the postgres user.
> 
>   What I had to do was to request the script explicitly to run as the
>   postgres user and authenticate with the postgres user password.
> 
> root at rt:~# sudo -u postgres /usr/sbin/rt-setup-database --action acl --dba postgres
> 
>   A test seems to suggest that the problem is gone, but I will 
>   keep a croned job to look at for a reoccurance of the problem.

That command definitely looks more correct.

I'm glad this sorted the problem.

-kevin
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 235 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20140130/6b55e3e3/attachment.sig>


More information about the rt-users mailing list