[rt-users] postgres 9.2.1, RT 4.0.5 - RT couldn't connect to database

[Graeme Ruthven]

On Tue, 2012-10-16 at 20:55 +0000, Mike James wrote:
> Fresh install of Centos 6.3, fully patched. Added the postgresql repo
> and installed posgresql-9.2.1. RT 4.0.5 is config’d and looks ready to
> go. Just one last problem…
>  
> If I start the standalone rt-server (/opt/rt4/sbin/rt-server –port
> 8080), I can connect to RT and login as root without a problem.
> However, apache fails to start with the following error:
> 
> [root at tracker rt4]# service httpd start
> 
> Starting httpd: DBI connect('dbname=rt4;host=localhost','rt_user',...)
> failed: could not connect to server: Permission denied
> 
>        Is the server running on host "localhost" (::1) and accepting
> 
>        TCP/IP connections on port 5432?
> 
> could not connect to server: Permission denied

At the risk of teaching my grandmother to suck eggs, have you:
- created the PosetrgreSQL database rt4
- created the user rt_user and granted rights to rt4
- updated pg_hba.conf to suit?
- tested with "psql -u rt_user rt4"?

Regards
Graeme