On 8/19/19 7:44 AM, stan wrote:
I am developinng an appliction usig Postgresql 11, installed on a UBUTU
18.14 machine.
I ahve vreated a new database to do some testing on restricting access of
specific users/roles to certain data. I have done the following:
REVOKE ALL ON DATABASE pertest FROM e
stan writes:
> But I cannot conect, or swith to user
> employee:
> stan@smokey:/etc/postgresql/11/main$ psql -U employee
> psql: FATAL: Peer authentication failed for user "employee"
This means that you've set pg_hba.conf to specify "peer" authentication,
which by default only lets you connect
