Invidious: psql: FATAL: Peer authentication failed for user "kemal"

[Niemand112233]

Hi,
while trying to install, I face this problem:
psql invidious kemal < /home/invidious/invidious/config/sql/videos.sql
psql: FATAL: Peer authentication failed for user "kemal"

what's wrong?

[omarroth]

Would you mind providing the commands you ran up to this point?

[m4teh]

Exactly the same issue. Following the installation instructions exactly yields the error.

[mavu]

your postgresql is configured for peer authentication by default,
you probably need to change the line in pg_hba.conf :

# "local" is for Unix domain socket connections only
local   all             all                                     peer

to

# "local" is for Unix domain socket connections only
local   all             all                                     trust

Alternatively you can use "md5" instead of "trust" and should be asked for a password.

[oleole39]

@mavu's solution worked for me on a Debian 9 install.

I found pg_hba.conf file at the following path /etc/postgresql/9.6/main/pg_hba.conf thanks to this trick:

To check location of pg_hba.conf connect to postgres db using psql then type SHOW hba_file; command.

[Vertux]

You can solve this issue by adding -h 127.0.0.1, then you are asked for the password of kemal:

psql invidious kemal -h 127.0.0.1 < /home/invidious/invidious/config/sql/playlist_videos.sql