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