Обсуждение: Lan Connection
Questions?? The SQL and Programming part are easy! But.. I can't connect to a database on the lan only on the local machine.. Scenario.. Created test DB called mydb Created table person w/ fields (name, address, city, state, zip) Inserted values into tables Table displays on local serves with Select query.. I want to run Postgres server on host Maintower then I want to connect to database mydb from host user Laptop TCP/IP and Named Resolution are up and running.... What syntax do I use ..? Bob T
On Sun, Feb 25, 2001 at 03:01:56PM -0500, gambits wrote:
> But.. I can't connect to a database on the lan
> only on the local machine..
[...]
> What syntax do I use ..?
Execute postmaster with the '-i' switch. From `man postmaster`:
-i Allows clients to connect via TCP/IP (Internet
domain) connections. Without this option, only
local Unix domain socket connections are accepted.
HTH,
Neil
--
Neil Conway <neilconway@home.com>
Get my GnuPG key from: http://klamath.dyndns.org/mykey.asc
Encrypted mail welcomed
Vegetarians do not love animals... they hate plants.
On Sun, Feb 25, 2001 at 03:01:56PM -0500, some SMTP stream spewed forth: > Questions?? > The SQL and Programming part are easy! > But.. I can't connect to a database on the lan > only on the local machine.. > Scenario.. > Created test DB called mydb > Created table person w/ fields (name, address, city, state, zip) > Inserted values into tables > Table displays on local serves with Select query.. > > I want to run Postgres server on host Maintower then > I want to connect to database mydb from host user Laptop > TCP/IP and Named Resolution are up and running.... > > What syntax do I use ..? Look at pg_hba.conf (in your pgsql/data directory). There are instructions in there for allowing access from non-local hosts by specifying allowed IP addresses. You would need something like the following to allow access from (all) other machines: host all trust or host all password gh > > Bob T >