RT 4.4.3, postgresql database initialize failed


#1

Hello everybody,

I’m new user of RT environment, I done one installation with Mariadb database and all it’s Ok, but I need to do same installation with postgresql database and when I want initialized postgresql databse with command :“make initialize-database”, I have this messages: "Failed to connect to dbi:Pg:dbname=template1;host=localhost as user ‘postgres’: FATAL: Ident authentication failed for user “postgres"make: *** [initialize-database] Error 255”

For more information: my os is Red Hat 7.5, Postgresql 9.2.24 and
I follow this wiki :" https://rt-wiki.bestpractical.com/wiki/CentOS7Install#Initialize_the_database:" after had done the make install of RT

I changed file :" /var/lib/pgsql/data/pg_hba.conf " with: " local all all md5", restarted postgresql
and if I use command: " psql -U postgres -l " the result it’s ok, I think

[root@localhost rt-4.4.3]# psql -U postgres -l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
-----------±---------±---------±------------±------------±----------------------
postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +
| | | | | postgres=CTc/postgres
template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +
| | | | | postgres=CTc/postgres
(3 rows)

So, if you have an idea, where does my problem come from, I’m interested.

Thanks