no pg_hba.conf entry for host
От | - Barry - |
---|---|
Тема | no pg_hba.conf entry for host |
Дата | |
Msg-id | 000501c455ea$e264c6a0$2f01a8c0@Seka обсуждение исходный текст |
Ответы |
Re: no pg_hba.conf entry for host
|
Список | pgsql-cygwin |
This is in part a diary entry, since I'm no longer so enthused or optimistic about getting this to work, or whether it's practical for me. I reread some instructions I got on this list, and decided to give them a try. I configured Windows for an ODBC connection, possibly correctly. From the very start, it wasn't clear to me which user's account information needed to be used and altered, the Owner's or postgres's. The file pg_hba seemed to be configured to allow everything, according to the docs, so I didn't change it, but I got the fatal "no pg_hba.config entry" error. Then I tried creating a pg_hba.config file for the Owner's account, which I intend to access the database from. After I rebooted, permission was denied for the whole /var/postgresql/ folder for the user Owner, and I still got the fatal error. Then I went to the postgres user's account and saw that my edits to pg_hba.config weren't there, but I was able to edit the file, so I did. I rebooted, and still got the fatal error from both accounts. The only edit I made to /var/postgresql/ was to replace the "127.0.0.1" from "host all all 127.0.0.1 255.255.255.255 trust" with the IP address I saw in the error message. Maybe I needed to replace the mask too, but the only mask I saw at the command line was a subnet mask (255.255.255.0), not an IP-mask. In fact, I think there were two different ones, along with two different IP Addresses. I used the one under "Ethernet adapter local area connection." The other title and entries aren't there at the moment for some reason. Still seems like this should be easier. Since this is for a product I might sell, I think I should be looking at something more commercial that includes an installer to make it easier for others, even if I myself am masochistic. More likely, I'll use flat files. Wouldn't be so bad for my purposes anyway.
В списке pgsql-cygwin по дате отправления: