Thread: pgaccess

pgaccess

From
Martin Zaunick
Date:
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




Re: pgaccess

From
terry@greatgulfhomes.com
Date:
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
>




Re: pgaccess

From
Oliver Elphick
Date:
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.



Re: pgaccess

From
ktt
Date:
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