Re: TCP/IP database connection problem with pgaccess - Mailing list pgsql-interfaces

From Marc Blanc
Subject Re: TCP/IP database connection problem with pgaccess
Date
Msg-id 20020314083700.7b4e0a60.interlud@wanadoo.fr
Whole thread Raw
In response to TCP/IP database connection problem with pgaccess  ("Hong Jin" <h1jin@ucsd.edu>)
List pgsql-interfaces
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.


pgsql-interfaces by date:

Previous
From: Constantin Teodorescu
Date:
Subject: Re: pgaccess error
Next
From: Joep deVocht
Date:
Subject: Reset?