Re: How to configure two netcard for PostgreSQL?

From: "dailiming" <ldai(at)accunettech(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Peter Eisentraut" <peter_e(at)gmx(dot)net>, "Bruno Wolff III" <bruno(at)wolff(dot)to>, "Rudi Starcevic" <rudi(at)oasis(dot)net(dot)au>, <pgsql-sql(at)postgresql(dot)org>
Subject: Re: How to configure two netcard for PostgreSQL?
Date: 2003-03-31 02:51:03
Message-ID: 00b901c2f730$5e9996d0$1f00a8c0@accunettech.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I try again.
F.E:
First,I modified the pg_hba.conf cfg file.

host all 192.168.0.10 255.255.255.0 trust
host all 192.168.1.10 255.255.255.0 trust

Second, I used "/etc/rc.d/init.d/postgresql" to stopping the postmaster.
Finally, I restart the postmaster by "/usr/bin/postmaster -i -S -D /var/lib/pgsql/lib/data".

When I telnet 192.168.0.10 to connect database,I have the same results as before.

"psql -h 192.168.0.10 coredb " is failed.
"psql -h 192.168.1.10 coredb " is successed.

Why the first is failed?

thanks.

----- Original Message -----
From: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "dailiming" <ldai(at)accunettech(dot)com>
Cc: "Peter Eisentraut" <peter_e(at)gmx(dot)net>; "Bruno Wolff III" <bruno(at)wolff(dot)to>; "Rudi Starcevic" <rudi(at)oasis(dot)net(dot)au>; <pgsql-sql(at)postgresql(dot)org>
Sent: Monday, March 31, 2003 10:15 AM
Subject: Re: [SQL] How to configure two netcard for PostgreSQL?

> "dailiming" <ldai(at)accunettech(dot)com> writes:
> > Yes, I have already set the two Ip address in the pg_hba.conf file .
> > But It do nothing.
>
> No, what you need is to put in the addresses or address ranges of all
> the machines that will connect through either net card. (And don't
> forget to SIGHUP the postmaster after you change its config file.)
>
> The fact that there are multiple net cards doesn't matter at all;
> Postgres should bind to its port number on each of the machine's IP
> addresses, automatically.
>
> regards, tom lane
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2003-03-31 04:41:47 Re: How to configure two netcard for PostgreSQL?
Previous Message Tom Lane 2003-03-31 02:15:28 Re: How to configure two netcard for PostgreSQL?