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