Skip to content
This repository has been archived by the owner on Sep 19, 2024. It is now read-only.

Latest commit

 

History

History
39 lines (22 loc) · 1.11 KB

README.md

File metadata and controls

39 lines (22 loc) · 1.11 KB
Raw

Postgres Browser

Web shell to interact with PostgreSQL in the browser

⚡ Getting started

  1. Run npx serve and go to http://localhost:3000
  2. There is no step 2

🛠️ Update the filesystem

  1. Run the build process in the buildroot package

  2. Synchronize the new filesystem using:

./scripts/sync-fs.sh
  1. Cold boot and save a new snapshot

❄️ Cold boot and saving a new snapshot

  1. Go the http://localhost:3000?boot=true

  2. Once the boot is completed, clear the cache and start psql (the runtime assumes psql is running when it loads a snapshot): echo 3 > /proc/sys/vm/drop_caches && echo 3 > /proc/sys/kernel/printk && reset && psql -U postgres

  3. Save the state to a file clicking the Save state to file button

  4. Put the state file into the state folder and compress it using zstd:

zstd --ultra -22 state/v86state.bin && rm state/v86state.bin
  1. Go to http://localhost:3000, instant boot!