Re: TCP/IP database connection problem with pgaccess

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.