一介資男 nczz

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

Simple WordPress Bulk Insert

A very simple function to perform bulk SQL inserts, since WPDB doesn't provide one directly. The aim is for simplicity - both in the function itself, and in using it - rather than being a massive beast which covers all possible incorrect usage scenarios. Provide it with clean, consistent data, and it should hopefully be able to do what you want without issue.

Notes:

Provide a table name and an array of associative arrays of rows to insert
Column names are pulled from the first row of data automatically
Make sure you provide the same fields in each row (there's no protection for this)
Data types (for WPDB placeholders) are auto-detected for each individual value (using is_numeric())
There is no protection for exceeding maximum query size (i.e. MySQL's max_allowed_packet); you could pre-batch into smaller "safe" chunks if you need to handle this case - or just find a better way to insert such a large amount of data

	nginx/
	!nginx/.gitkeep
	!nginx/logs/.gitkeep

	src/

	tmp/

	<?php

	class Math {

	/**
	* The base.
	*
	* @var string
	*/
	private static $base = '0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ';

	<?php
	class WP_HTML_Compression
	{
	// Settings
	protected $compress_css = true;
	protected $compress_js = true;
	protected $info_comment = true;
	protected $remove_comments = true;

	// Variables

	/**
	* requires node.js with ES6 support, or babel
	*/
	'use strict';

	const vm = require('vm');
	const fs = require('fs');

	const __loggers__ = {};
	function log(tag) {

	<?php
	$challenge = $_REQUEST['hub_challenge'];
	$verify_token = $_REQUEST['hub_verify_token'];

	// Set this Verify Token Value on your Facebook App
	if ($verify_token === 'testtoken') {
	echo $challenge;
	}

	$input = json_decode(file_get_contents('php://input'), true);

	<?php
	/**
	* Gravity Wiz // Gravity Forms // Advanced Conditional Logic
	*
	* PLEASE NOTE: This snippet is a proof-of-concept. It is not supported and we have no plans to improve it.
	*
	* Allows multiple groups of conditional logic per field.
	*
	* @version 0.1
	* @author David Smith <[email protected]>


	<!DOCTYPE html>
	<html lang="en">
	<head>
	<meta charset="UTF-8">
	<title>My FB Reactions Page</title>
	<style>
	html {
	box-sizing: border-box;
	width: 100%;

	<IfModule mod_rewrite.c>

	RewriteCond %{REQUEST_FILENAME} !-f
	RewriteCond %{REQUEST_FILENAME} !-d
	RewriteRule ^wp-content/uploads/(.*)$ http://www.example.com/wp-content/uploads/$1 [R=302,L,NC]

	</IfModule>

	# BEGIN WordPress
	# ----- WP generated code