Re: Gist Index: Problem getting data in GiST Support Functions "penalty".

From: Radoslaw Smogura <rsmogura(at)softperience(dot)eu>
To: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>, <pgsql-general(at)postgresql(dot)org>
Cc: Michael Gould <mgould(at)intermodalsoftwaresolutions(dot)net>
Subject: Re: Gist Index: Problem getting data in GiST Support Functions "penalty".
Date: 2011-06-28 15:29:05
Message-ID: 20110628152909.E41DCB5DBE5@mail.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Basic question in Windows - Did you turned of UAC

-----Original Message-----
From: Adrian Klaver
Sent: 28 czerwca 2011 16:40
To: pgsql-general(at)postgresql(dot)org
Cc: Michael Gould
Subject: Re: [GENERAL] Gist Index: Problem getting data in GiST Support Functions "penalty".

On Monday, June 27, 2011 5:13:04 pm Michael Gould wrote:
> I am running 9.0.4 and I'm running it on Windows 7 Ultimate which is my
> development machine.
>
> I can't even create a server. When I try I get a message
>
>
> The server doesn't accept connections: the connection library reports
> could not connect to server: Connection refused (0x0000274D/10061) Is the
> server running on host "192.168.1.150" and accepting TCP/IP connections on
> port 5432?
>
> PostGres has been given access through the firewall on port 5432.
>
> My pg_hba.config file has the following line
>
>
> # TYPE DATABASE USER CIDR-ADDRESS METHOD
>
> # IPv4 local connections:
> host all all 0.0.0.0/0 trust
>
>
> I am just trying to get logged in at this point so I'm basically not trying
> to use any security.
>
> This is becoming a huge problem for me. I need to have the schema imported
> into the database by Thursday of this week when we are supposed to show off
> a new module in our product. We've not had any problems in other customer
> locations trying to get in.
>
> Any ideas?

What is listen_addresses in postgresql.conf set to?

If it is the default localhost then the above line should probably be:

host all all 127.0.0.1/32 trust

What is the connection string you are using to make the connection?

>
> Best Regards
>
> Michael Gould

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com

Browse pgsql-general by date

  From Date Subject
Next Message dennis jenkins 2011-06-28 16:09:52 Re: rationale behind quotes for camel case?
Previous Message Adrian Klaver 2011-06-28 14:40:16 Re: Gist Index: Problem getting data in GiST Support Functions "penalty".