postgres access over the web
On Digital Ocean
After much research I realized I had to create a specific user in the postgres DB to allow access from a linux user:
For Example postgres Database:
Tables: testtable (owner root)
have granted full access on all tables to user jim ( also have a linux user jim)
In linux I can su to user jim and log into the database and see table testtable.
When I attempt to run the query through the web browser it seems like the connection is failing. I have also created a postgis user called “www-data” and granted full access to the tables.
I assumed was the browser user is using as user www-data.
The questions I have are:
1) Am I correct in assuming that the web calls are made by “www-data”?
Much thanks in advance:
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.×