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!
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 |