i'm running a PSQL Database on server 1 (ip 1.0.0.1). (PSQL Version psql (PostgreSQL) 12.6 (Debian 12.6-1.pgdg100+1))
I try to connect to this Database from mantis server 2 (ip 1.0.0.2)
ip's only samples

Database is created and owner is set to "mantis"
also command
Code: Select all
GRANT ALL PRIVILEGES ON DATABASE mantis TO mantis;
Code: Select all
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
-----------+----------+-----------+---------+-------+-----------------------
mantis | mantis | SQL_ASCII | C | C | =Tc/mantis +
| | | | | mantis=CTc/mantis
Code: Select all
listen_addresses = '*'
Code: Select all
host mantis mantis 1.0.0.2/32 trust
Code: Select all
psql -h 1.0.0.1 mantis mantis
Code: Select all
Attempting to connect to database as admin BAD
Does administrative user have access to the database? ( Database connection failed )