pgaccess

By default I believe Postgres only accepts Unix socket connections. To
enable TCP/IP connections use the command line switch -i, else I believe
there is somewhere in the config file that one can enable TCP/IP
connections.

Terry Fielder
Network Engineer
Great Gulf Homes / Ashton Woods Homes
terry@greatgulfhomes.com

On Tue, 2002-07-09 at 01:07, Martin Zaunick wrote:

Hello list,

i have problems with pgaccess.

When i start pgaccess and open a database the follow error occur:

Error trying to database " on localhost PostgresSQL error message:
Connection to database failed
could not connct to server:
Is the server running on host localhost and accepting TCP/IP connections
on port 5432?"

What is the problem?

If you have anything (including 'localhost') in pgaccess' host field, it
will attempt to connect with TCP/IP, which your postmaster is not
accepting.

Erase the hostname and leave the field blank; then pgaccess will connect
through a Unix socket.

you can edit postgresql.conf
and insert

tcpip_socket=true

it is false by default.

ktt

--- terry@greatgulfhomes.com wrote:

By default I believe Postgres only accepts Unix
socket connections. To
enable TCP/IP connections use the command line
switch -i, else I believe
there is somewhere in the config file that one can
enable TCP/IP
connections.

Terry Fielder
Network Engineer
Great Gulf Homes / Ashton Woods Homes
terry@greatgulfhomes.com

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org]On

Behalf Of Martin Zaunick

Sent: Monday, July 08, 2002 8:07 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] pgaccess

Hello list,

i have problems with pgaccess.

When i start pgaccess and open a database the

follow error occur:

Error trying to database " on localhost

PostgresSQL error message:

Connection to database failed
could not connct to server:
Is the server running on host localhost and

accepting TCP/IP

connections
on port 5432?"

What is the problem?

Thanks and bye

Martin

_________________________________________________________

Do You Yahoo!?
Get your free @yahoo.com address at

http://mail.yahoo.com

---------------------------(end of
broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

---------------------------(end of
broadcast)---------------------------
TIP 2: you can get off all lists at once with the
unregister command
(send "unregister YourEmailAddressHere" to

majordomo@postgresql.org)

__________________________________________________
Do You Yahoo!?
Sign up for SBC Yahoo! Dial - First Month Free
http://sbc.yahoo.com