From: | "Dann Corbit" <DCorbit(at)connx(dot)com> |
---|---|
To: | "Andrew Dunstan" <andrew(at)dunslane(dot)net> |
Cc: | <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Building Postgresql under Windows question |
Date: | 2009-04-28 21:48:02 |
Message-ID: | D425483C2C5C9F49B5B7A41F894415470296219D@postal.corporate.connx.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> -----Original Message-----
> From: Andrew Dunstan [mailto:andrew(at)dunslane(dot)net]
> Sent: Tuesday, April 28, 2009 2:27 PM
> To: Dann Corbit
> Cc: pgsql-hackers(at)postgresql(dot)org
> Subject: Re: [HACKERS] Building Postgresql under Windows question
>
>
>
> Dann Corbit wrote:
> > In this function:
> > static bool
> > test_postmaster_connection(bool do_checkpoint)
> >
> > This code will never succeed:
> > snprintf(connstr, sizeof(connstr),
> > "dbname=postgres port=%s connect_timeout=5",
> > portstr);
> >
> > for (i = 0; i < wait_seconds; i++)
> > {
> > if ((conn = PQconnectdb(connstr)) != NULL &&
> > (PQstatus(conn) == CONNECTION_OK ||
> > PQconnectionNeedsPassword(conn)))
> > {
> > PQfinish(conn);
> > success = true;
> > break;
> > }
> >
> >
> > Because pg_hba.conf has this:
> > # TYPE DATABASE USER CIDR-ADDRESS METHOD
> >
> > # IPv4 local connections:
> > host all all 127.0.0.1/32 trust
> > # IPv6 local connections:
> > host all all ::1/128 trust
> >
> > to allow connections from the local machine.
> >
> > (A password is not needed to connect, so the code always fails).
> >
> >
>
>
> Why won't
>
> PQstatus(conn) == CONNECTION_OK
>
> be true and thus the code will succeed without requiring a password?
It returns the value CONNECTION_STARTED
I have found a work-around for now.
If I set the method to password in pg_hba.conf, the service starts and
runs correctly.
It is only when the method is set to trust that we get 100% failures.
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Dunstan | 2009-04-28 21:58:39 | Re: Building Postgresql under Windows question |
Previous Message | Alvaro Herrera | 2009-04-28 21:38:40 | docs: mention autovacuum when ANALYZE is recommended |