Re: How to configure two netcard for PostgreSQL? - Mailing list pgsql-sql

"dailiming" <ldai@accunettech.com> writes:
> host all 192.168.0.10 255.255.255.0 trust
> host all 192.168.1.10 255.255.255.0 trust

Nonzeroes in the address where there are zeroes in the mask is a loser.
Try

host all 192.168.0.0 255.255.255.0 trust
host all 192.168.1.0 255.255.255.0 trust

Of course, you could replace both of these lines with

host all 192.168.0.0 255.255.254.0 trust
        regards, tom lane