On Tue, 12 Mar 2002 11:00:00 -0800
"Hong Jin" <h1jin@ucsd.edu> wrote:
>I installed pgaccess and was able to bring up the interface. But when I try
>to open a database, I got an error message of "Error trying to connect to
>database databasename on host IPaddress. Is the server running on host
>...(host IP address or localhost) and accepting TCP/IP connections on port
>5432?".
See your "postgresql.conf" (for me it's in /var/lib/pgsql/data), you
must have these lines uncommented :
#
# Connection Parameters
#
tcpip_socket = true
#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 = ''
regards.