Re: Lan Connection

From: GH <grasshacker(at)over-yonder(dot)net>
To: gambits <rjtalbo(at)attglobal(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Lan Connection
Date: 2001-02-25 20:56:43
Message-ID: 20010225145643.A33918@over-yonder.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-02-25 21:38:49 Re: CGI Help
Previous Message Neil Conway 2001-02-25 20:40:31 Re: Lan Connection