Postgres Tricks
Log-the-frick-in sudo -u postgres psql dbname # typical root user psql -h localhost -U user -W dbname # default host is unix-domain (not tcp to localhost) More detail here. Create read-only user # login to …
ARTICLES
Articles
Why the hell can't I login to PostgreSQL?
Some possible reasons and solutions Wrong host Use the "-h" flag : psql -h localhost -U phisaver --password Wrong syntax Use -U and -W flags for user and password psql -U fred -W > prompts …
Periodic Emails with Django
Rough notes on meeting these requirements: Using Django Send weekly / daily emails to someone Log results Be robust and simple Packages Based on stars, maintenance, simplicity in 2021 post_office for emails: it may be …
Wordpress Setup (and Migration)
Wordpress: meh. But anyway: # # server1 # scp -r /var/html/www/sitey/ server2:. mysqldump sitey-db-name -u root -p > sitey-sql scp sitey-sql server2:. # # server2 # mv sitey /var/html/www/ # for nginx. owned by user …
Long Distance European Hiking... with a Tweenager
Gear Sleeping bag MD Ultra 500 (900g) has a probable EN rating of -8°C (limit) to 0°C (comfort). This was ok for me for all non-snow hiking. Sleeping outside in a bivy on snow was …
Energy Dashboards
Currently (2021) PhiSaver has one billlion data points. It's a bit hard to display in a single user dashboard. An efficient user dashboard should answer questions. This page charts my progress to the mythical perfect …
Energy Monitoring: Circuit Positives and Negatives!
Control Volume Switchboard Switchboard as control volume This is how I use a control-volume approach to practically monitor circuits. It's half maths and half "it's easy that way". The area below is a switchboard, monitored …
InfluxDB v2 (Flux) Setup for Energy and Power Data from Iotawatt
This are my notes on setting up InfluxDBv2 for storing Iotawatt power readings. Specifically I needed to: Transition a live site from InfluxDB1 to InfluxDB2 Setup InfluxDBv2 to use InfluxDBv1 api and auth, so that …
Raspi (Zero W or Rpi 4) router with wlan1 Wifi Dongle
Pi Zero There are a few options to do this. I used the official documentation and adapted it to create a script: https://gist.github.com/brettbeeson/4ecf4eb21b39f502a4c50bd1e196e90c On the Raspi Zero W, plug in a USB OTG adaptor and …
InfluxDB1 to InfluxDB2 with SSL
Install new Ubuntu 20 LTS on AWS (t3.medium). 't3 is better value than t2' (tried installing influxdb2 (auto upgrade from v1) then upgrade distro. Ok but influxdb crashed after upgrade.) Install InfluxDB2 using one big …
Enclosures for electronics and RF
Investigations into using ABS, polycarbonate and sheet metal enclosures to house electronics with a focus on getting that radio signal (wifi, 3G/4G) out of the box Requirements Weatherproof. IP66 = no dust and no water …
Robustel 3G Router Setup
Setting up a R1510-4L 3G router in Australia The setup is R1510-4L router with Telstra SIM card and Jasper web control. The goal is to setup the router on 3G and configure data allowances, etc. …