SEC.01
The playbook
The run starts read-only: the recon probes decide what happens next. The steps that follow are adapted to the distribution and state found — a real machine is rarely clean.
- 01recondistribution, version and package manager (apt or dnf)
- 02reconversion (server_version_num), data_directory, config_file and hba_file of the running cluster
- 03recontimescaledb already preloaded?
- 04reconextension already enabled in the database? does the database exist?
- 05reconTimescale / PGDG repositories present?
- 06actAdd the Timescale repositoryverify
- 07actInstall the packageverify
- 08actConfigure postgresql.confverify
- 09actRestart PostgreSQL (brief interruption)destructiveverify
- 10actEnable the extensionverify
SEC.02
What it verifies
Each step ships its own check. The run only moves on when the check passes, so what the recipe reports as done is what is actually on the server.
- 01verifyAdd the Timescale repositoryVerified by
ls /etc/apt/sources.list.d/timescaledb.list /etc/yum.repos.d/timescale_timescaledb.repo 2>/dev/null | head -1 - 02verifyInstall the packageVerified by
ls /usr/lib/postgresql/*/lib/timescaledb.so /usr/pgsql-*/lib/timescaledb.so 2>/dev/null | head -1 - 03verifyConfigure postgresql.confVerified by
grep -E '^shared_preload_libraries' <config_file> - 04verifyRestart PostgreSQL (brief interruption)Verified by
sudo -u postgres psql -tAc 'select 1' - 05verifyEnable the extensionVerified by
sudo -u postgres psql -d '${database}' -tAc "select extname from pg_extension where extname='timescaledb'"
SEC.03
Guardrails
Non-negotiable instructions the run must respect, whatever it finds on the server.
PostgreSQL is required — if missing, stop and suggest install-postgres. The package must match the server’s major version. Back up postgresql.conf before timescaledb-tune. Do not modify any existing data.
SEC.04
Variables
What you choose before launching — the recipe fills in the rest.
| Name | Meaning |
|---|---|
| ${database} | Database to enable the extension in |
SEC.05
How a recipe runs in Servor
Servor is zero-knowledge: the platform cannot execute anything on its own. When you launch this recipe, a run reads the reconnaissance, plans the steps and asks for your approval. Each approved command is signed by your browser — with a key the server never sees — then relayed verbatim to the agent, which verifies the signature locally before executing.
search by intent — type “firewall”, get ufw
- 01Read-only reconnaissance before any change
- 02Every command signed by your browser, approved by you
- 03Each step verified before the run moves on, every run kept in the history
SEC.06
Deploy on Servor button
Maintain TimescaleDB or a project that needs it? Put this button in your README or on your site: one click and your users install it on their own server.
SEC.07
More database recipes
- 01PostgreSQLPostgreSQL (major version of your choice) from the official PGDG repository, initialized and verified.
- 02MySQLMySQL Server, secured, bound to localhost, started and verified.
- 03MariaDBMariaDB, secured, bound to localhost, started and verified.
- 04MongoDBMongoDB Community 9.0, local, with authentication enabled and verified.
- 05RabbitMQRabbitMQ broker (official repository) with management, local and a dedicated admin account.
Verified recipe
Run this recipe on your server
Connect a server, launch the recipe, and approve each step as Servor executes and verifies it. Free plan, no card required.