From: dailiming <ldai@accunettech.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Peter Eisentraut <peter_e@gmx.net>
Cc: Bruno Wolff III <bruno@wolff.to>
Cc: Rudi Starcevic <rudi@oasis.net.au>
Cc: pgsql-sql@postgresql.org
Subject: Re: How to configure two netcard for PostgreSQL?
Date: Mon, 31 Mar 2003 10:51:03 +0800
Message-ID: <00b901c2f730$5e9996d0$1f00a8c0@accunettech.com> (raw)
References: <Pine.LNX.4.44.0303281446470.2204-100000@peter.localdomain>
<009e01c2f720$febdc920$1f00a8c0@accunettech.com>
<13583.1049076928@sss.pgh.pa.us>
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@sss.pgh.pa.us>
To: "dailiming" <ldai@accunettech.com>
Cc: "Peter Eisentraut" <peter_e@gmx.net>; "Bruno Wolff III" <bruno@wolff.to>; "Rudi Starcevic" <rudi@oasis.net.au>; <pgsql-sql@postgresql.org>
Sent: Monday, March 31, 2003 10:15 AM
Subject: Re: [SQL] How to configure two netcard for PostgreSQL?
> "dailiming" <ldai@accunettech.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
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: ldai@accunettech.com, tgl@sss.pgh.pa.us, peter_e@gmx.net, bruno@wolff.to, rudi@oasis.net.au
Subject: Re: How to configure two netcard for PostgreSQL?
In-Reply-To: <00b901c2f730$5e9996d0$1f00a8c0@accunettech.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox