From: | LiveShell <liveshell(at)gmail(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | TCP/IP connection on PostGre 8.0 |
Date: | 2006-07-26 10:45:57 |
Message-ID: | 928fe9b50607260345g293de5fbj88851541c0b8d2ae@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi all,
Follosing is the list of RPM installed on my FC4
postgresql-libs-8.0.8-1.FC4.1
postgresql-server-8.0.8-1.FC4.1
postgresql-docs-8.0.8-1.FC4.1
postgresql-8.0.8-1.FC4.1
postgresql-devel-8.0.8-1.FC4.1
And following is the contnet of the
===postgresql.conf file
#---------------------------------------------------------------------------
# CONNECTIONS AND AUTHENTICATION
#---------------------------------------------------------------------------
# - Connection Settings -
listen_addresses = 'localhost' # what IP interface(s) to listen on;
# defaults to localhost, '*' = any
port = 5432
#tcpip_socket = true
max_connections = 100
# note: increasing max_connections costs about 500 bytes of shared
# memory per connection slot, in addition to costs from shared_buffers
# and max_locks_per_transaction.
#superuser_reserved_connections = 2
#unix_socket_directory = ''
#unix_socket_group = ''
#unix_socket_permissions = 0777 # octal
#rendezvous_name = '' # defaults to the computer name
# - Security & Authentication -
#authentication_timeout = 60 # 1-600, in seconds
#ssl = false
#password_encryption = true
#krb_server_keyfile = ''
#db_user_namespace = false
=========== pg_hba.conf file
# TYPE DATABASE USER CIDR-ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all all trust
# IPv4 local connections:
host all all 0.0.0.0 0.0.0.0 trust
# IPv6 local connections:
host all all ::1/128 trust
But when I try to connect it using pgAdmin3 tool its giving erro :
"Error Connectiong to the server : coldnnot connect to
server.Connectionrefused . Is the Sserver running on host " ip add"
and accepting TCP/IP
conections on port 5432?"
the service staus is running.
And when i used : netstat -a . then only
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address Foreign Address
State
tcp 0 0 Portal:postgres *:*
LISTEN
Active UNIX domain sockets (servers and established)
Proto RefCnt Flags Type State I-Node Path
unix 2 [ ACC ] STREAM LISTENING 10315 /tmp/.s.PGSQL.5432
So Can any body tell me whts the prob with this?? why I am not able to
connect it on tcp ip port???
From | Date | Subject | |
---|---|---|---|
Next Message | Marcin Giedz | 2006-07-26 10:49:06 | Re: TCP/IP connection on PostGre 8.0 |
Previous Message | adey | 2006-07-26 02:17:17 | Re: Task/Jobs issue |