Обсуждение: 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