Skip site navigation (1) Skip section navigation (2)

connecting to postgresql

From: Sun H Chi <schi67(at)yahoo(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: connecting to postgresql
Date: 2004-09-16 17:54:37
Message-ID: 20040916175437.80242.qmail@web81709.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-novice
Hello,
 
I installed EMS postgres Admin (win) and I'm trying to connnect directly to the database (linux). I have specfied the host ip, default port 5432, and username(postgres), no password.  The server refused connection...I suspect it is because I have not set the configuration parameters for tcpip_socket = true in postgresql.conf.  The problem is...I can't locate this file anywhere on the server.  

This is the file/directory listing from the server. 
 
/FileX/postgresql
-rw-------    1 postgres postgres     8192 Oct 29  2002 pg_shadow
-rw-rw-rw-    1 postgres postgres       52 Oct 29  2002 pg_pwd
-rw-------    1 postgres postgres        0 Oct 29  2002 pg_group
-r--------    1 postgres postgres     3407 Oct 29  2002 pg_geqo.sample
-rw-------    1 postgres postgres        4 Oct 29  2002 PG_VERSION
drwx------    4 postgres postgres     4096 Oct 29  2002 base
-rw-------    1 postgres postgres     8192 Oct 30  2002 pg_database
-rw-r--r--    1 root     root         5254 Oct 30  2002 pg_hba.conf.old
-rw-r--r--    1 root     root         5254 Oct 30  2002 pg_hba.conf.new
-rw-r--r--    1 root     root         5251 Nov 11  2002 pg_hba.conf
drwxr-xr-x    3 postgres postgres     4096 Nov 11  2002 .
-rw-------    1 postgres postgres     8192 Sep 16 03:00 pg_variable
-rw-------    1 postgres postgres    49152 Sep 16 03:00 pg_log
drwxr-xr-x   13 root     root         4096 Sep 16 07:24 .

 
What do I need to do to connect the windows client to the database?
 
Thanks!!

Responses

pgsql-novice by date

Next:From: Josh BerkusDate: 2004-09-16 20:51:21
Subject: Re: connecting to postgresql
Previous:From: Kumar SDate: 2004-09-16 15:41:05
Subject: A generic question: Schema without foreign key specification?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group