PG Backup & Restore
pg_dump / pg_restore for PostgreSQL, right inside DBX
Restore
Backup
Connection
Saved connection
New connection…
Host
Port
User
Password
Remember password when saving this connection
PostgreSQL client tools
Bin directory
Restore
Target database
Dump file
No file selected
Browse or drop a .dump / .sql / .tar file here
Browse…
Options
Create database first
createdb
Skip owner & grants
--no-owner --no-privileges
Drop objects in the dump first
--clean --if-exists
Reset database
Drops ALL schemas (incl. public, CASCADE), recreates an empty public, then restores
Advanced
Parallel jobs
Applies to custom and directory archives.
Backup
Source database
Format
Custom (.dump) — compressed, restorable with pg_restore
Plain SQL (.sql) — readable, restorable with psql
Tar (.tar)
Directory — parallel dump, needs an output path
Content
Schema + data
Schema only
Data only
Options
Skip owner & grants
--no-owner --no-privileges
Include DROP statements
--clean --if-exists
Save to
You'll choose where to save when the backup starts.
Advanced
Parallel jobs
Directory format only.
Output
Idle
Clear
Output will appear here