Lan Connection

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