GideonMaina gideon-maina

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

Installing an Android ROM with your Mac via Heimdall and bash

Because every time I want to flash a new ROM, I forgot how I did it the last time.

This is how I re-flashed my unbranded Samsung Galaxy S4 (german black edition) with a stock ROM (because Cyanogenmod crashed my phone all the time). The correct Stock ROM for my Galaxy S4 is: I9505XXUHOJ2_I9505OXAHOJ2_I9505XXUHOJ2

Software you need

adb
heimdall (brew cask install heimdall-suite)

	#!/bin/sh

	psql -qX "$@" <<EOF
	\t on
	\timing off

	\echo 'Digraph F{'
	\echo 'ranksep=1.0; size="18.5, 15.5"; rankdir=LR;'

	SELECT

	import paho.mqtt.client as paho
	import os
	import socket
	import ssl
	from time import sleep
	from random import uniform
	import json

	import logging
	logging.basicConfig(level=logging.INFO)

	#!/bin/bash
	iatest=$(expr index "$-" i)

	#######################################################
	# SOURCED ALIAS'S AND SCRIPTS BY zachbrowne.me
	#######################################################

	# Source global definitions
	if [ -f /etc/bashrc ]; then
	. /etc/bashrc

	* LFCS Domains 2015.02
	Note - the domains will change somewhat in March 2015. SW RAID
	with mdadm will be removed

	** The Command Line
	*** Editing text files on the CLI
	Covers the use of the basic text editors nano and gedit as well
	as the advanced editors _vi_ and _emacs_
	- nano
	simple CLI-based text editor

	<!DOCTYPE html>
	<html>
	<head>
	<title>Leaflet Demo</title>
	<meta charset="utf-8" />
	<meta name="viewport" content="width=device-width, initial-scale=1.0">
	<link rel="stylesheet" href="http://cdn.leafletjs.com/leaflet-0.7.3/leaflet.css" />

	<link href='http://fonts.googleapis.com/css?family=Open+Sans:600' rel='stylesheet' type='text/css'>
	<style>

	function randomChoice(arr) {
	return arr[Math.floor(Math.random() * arr.length)];
	}

	#!/bin/bash
	### Setup a wifi Access Point on Ubuntu 12.04 (or its derivatives).

	### make sure that this script is executed from root
	if [ $(whoami) != 'root' ]
	then
	echo "
	This script should be executed as root or with sudo:
	sudo $0
	"

	#!/usr/bin/env python

	# Compare a file on S3 to see if we have the latest version
	# If not, upload it and invalidate CloudFront

	import fnmatch
	import os
	import boto
	import pprint
	import re