Skip to content

Instantly share code, notes, and snippets.

View DanielKotik's full-sized avatar
💭
I may be slow to respond.

Daniel Kotik DanielKotik

💭
I may be slow to respond.
View GitHub Profile
@DanielKotik
DanielKotik / summary.md
Last active October 3, 2024 14:08
Jupyter kernel for pipenv
@DanielKotik
DanielKotik / psql-error-fix.md
Created September 17, 2021 12:19 — forked from AtulKsol/psql-error-fix.md
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

# Install/update SOPS to latest on Fedora - https://github.com/mozilla/sops
echo "[+] Install/upgrade SOPS"
SOPS_VERSION=$(curl -s https://api.github.com/repos/mozilla/sops/releases/latest | jq .tag_name | tr -d '"')
dnf install -y https://github.com/mozilla/sops/releases/download/${SOPS_VERSION}/sops-${SOPS_VERSION}-1.x86_64.rpm
sops --version
# sops 3.2.0 (latest)
@DanielKotik
DanielKotik / merge_git_repo_as_subdir
Created February 15, 2022 09:55 — forked from smdabdoub/merge_git_repo_as_subdir
Merge one git repository into another repository as a sub-directory
# based on the following:
# http://saintgimp.org/2013/01/22/merging-two-git-repositories-into-one-repository-without-losing-file-history/
# http://blog.caplin.com/2013/09/18/merging-two-git-repositories/
git clone repo_main
git clone repo_sub
cd repo_main
git remote add repo_sub ../repo_sub
git fetch repo_sub
@DanielKotik
DanielKotik / 1_smime-clients.md
Created November 30, 2022 13:51 — forked from rmoriz/1_smime-clients.md
S/MIME is the industry standard for secure E-Mail and build into every relevant mail client. From Outlook to Thunderbird, from Blackberry to Apple Mail on OSX and iOS. http://smime.io/