pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: LiveShell <liveshell@gmail.com>
To: pgsql-admin@postgresql.org
Subject: TCP/IP connection on PostGre 8.0
Date: Wed, 26 Jul 2006 16:15:57 +0530
Message-ID: <928fe9b50607260345g293de5fbj88851541c0b8d2ae@mail.gmail.com> (raw)

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

view thread (3+ messages)  latest in thread

Message-ID: <928fe9b50607260345g293de5fbj88851541c0b8d2ae@mail.gmail.com>
Permalink:  ../928fe9b50607260345g293de5fbj88851541c0b8d2ae@mail.gmail.com/
Also on:    postgresql.org/message-id/928fe9b50607260345g293de5fbj88851541c0b8d2ae@mail.gmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: liveshell@gmail.com
  Subject: Re: TCP/IP connection on PostGre 8.0
  In-Reply-To: <928fe9b50607260345g293de5fbj88851541c0b8d2ae@mail.gmail.com>
  References: <928fe9b50607260345g293de5fbj88851541c0b8d2ae@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox