Re: How to configure two netcard for PostgreSQL?
От | dailiming |
---|---|
Тема | Re: How to configure two netcard for PostgreSQL? |
Дата | |
Msg-id | 00b901c2f730$5e9996d0$1f00a8c0@accunettech.com обсуждение исходный текст |
Ответ на | Re: How to configure two netcard for PostgreSQL? (Peter Eisentraut <peter_e@gmx.net>) |
Ответы |
Re: How to configure two netcard for PostgreSQL?
Re: How to configure two netcard for PostgreSQL? |
Список | 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@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 >
В списке pgsql-sql по дате отправления: