Example userfile workflow

gistfile1.txt

-- Create database

create database mydb;
use mydb;
create table foo (i int primary key);
insert into foo select * from generate_series(1, 100);
create database backups;

-- Backup:
use backups;
backup database mydb to 'userfile://backups.userfiles/backup1' as of system time '-10s';

-- Get the backup:
cockroach userfile get --url $PGURL 'userfile://backups.userfiles/backup1' ~/backup1

-- Run a local cockroach node:
cockroach start-single-node --external-io-dir=~/backup1 --advertise-addr localhost --insecure &

-- Restore into the local cockroach node
restore database mydb from 'nodelocal://0/backup1';