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.
/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.
[mailto:pgsql-novice-owner(at)postgresql(dot)org] On Behalf Of Daniel Lerch
Sent: Wednesday, October 13, 2004 12:50 PM
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
(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!
---------------------------(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)
In response to
pgsql-novice by date
|Next:||From: Tom Lane||Date: 2004-10-14 04:09:16|
|Subject: Re: VIEWs with aggregate functions |
|Previous:||From: David B.||Date: 2004-10-14 02:10:03|
|Subject: FW: [ pginstaller-Bugs-1000120 ] Install fails on NT4.0 Sp6|