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!!
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? |