jason@ubuntu-lxd01:~$ lxd sql "SELECT * FROM storage_pools_config;"
+------------+-----------------+------------+-------------------------+----------+
| id | storage_pool_id | node_id | key | value |
+------------+-----------------+------------+-------------------------+----------+
| 3 | 1 | 1 | source | local |
| 4 | 1 | 1 | volatile.initial_source | /dev/sdb |
| 5 | 1 | 1 | zfs.pool_name | local |
| 6 | 1 | 2 | source | local |
| 7 | 1 | 2 | volatile.initial_source | /dev/sdb |
| 8 | 1 | 2 | zfs.pool_name | local |
+------------+-----------------+------------+-------------------------+----------+
Oh sure, sorry - not sure why I assumed it’d just work…
jason@ubuntu-lxd03:~$ sqlite3 /var/snap/lxd/common/lxd/lxd.db .dump
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE schema (
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
version INTEGER NOT NULL,
updated_at DATETIME NOT NULL,
UNIQUE (version)
);
INSERT INTO schema VALUES(1,37,1523052307);
CREATE TABLE config (
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
key VARCHAR(255) NOT NULL,
value TEXT,
UNIQUE (key)
);
INSERT INTO config VALUES(2,'core.https_address','10.10.30.13:8443');
CREATE TABLE patches (
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
name VARCHAR(255) NOT NULL,
applied_at DATETIME NOT NULL,
UNIQUE (name)
);
INSERT INTO patches VALUES(1,'invalid_profile_names',1523052307);
INSERT INTO patches VALUES(2,'leftover_profile_config',1523052307);
INSERT INTO patches VALUES(3,'network_permissions',1523052307);
INSERT INTO patches VALUES(4,'storage_api',1523052307);
INSERT INTO patches VALUES(5,'storage_api_v1',1523052307);
INSERT INTO patches VALUES(6,'storage_api_dir_cleanup',1523052307);
INSERT INTO patches VALUES(7,'storage_api_lvm_keys',1523052307);
INSERT INTO patches VALUES(8,'storage_api_keys',1523052307);
INSERT INTO patches VALUES(9,'storage_api_update_storage_configs',1523052307);
INSERT INTO patches VALUES(10,'storage_api_lxd_on_btrfs',1523052307);
INSERT INTO patches VALUES(11,'storage_api_lvm_detect_lv_size',1523052307);
INSERT INTO patches VALUES(12,'storage_api_insert_zfs_driver',1523052308);
INSERT INTO patches VALUES(13,'storage_zfs_noauto',1523052308);
INSERT INTO patches VALUES(14,'storage_zfs_volume_size',1523052308);
INSERT INTO patches VALUES(15,'network_dnsmasq_hosts',1523052308);
INSERT INTO patches VALUES(16,'storage_api_dir_bind_mount',1523052308);
INSERT INTO patches VALUES(17,'fix_uploaded_at',1523052308);
INSERT INTO patches VALUES(18,'storage_api_ceph_size_remove',1523052308);
INSERT INTO patches VALUES(19,'devices_new_naming_scheme',1523052308);
CREATE TABLE raft_nodes (
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
address TEXT NOT NULL,
UNIQUE (address)
);
INSERT INTO raft_nodes VALUES(1,'10.10.30.11:8443');
INSERT INTO raft_nodes VALUES(2,'10.10.30.12:8443');
INSERT INTO raft_nodes VALUES(4,'10.10.30.13:8443');
DELETE FROM sqlite_sequence;
INSERT INTO sqlite_sequence VALUES('schema',1);
INSERT INTO sqlite_sequence VALUES('patches',19);
INSERT INTO sqlite_sequence VALUES('config',2);
INSERT INTO sqlite_sequence VALUES('raft_nodes',4);
COMMIT;
jason@ubuntu-lxd03:~$