Re: Problems between Mandrake and pg

Hi

On Wednesday 21 November 2001 14:44, Ryan Rohde Hansen wrote:

> We are a group studying at Aalborg University. We are at the moment
> developing a postgresql-db (7.1.3) on Mandrake 8.0, which we intend to
> access via libpq. But at the moment we can't even connect to the db.
> The connection is refused and we are asked if the -i option has been set
> in the startup of postmaster:
>
> [01gr551(at)ika dbkode]$ ./test1
> Connection to host=localhost dbname=01gr551 failed, PQconnectPoll()
> -- connect()
> failed: Connection refused
> Is the postmaster running (with -i) at 'localhost'
> and accepting connections on TCP/IP port '5432'?
>
> The program we are running:
>
> #include <stdlib.h>
> #include <stdio.h>
> #include </usr/local/pgsql/include/libpq-fe.h>
>
> int main()
> {
>
> PGconn *conn;
> const char *connection_str = "host=localhost dbname=01gr551";

Try leaving out the "host=localhost" part of the above string.
If the backend process isn't accepting connections on a TCP/IP port,
specifying a host name (even if it's the name of the local machine)
forces a connect to the port, which causes the above error.

See also:
http://www.postgresql.org/idocs/index.php?postmaster-start.html#CLIENT-CONNECTION-PROBLEMS

HTH

Ian Barwick