PostgreSQL

NitHost supports PostgreSQL 17 on the Databases page: creation, credentials, site env vars, tables, permissions, custom-format dump import/export, snapshots, and migration packages.

Who can use this page? Site Managers and Users with manage permission on the linked site.

Availability

If PostgreSQL is not available in the database picker, ask NitHost support whether it is enabled for your hosting service. Use the connection hostname and port provided by the panel; localhost usually points at your application container, not the database.

Create and connect

1. New Database → PostgreSQL
2. Name + optional site link
3. NitHost generates credentials and can add sensitive runtime DATABASE_URL + DB_NAME
4. Copy credentials; redeploy the app

Access model

• Separate owner role per database
• App logins: full access to that database or read-only
• Usernames unique across the cluster
• Database rename is not supported
• Read-only covers existing schemas and future tables in those schemas by the owner; reapply after adding schemas

Import and export

Direction	Format
Export Archive	PostgreSQL custom-format .dmp
Import Archive	.dmp / .dump from pg_dump --format=custom

Not accepted: plain SQL, MongoDB archives, gzip-wrapped uploads. Use PostgreSQL 17–compatible dumps.

Restore behavior:

• Export destination first
• Replaces objects in the archive; unrelated objects remain
• Single transaction; failure rolls back archive changes
• Source ownership/grants ignored; NitHost reapplies managed permissions
• Superuser-only ops or missing extensions fail rather than elevating privileges

Backups

• Link DBs to sites so scheduled backups include them
• Snapshots support safety backup + restore via normal snapshot flow
• Contact NitHost support before moving a complete site between hosting environments.

Related

• Create & link
• Import & export