Re: Lan Connection

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
>