PGBR | PostgreSQL Backup & Restore

pgbr is a self-hosted tool built for developers who need reliable database backups. Manage your PostgreSQL backups with confidence by creating, restoring, migrating, and managing database backups using customizable flags and one-click operations directly from a clean web interface.

• Secure Connection Storage: Keep your database credentials safe with encrypted connection strings and masked UI displays.

• Full pg_dump/pg_restore Support: Gain complete control over your operations by configuring all native backup and restore flags directly through the interface.

• Automated Backups: Never miss a backup. Set up customizable cron jobs to automatically back up your databases on a schedule that works for you.

• Seamless Migrations: Easily migrate data from one PostgreSQL database to another with one-click data transfer tools.

Getting your own pgbr instance running is simple. All you need is Docker installed on your system.

Pull the latest image from Docker Hub.

Bash

docker pull darseen/pgbr:latest

Run the Docker container, mapping your volume, port, and setting your required environment variables:

Bash

docker run -d\
  -p 3000:3000\
  -v /path/on/your/machine:/var/lib/pgbr/data\
  -e AUTH_SECRET="your-secret-key"\
  -e BASE_URL="http://<your-server-ip>:3000"\
  --name pgbr\
  darseen/pgbr:latest

Once the container is running, you need to create your admin user to start managing your databases.

1. Navigate to your server's IP address on port 3000 in your web browser: http://<your-server-ip>:3000

2. You will be prompted to register. The first user to register automatically becomes the admin.

3. Log in, add your first PostgreSQL connection, and start managing your backups!

The following environment variables should be set for optimal security and configuration.

• PGBR_DATA: The path to your data directory.

• AUTH_SECRET: A secure, random string used to sign user sessions.

• BASE_URL: The base URL of your pgbr instance.

Here is a look at the pgbr interface.

Dashboard View

Backup Management Page

Migration Tool

Contributions are welcome! If you'd like to help improve pgbr by adding new flags, UI improvements, or features, please feel free to fork the repository, make changes, and submit a pull request.

This project is licensed under the MIT License. See the LICENSE file for details.