Search the Community
Showing results for tags 'postgresql r/o user'.
Found 1 result
-
Hi, i'm using postgresql and php - it's running fine I recently added a second database user (wambachr_osmuser) and granted r/o access to my tables. This userid/password will be visible to any user reading the php-script. But that is ok for me. Now i'm getting error "Warning: pg_connect(): Unable to connect to PostgreSQL server: FATAL: no pg_hba.conf entry for host "65.19.143.6", user "wambachr_osmuser", database "wambachr_osm", SSL off in ..." That is Tommies ip address and i think this should be added to pg_hba_conf too. Better using Tommys name instead of ip address, i think. BUT i'm not 100% shure if this is the correct way, and you may tell me a better solution. regards walter aka wambacher btw: "osm" stands for https://OpenStreetMap.org