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

[Mike James]

Haha, it's nice to have a laugh after beating my head against this most of the pm.

Well, I ran "make initialize-database" and it completed successfully. The rt4 database exists, as does rt_user. 
If I su to rt_user, I can do this:

[root at tracker ~]# su -l rt_user
[rt_user at tracker ~]$ psql -d rt4 -U rt_user
psql (9.2.1)
Type "help" for help.

rt4=> \q

As the postgres user, I GRANT'ed ALL PRIVILEGES ON DATABASE rt4 TO rt_user;

But apache still won't start :)

-----Original Message-----
From: Graeme Ruthven [mailto:graeme at kula.co.nz] 
Sent: Tuesday, October 16, 2012 5:32 PM
To: rt-users at lists.bestpractical.com
Cc: rt-users at lists.bestpractical.com; Mike James
Subject: Re: [rt-users] postgres 9.2.1, RT 4.0.5 - RT couldn't connect to database

On Tue, 2012-10-16 at 20:55 +0000, Mike James wrote:
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