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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-novice by date

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