Date: Mon, 29 Nov 1999 10:19:28 -0600
From: "Ross J. Reedstrom" <reedstrm@wallace.ece.rice.edu>
To: Bill Barnes <bbarnes@operamail.com>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: [INTERFACES] pgaccess on win95 connection
Message-ID: <19991129101927.A26895@wallace.ece.rice.edu>
References: <199911291058.FAA18015@smtp6.mindspring.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
In-Reply-To: <199911291058.FAA18015@smtp6.mindspring.com>;
	from Bill Barnes on Mon, Nov 29, 1999 at 10:59:48AM +0000

Hi Bill!
Welcome to the PostgreSQL world.

On Mon, Nov 29, 1999 at 10:59:48AM +0000, Bill Barnes wrote:
> Installed the rpm of 6.5.3 seemingly with success.  Can access template1
> with pgsql and pgaccess on a Mandrake 6.1 machine.  "ps ax | grep
> postmaster" reports the following:
>    551  ?                S            0:00  /usr/bin/postmaster -i
>    -S -D/var/lib/pgsql
>   1932 pts/1          S            0:00  grep postmaster

> '1932'  increments by 2 on each iteration of the ps command.   Don't

Hmm, seems you're a bit new to unix as well, eh? Don't worry about this,
it's just finding the process that's running the 'grep' command you typed.

> know enough about what I am doing to interpret this, but in executing
> pgaccess on the windows machine I get the following:

Windows, eh? So this is a different machine on the network.

> 
>    the connection window displays      localhost
>                                                            5432
>    I entered                                          template1
>                                                            postgres
>                                                            <password>
>    The connect error message is                      
>      Error trying to connect database "template1" on host localhost
> 
>      PostgreSQL error message:  Connection to database failed
>      connectDB() failed:  Is the postmaster running and accepting TCP/IP(with -i) connections
>      at 'localhost' on port '5432'?
> 

Right, because the machine postmaster is running on is _not_ localhost, but
rather the Linux box you mentioned up top. Replace 'localhost' with the
DNS name of that computer. Ah, back on the linux box, make sure you edit
pg_hba.conf to allow access from the Windows machine. You'll need to know
it's IP number. BTW, the 'ps' output above is useful to see that you _do_
have network access turned on for postgresql (the -i switch).

> Tried changing the port number.   It looks at least like we are getting to the database.  How do I ping the server?

Nope, you're never leaving the windows machine. As to ping, umm, did you try
'ping db_server.name'? ;-) But you won't need to, if you can get to the linux
box over the network at all, like with telnet. Puting the right hostname in,
and allowing access via the pg_hba.conf file (I'm not sure where the Mandrake
install puts it, sorry.) should fix you right up.

Hope this helps,
Ross
-- 
Ross J. Reedstrom, Ph.D., <reedstrm@rice.edu> 
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St.,  Houston, TX 77005