Postgres Pro
Downloads
Home   >   mailing lists

Thread: Lan Connection

Lan Connection

From
gambits
Date:
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

Re: Lan Connection

From
Neil Conway
Date:
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.

Re: Lan Connection

From
GH
Date:
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
>