Problem to connect to the Windows Port
От | Cornelia Boenigk |
---|---|
Тема | Problem to connect to the Windows Port |
Дата | |
Msg-id | 000901c486b5$07ebe840$0201a8c0@zwerg2000 обсуждение исходный текст |
Список | pgsql-general |
Hello everybody I have installed the Windows-Port on a the machine 'mini' in the local network. In postgresql.conf on mini listen_adresses is set to '*' When trying to connect to this installation from the machine 'mach1' I get the following error: conni@mach1 ~ $ psql -h mini -U postgres -d minitest psql: could not connect to server: Connection refused Is the server running on host "mini" and accepting TCP/IP connections on port 5432? I shut down the database server on mini and restarted it with the option -i. Then the error looks like this: conni@mach1 ~ $ psql -h mini -U postgres -d minitest psql: FATAL: no pg_hba.conf entry for host "192.168.1.2", user "postgres", data base "minitest" All these errormessages appear on both machines. The IP for mach1 is 192.168.1.2 The pg_hba.conf on mini contains the entries: host all all 192.168.1.2 192.168.255.255 password host template1 postgres 192.168.1.2 192.168.255.255 password host minitest postgres 192.168.1.2 192.168.255.255 password Do I miss something? Any help is appreciated. Regards Conni
В списке pgsql-general по дате отправления: