Rebeca Sarai rsarai

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

[LINUX] Factorio Headless Server Guide

So, with credit to the Factorio wiki and cbednarski's helpful gist, I managed to eventually setup a Factorio headless server. Although, I thought the process could be nailed down/simplified to be a bit more 'tutorialised' and also to document how I got it all working for my future records.

The specific distro/version I'm using for this guide being Ubuntu Server 16.04.1 LTS. Although, that shouldn't matter, as long as your distro supports systemd (just for this guide, not a Factorio headless requirement, although most distros use it as standard now). The version of Factorio I shall be using is 0.14.20, although should work for any version of Factorio 0.14.12 and higher.

Just a note to newcomers: If there are any issues with the installation steps, people in the comments are doing a good job

Find out how much memory each of the jupyter notebooks running on a server is using. Helpful for knowing which ones to shut down.

Original code from http://stackoverflow.com/questions/34685825/jupyter-notebook-memory-usage-for-each-notebook

You'll need to

pip install tabulate psutil pandas requests

Using py.test is great and the support for test fixtures is pretty awesome. However, in order to share your fixtures across your entire module, py.test suggests you define all your fixtures within one single conftest.py file. This is impractical if you have a large quantity of fixtures -- for better organization and readibility, you would much rather define your fixtures across multiple, well-named files. But how do you do that? ...No one on the internet seemed to know.

Turns out, however, you can define fixtures in individual files like this:

tests/fixtures/add.py

import pytest

@pytest.fixture

Filter Queries - Example Use Cases

Here are a few example use cases, these use cases combine filter with other parameters to make useful API queries. The syntax for any of this may change between now, implementation, and release - they're meant as illustrative examples :)

Fetch 3 posts with tags which match 'photo' or 'video' and aren't the post with id 5.

api.posts.browse({filter: "tags:[photo, video] + id:-5", limit="3"});

GET /api/posts?filter=tags%3A%5Bphoto%2Cvideo%5D%2Bid%3A-5&limit=3

	from .models import Post, Category
	from .decorators import action_form


	class PostCategoryForm(forms.Form):
	title = 'Update category for the selected posts'
	myfile = forms.FileField()
	category = forms.ModelChoiceField(queryset=Category.objects.all())

	#!/usr/bin/env python
	import hashlib
	import hmac
	import time
	import requests
	import datetime

	# Q. Do you have A Websocket API?
	# A. Yes, and we strongly recommend you to use it. Please, check our JavaScript websocket implementation for our WebSocket API here:
	# https://github.com/blinktrade/frontend/blob/master/jsdev/bitex/api/bitex.js

	<?php
	/*
	This script exports user's starred articles via the official Inoreader API.
	Use it in case you have thousands of starred articles since Inoreader's export function will not export much more than 1000 articles.
	Use your Inoreader email and password to sign in.
	You will need to create a developer application first to obtain $app_id and $app_key. Read here about this - http://www.inoreader.com/developers/register-app
	*/

	$email = ""; // You Inoreader username or email
	$password = ""; // Your Inoreader password

	import sys
	import h5py

	def main():
	data = read()

	if sys.argv[1] == 'x':
	x_slice(data)
	elif sys.argv[1] == 'z':
	z_slice(data)

	/* Example adapted from http://www.drdobbs.com/database/differential-evolution/184410166
	*
	* This implements the DE/rand/1/bin optimization algorithm.
	*
	*/

	/* Initialize individuals */
	for (i=0; i<NP; i++) {
	/* randomly initialize all individuals */
	for (j=0; j<D; j++) {