pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
TCP/IP connection on PostGre 8.0
3+ messages / 3 participants
[nested] [flat]

* TCP/IP connection on PostGre 8.0
@ 2006-07-26 10:45  LiveShell <liveshell@gmail.com>
  0 siblings, 2 replies; 3+ messages in thread

From: LiveShell @ 2006-07-26 10:45 UTC (permalink / raw)
  To: 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???

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: TCP/IP connection on PostGre 8.0
@ 2006-07-26 10:49  Marcin Giedz <marcin.giedz@altvision.pl>
  parent: LiveShell <liveshell@gmail.com>
  1 sibling, 0 replies; 3+ messages in thread

From: Marcin Giedz @ 2006-07-26 10:49 UTC (permalink / raw)
  To: LiveShell <liveshell@gmail.com>; +Cc: 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

Attachments:

marcin.giedz.vcf (text/x-vcard, 276B) download begin:vcard fn:Marcin Giedz n:Giedz;Marcin org:AltVision Group;Network and New Technologies adr:;;Polna 11;Warszawa;;00-633;Polska email;internet:marcin.giedz@altvision.pl title:Director tel;work:+48 22 825 85 08 url:http://www.altvision.pl version:2.1 end:vcard
^ permalink raw reply [nested|flat] 3+ messages in thread

* Re: TCP/IP connection on PostGre 8.0
@ 2006-07-26 17:44  Ivo Rossacher <rossacher@bluewin.ch>
  parent: LiveShell <liveshell@gmail.com>
  1 sibling, 0 replies; 3+ messages in thread

From: Ivo Rossacher @ 2006-07-26 17:44 UTC (permalink / raw)
  To: pgsql-admin

Am Mittwoch, 26. Juli 2006 12.45 schrieb LiveShell:
> 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;

Are you connecting from an other host? This other host might not have access 
to your localhost address.

>     # defaults to localhost, '*' = any
> port = 5432
> #tcpip_socket = true

Uncommenting the above might help as well as starting the server with the 
option -i.

> 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

This are definitly not recommended values for production use. Chapter 19 of 
server documentation might be of interest here.
>
> 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???



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2006-07-26 17:44 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-07-26 10:45 TCP/IP connection on PostGre 8.0 LiveShell <liveshell@gmail.com>
2006-07-26 10:49 ` Marcin Giedz <marcin.giedz@altvision.pl>
2006-07-26 17:44 ` Ivo Rossacher <rossacher@bluewin.ch>

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