Re: Problems between Mandrake and pg

From: Ian Barwick <barwick(at)gmx(dot)net>
To: ryan(at)eidolon(dot)dk, Ryan Rohde Hansen <rrha00(at)control(dot)auc(dot)dk>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Problems between Mandrake and pg
Date: 2001-11-24 23:06:28
Message-ID: 200111242306.AAA00575@post.webmailer.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Ian Barwick 2001-11-25 17:01:54 Re: table permissions
Previous Message Ian Barwick 2001-11-24 22:46:27 Re: table permissions