Skip to content

Instantly share code, notes, and snippets.

View TheCrether's full-sized avatar
💯
workin'

Denis Imeri TheCrether

💯
workin'
View GitHub Profile
@dpmex4527
dpmex4527 / docker_svn-server.md
Last active September 5, 2024 10:03
Set up SVN server on docker
@AtulKsol
AtulKsol / psql-error-fix.md
Last active November 13, 2024 12:43
Solution of psql: FATAL: Peer authentication failed for user “postgres” (or any user)

psql: FATAL: Peer authentication failed for user “postgres” (or any user)

The connection failed because by default psql connects over UNIX sockets using peer authentication, that requires the current UNIX user to have the same user name as psql. So you will have to create the UNIX user postgres and then login as postgres or use sudo -u postgres psql database-name for accessing the database (and psql should not ask for a password).

If you cannot or do not want to create the UNIX user, like if you just want to connect to your database for ad hoc queries, forcing a socket connection using psql --host=localhost --dbname=database-name --username=postgres (as pointed out by @meyerson answer) will solve your immediate problem.

But if you intend to force password authentication over Unix sockets instead of the peer method, try changing the following pg_hba.conf* line:

from

@ptomato
ptomato / css.md
Created August 12, 2015 04:27
GTK CSS properties