Re: connecting with pgAdmin II

What are your results for pg_ctl start and initdb ?

On your linux box check for the following -
Postmaster.pid (Do a locate first)

Make sure that you have the postgresql user into the shell script for
the user that you are using to log into the userbox.

Eg :

/home/linuxuser $ vi .bash_profile

postgrehost = IP address
postgreuser = username
postgrepass = passwd
postgreport = 5422 (If you are using default)
export postgrehost postgreuser postgrepass postgreport

login and logout for the shell script to work.

Hari

-----Original Message-----
From: pgsql-novice-owner(at)postgresql(dot)org
[mailto:pgsql-novice-owner(at)postgresql(dot)org] On Behalf Of Daniel Lerch
Sent: Wednesday, October 13, 2004 12:50 PM
To: pgsql-novice
Subject: [NOVICE] connecting with pgAdmin II

OK, I figured out my version problems and am now running pgAdmin II on
my Windows XP box to connect to my psql 7.2 database on my Linux box.
Can't quite get it to connect, though; I'm getting this error message:

"No pg_hba.conf entry for host 192.168.2.102, user bbontempo, database
daniel".

(yes, user name and database name exist and are correct, assuming it
wants the username/password for accessing the server itself, and the
name of an existing psql database)

I _think_ this error message means I need to get into the pg_hba.conf
file and create that entry (and I think pg_hba.conf is supposed to be in

the 'pgdata' directory). Unfortunately, I can find neither pg_hba.conf
(a 'whereis pg_hba.conf' gives me nothing) nor pgdata.

The help files in pgadmin II assume I know my way around Linux commands,

which I don't. So I'm stuck. Help!

=)
-d

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)