How to give root files permision to postgres
I've installed posgres on a ubuntu droplet. I have some files the I cloned to the root users account under the directory of mapnik/data. The exact file I am interested in is
/root/mapnik/data/world_merc.shp
When I log in as postgres and try to import this file from the root I get an error of "unable to open". The exact command I am using to import is
shp2pgsql -s 4326 -a /root/mapnik/data/world_merc.shp | psql -h localhost -d postgres -U
I am guessing this is because postgres cannot read from the root user's files? Any help to get this resolved