Re: [GENERAL] Gist Index: Problem getting data in GiST Support Functions "penalty".
Basic question in Windows - Did you turned of UAC -Original Message- From: Adrian Klaver Sent: 28 czerwca 2011 16:40 To: pgsql-general@postgresql.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 (0x274D/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 DATABASEUSERCIDR-ADDRESSMETHOD > > # IPv4 local connections: > hostall 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: hostall 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.kla...@gmail.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
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 (0x274D/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 DATABASEUSERCIDR-ADDRESSMETHOD > > # IPv4 local connections: > hostall 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: hostall 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.kla...@gmail.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: OFF-TOPIC [GENERAL] Gist Index: Problem getting data in GiST Support Functions "penalty".
-Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Michael Gould Sent: Monday, June 27, 2011 8:13 PM To: 'pgsql-general@postgresql.org' Subject: Re: [GENERAL] Gist Index: Problem getting data in GiST Support Functions "penalty". I am running 9.0.4 and I'm running it on Windows 7 Ultimate which is my development machine. 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? >>>>>>>>>>>>>>>>>>> A) The message you have sent has nothing to do with the thread that you sent it on. B) You have not provided enough information for someone to even attempt a guess at what the problem may be. Specifically, your description of what machines and networks are involved is inadequate AND you do not provide the postgres.conf file contents for the server. You should probably start a new thread, with more information, to increase your chances of actually getting a response. David J. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Gist Index: Problem getting data in GiST Support Functions "penalty".
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 (0x274D/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 DATABASEUSERCIDR-ADDRESSMETHOD # IPv4 local connections: hostall 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? Best Regards Michael Gould -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general