Hexy Templates

Postgres

The PostgreSQL object-relational database system provides reliability and data integrity.

Not yet tested database Based on TrueNAS app v1.5.32 (Postgres 18.6-trixie)
Project website TrueNAS app source Script on GitHub Report a problem
  1. 1
    Copy the script below
  2. 2
    In HexOS, open Apps, find Postgres and choose Custom Install
  3. 3
    Paste, then press Install — full guide with screenshots
postgres.json
Download 
1{
12  "version": 5,
23  "script": {
4    "version": "0.1.0",
5    "changeLog": "Auto-generated draft from TrueNAS postgres 1.5.32"
6  },
37  "installation_questions": [
8    {
9      "question": "User",
10      "type": "text",
11      "key": "user",
12      "required": true
13    },
14    {
15      "question": "Password",
16      "type": "password",
17      "key": "password",
18      "required": true
19    },
20    {
21      "question": "Database",
22      "type": "text",
23      "key": "database",
24      "required": true
25    }
26  ],
27  "requirements": {
428    "locations": ["ApplicationsPerformance"],
529    "specifications": ["2CORE"],
630    "permissions": ["READ_WRITE_LOCATIONS"],
731    "ports": [5432]
32  },
833  "ensure_directories_exists": [
34    {"path": "$LOCATION(ApplicationsPerformance)"},
35    {"path": "$LOCATION(ApplicationsPerformance)/postgres"},
36    {
37      "path": "$LOCATION(ApplicationsPerformance)/postgres/data",
38      "snapshot": {"id": "data"}
39    }
40  ],
41  "app_values": {
42    "postgres": {
943      "user": "$QUESTION(user)",
1044      "password": "$QUESTION(password)",
1145      "database": "$QUESTION(database)"
46    },
47    "storage": {
1248      "data": "$HOST_PATH($LOCATION(ApplicationsPerformance)/postgres/data)"
49    },
50    "network": {
1351      "tcp_port": {"bind_mode": "published", "port_number": 5432}
52    },
1453    "resources": {"limits": {"cpus": 2, "memory": "$MEMORY(10%, 4096)"}}
54  }
55}

What this script does

Hover or tap a box to see the lines it explains.

  1. Script format

    Tells HexOS this is a version 5 install script, so it knows how to read the rest.

    Line 2

  2. Script revision

    This copy of the script is revision 0.1.0. Latest change: “Auto-generated draft from TrueNAS postgres 1.5.32”.

    Lines 3–6

  3. Questions you'll be asked

    Before installing, HexOS will ask you for: User, Password and Database. Your answers are slotted into the settings further down wherever you see $QUESTION(...).

    Lines 7–26

  4. Storage locations it needs

    The app uses these HexOS storage locations: App storage (fast). If one isn't set up yet, HexOS will ask you to pick a place for it.

    Line 28

  5. Minimum hardware

    Recommended minimum: 2 CPU cores.

    Line 29

  6. Permission to use your folders

    Allows the app to read and write files inside the storage locations listed above — and nowhere else.

    Line 30

  7. Network ports

    The app needs port 5432 to be free on your server. A port is like an apartment number for your server's address.

    Line 31

  8. Folders created on install

    Creates the folders the app needs before it starts: App storage (fast) › postgres and App storage (fast) › postgres › data. Folders marked “snapshot” are included in HexOS snapshots, so you can roll them back.

    Lines 33–40

  9. Your answer: user

    Filled in with what you typed for “user” when you installed.

    Line 43

  10. Your answer: password

    Filled in with what you typed for “password” when you installed.

    Line 44

  11. Your answer: database

    Filled in with what you typed for “database” when you installed.

    Line 45

  12. Where the app's main data is saved

    Where the app's main data is saved on your server: App storage (fast) › postgres › data.

    Line 48

  13. Tcp port: 5432

    Publishes the app's tcp port as 5432.

    Line 51

  14. Resource limits

    Caps how much of your server the app can use: 2 CPU cores and 10% of your server's memory, but never more than 4 GB. This keeps one busy app from slowing everything else down.

    Line 53