PostgreSQL on OpenWrt

PostgreSQL on OpenWrt is mostly like PostgreSQL on many Linux servers.

Move the database from volatile storage to persistent storage

The default location for the PostgreSQL database on OpenWrt is /var/postgresql/data which is on a RAM disk (tmpfs) and goes away on every reboot. We want to change that.

  1. Prepare your persistent storage and set it to automatically mount on every boot (fstab). For this guide we assume you mount the storage on /srv.
  2. service postgresql stop
  3. Edit /etc/config/postgresql so that `PGDATA` points to /srv/postgresql/data
  4. mv /var/postgresql /srv/
  5. service postgresql start
  6. Verify postgresql is running (E.g. via ps w / pgrep) and logread