patmaddox

gcp_credentials: ENCRYPTED[!...!]

# custom-built instance with some packages pre-installed to save time
# otherwise use:
# freebsd_instance:
#   image_family: freebsd-13-0
# and install your packages
gce_instance:
  image_project: ratio-ops
  image_family: ratio-freebsd-13-1-ci

patmaddox

#!/bin/sh
set -e

# Adapted from https://www.daemonology.net/blog/2019-02-16-FreeBSD-ZFS-AMIs-now-available.html

if [ ! $# -eq 2 ]; then
  echo "Usage: configure.sh <cloud> <disk>"
  echo "    cloud: aws|gcp"
  echo "    disk: e.g. da1, nda1"
  exit 1

patmaddox

#!/bin/sh

# Adapted from https://www.daemonology.net/blog/2019-02-16-FreeBSD-ZFS-AMIs-now-available.html

if [ ! $# -eq 2 ]; then
  echo "Usage: configure.sh <cloud> <disk>"
  echo "    cloud: aws|gcp"
  echo "    disk: e.g. da1, nda1"
  exit 1
fi

patmaddox

ext_if="ena0"
ts_if="tailscale0"

set skip on lo
scrub in

# permissive NAT allows jail bridge and wireguard tunnels
nat on $ext_if inet from !($ext_if) -> ($ext_if:0)

block in

patmaddox

#!/bin/sh
set -e
set -x

# Adapted from https://www.daemonology.net/blog/2019-02-16-FreeBSD-ZFS-AMIs-now-available.html
# Note: You need to run this on an instance with read/write access to Google Compute
# Alternatively, you can run the gcloud commands from somewhere with privileges

disk=da1

patmaddox

pkg fetch -U -d -o ~/my_new_packages \
$(pkg info -R --raw-format json -F release_test-0.1.0.pkg | jq -r '.["deps"] | keys | join(" ")')

patmaddox

gce_instance:
  image_project: ratio-ops
  image_name: ratio-freebsd-13-1-ci-1657673300
  platform: freebsd
  zone: us-west1-a
  type: n1-standard-8

patmaddox

#!/bin/sh
# adapted from https://www.daemonology.net/blog/2019-02-16-FreeBSD-ZFS-AMIs-now-available.html

mdconfig -a -t swap -s 3G -u 2
newfs /dev/md2
mkdir /mdisk
mount /dev/md2 /mdisk
tar -czf /mdisk/base.txz --exclude .snap -C /mnt .
umount /mnt

patmaddox

postgres_service:
  container:
    image: postgres:14
      port: 5432
      POSTGRES_PASSWORD: ""

build_task:
  freebsd_instance:
    image_family: freebsd-13-1      
  build_script: echo "hello world"

patmaddox

CREATE TABLE users (id serial PRIMARY KEY NOT NULL, username text NOT NULL);
INSERT INTO users (username) VALUES ('admin');
INSERT INTO users (username) VALUES ('pat');

CREATE RULE no_delete_admin AS ON DELETE TO users WHERE username='admin' DO INSTEAD NOTHING;

SELECT * FROM users;
DELETE FROM users;
SELECT * FROM users;