binding tcp connections to certain addresses

From: will trillich <will(at)serensoft(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: binding tcp connections to certain addresses
Date: 2001-10-16 17:55:50
Message-ID: 20011016125550.A18761@serensoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)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(at)serensoft(dot)com
http://sourceforge.net/projects/newbiedoc -- we need your brain!
http://www.dontUthink.com/ -- your brain needs us!

Browse pgsql-general by date

  From Date Subject
Next Message Gaurav Priyolkar 2001-10-16 18:02:49 Dynamically created tables [WAS Re: "Relation x does not exist" ...
Previous Message Mihai Gheorghiu 2001-10-16 17:26:22 User privileges