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

Re: TCP/IP connection on PostGre 8.0

From: Marcin Giedz <marcin(dot)giedz(at)altvision(dot)pl>
To: LiveShell <liveshell(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: TCP/IP connection on PostGre 8.0
Date: 2006-07-26 10:49:06
Message-ID: 44C748A2.6040400@altvision.pl (view raw or flat)
Thread:
Lists: pgsql-admin
LiveShell napisaƂ(a):
> Hi all,
Hi,
> 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
>
listen_addresses = '*' so PG can listen on localhost as well as external 
interfaces
>
> 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 <http://0.0.0.0> 0.0.0.0 <http://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.Connection refused . 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???
>
BR,
Marcin

Attachment: marcin.giedz.vcf
Description: text/x-vcard (275 bytes)

In response to

pgsql-admin by date

Next:From: Rodrigo SakaiDate: 2006-07-26 13:50:48
Subject: ROLES and PRIVILEGES
Previous:From: LiveShellDate: 2006-07-26 10:45:57
Subject: TCP/IP connection on PostGre 8.0

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