binding tcp connections to certain addresses
От | will trillich |
---|---|
Тема | binding tcp connections to certain addresses |
Дата | |
Msg-id | 20011016125550.A18761@serensoft.com обсуждение исходный текст |
Список | pgsql-general |
i'm trying to get postgresql to listen on 127.0.0.1:5432, 192.168.1.1:5432 but not on xx.yy.zz.qq:5432 -- from the admin guide i see: VIRTUAL_HOST (string) Specifies the TCP/IP hostname or address on which the postmaster is to listen for connections from client applications. Defaults to listening on all configured addresses (including localhost). so i've tried # /etc/postgresql/postgresql.conf [snip] port = 5432 virtual_host = 127.0.0.1 virtual_host = 192.168.1.1 so then i restart the server-- root@debian-potato# /etc/init.d/postgresql restart Restarting PostgreSQL postmaster. Stopped /usr/lib/postgresql/bin/postmaster (pid 18685 18688 18689 18692 18751 18774 18776 18777 18778). -su: /etc/postgresql/postmaster.init: No such file or directory Starting PostgreSQL postmaster. /usr/lib/postgresql/bin/pg_ctl start -D /var/lib/postgres/data -l /var/log/postgres.log postmaster successfully started and the /var/log/postgres.log file shows FATAL 1: postgresql.conf:42: syntax error, token=".0" so i try using quotes: # /etc/postgresql/postgresql.conf [snip] port = 5432 virtual_host = "127.0.0.1" virtual_host = "192.168.1.1" which also doesn't work -- log shows: FATAL 1: postgresql.conf:41: syntax error, token=""" so how do i specify which interfaces/addresses postgres should listen to, and which it shouldn't? (i probably mis-read the documentation... nudges welcome.) -- They don't remember whether or not they weren't doing anything I didn't want them to do. -- Karen, on why she feeds the cats when they misbehave will@serensoft.com http://sourceforge.net/projects/newbiedoc -- we need your brain! http://www.dontUthink.com/ -- your brain needs us!
В списке pgsql-general по дате отправления: