Обсуждение: Allowing TCP/IP connections

In the postgres configuration file, which options do I have to enable to
allow TCP/IP connections:

#
#       Connection Parameters
#
#tcpip_socket = false
#ssl = false

#max_connections = 32 # 1-1024

#port = 5432
#hostname_lookup = false
#show_source_port = false

#unix_socket_directory = ''
#unix_socket_group = ''
#unix_socket_permissions = 0777

#virtual_host = ''

#krb_server_keyfile = ''

I think this may have been answered earlier do to mailing list oddities, but
just in case:

Change this:

#tcpip_socket = false

to this:

tcpip_socket = true

You may also need to make some changes in pg_hba.conf to authorize the
connection from a particular host. Although this page is aimed at JDBC folk,
you'll find a description of setting up the database for tcp/ip connections
in it that applies to most situations:

http://www.fankhausers.com/postgresql/jdbc/#tcpip

-Nick

tcpip_socket=1 worked for us...


----- Original Message -----
From: "Marc" <syn_uw@www2.us.postgresql.org>
To: <pgsql-admin@postgresql.org>
Sent: Monday, December 31, 2001 6:24 AM
Subject: [ADMIN] Allowing TCP/IP connections


> In the postgres configuration file, which options do I have to enable to
> allow TCP/IP connections:
>
> #
> #       Connection Parameters
> #
> #tcpip_socket = false
> #ssl = false
>
> #max_connections = 32 # 1-1024
>
> #port = 5432
> #hostname_lookup = false
> #show_source_port = false
>
> #unix_socket_directory = ''
> #unix_socket_group = ''
> #unix_socket_permissions = 0777
>
> #virtual_host = ''
>
> #krb_server_keyfile = ''
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>

I think this may have been answered earlier due to mailing list oddities,
but
just in case:

Change this:

#tcpip_socket = false

to this:

tcpip_socket = true

You may also need to make some changes in pg_hba.conf to authorize the
connection from a particular host. Although this page is aimed at JDBC folk,
you'll find a description of setting up the database for tcp/ip connections
in it that applies to most situations:

http://www.fankhausers.com/postgresql/jdbc/#tcpip

-Nick