Thread: 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
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 >
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