Skip to content

Instantly share code, notes, and snippets.

View jamesridle's full-sized avatar

James Ridle jamesridle

View GitHub Profile
@tobz
tobz / steps.md
Last active March 8, 2026 18:54
Migrate Radarr from SQLite to Postgres

Migration steps

  1. Upgrade Radarr to at least v4.1.0.6133 or newer. This brings in support for Postgres. This will also ensure that all of your SQLite tables have the latest schema migrations applied before we migrate to Postgres. If you want to upgrade further, that's fine too, but make sure you've completed all upgrades first before continuing.
  2. Create your Postgres databases (one for the "main" database and one for the "logs" database) and configure Radarr with the relevant Postgres credentials. Both databases need to be owned by/accessible from the same Postgres user.
  3. Restart Radarr, and ensure it connects to Postgres and runs all schema migrations.
  4. Once all schema migrations have been applied, and no other activity is occurring, stop Radarr.
  5. Copy the SQLite databases from the Radarr instance/pod, both the main database and logs database. For this guide, we'll assume these files are called radarr.db and logs.db.
  6. Using pg_dump -s, dump the schema for the main Radarr database . P
@shaundomingo
shaundomingo / gist:43a32b72904d89f90d58
Last active October 28, 2018 18:28
CoreOS in anger - deploying a scalable wordpress cluster on CoreOS with fleet, docker and vulcand

CoreOS can seem daunting at first. This tutorial is built to encourage you in your journey and to demonstrate the power of this minimalistic operating system.

Exercise 1: Boot up a 3 machine coreos cluster

1a: Install prerequisite software

1b: Clone the coreos-vagrant repo

@anuragkh
anuragkh / elasticsearch-cmds
Last active April 8, 2016 19:18
Common elastic search commands
# ** List all indexes, all pretty-like
curl http://localhost:9200/_aliases?pretty=1
# ** Create an index, with specified settings
# Sample settings shown here; creates an index named "wiki"
# with 8 shards. Also creates a mapping called "articles"
# which specifies the index type for its properties ("text",
# "url" and "title") as "not_analyzed".
# See https://www.elastic.co/guide/en/elasticsearch/guide/master/index-doc.html
@pepoviola
pepoviola / key_to_json
Last active June 21, 2024 12:00
convert new lines into \n for use ssh key in json
sed ':a;N;$!ba;s/\n/\\n/g' my_key.pem
or in vi
:%s/\n/\\n/
https://tickets.opscode.com/browse/CHEF-3540
@md5
md5 / 00_README.md
Last active January 17, 2026 10:19
Demonstration Docker config for Wordpress on PHP-FPM behind Nginx

Proof of concept setup for Wordpress running under PHP-FPM with an Nginx frontend

Usage

Build a copy of this image:

git clone git://github.com/d9206eacb5a0ff5d6be0.git docker-nginx-fpm
cd docker-nginx-fpm
docker build -t nginx-fpm .
@digital-wonderland
digital-wonderland / README.md
Last active April 6, 2022 17:22
Unit files to deploy an ElasticSearch cluster on CoreOS via Fleet
@fatih
fatih / gist:cd1ee734803f27526f74
Created August 7, 2014 22:55
CoreOS Cloudformation with VPC
{
"AWSTemplateFormatVersion": "2010-09-09",
"Description": "CoreOS on EC2: http://coreos.com/docs/running-coreos/cloud-providers/ec2/",
"Mappings" : {
"RegionMap" : {
"ap-northeast-1" : {
"AMI" : "ami-19fba518"
},
@marktheunissen
marktheunissen / pedantically_commented_playbook.yml
Last active February 7, 2026 19:32 — forked from phred/pedantically_commented_playbook.yml
Insanely complete Ansible playbook, showing off all the options
This playbook has been removed as it is now very outdated.