search

defvol / geobox

A virtual machine for geo stuff
3 stars 0 forks source link

Can't login with gisuser PGSQL role #17

Closed defvol closed 9 years ago

defvol commented 9 years ago

Perhaps we need the LOGIN keyword to enable connections with that role.

CREATE ROLE gisuser LOGIN;

See: http://www.postgresql.org/docs/current/static/sql-createrole.html

defvol commented 9 years ago

Didn't work. Tried adding and removing password as well. What works is passing a database and a host flag:

psql -U gisuser -h localhost -d gis