Quiz: PostgreSQL

Question 4 of 10

Read the output

Why did student fail to log in to the shop database, even though it exists?

student:~$ psql -d shop -c 'SELECT 1'
psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  role "student" does not exist

There is no shop database on this server.
Over the socket, peer looks for a role named after the Linux user, and there is no student role.
The server is not listening on the socket.
student is not in the postgres group.

Back A–D or ↵ Sign in to answer