Get started

Search…

Get started

Get started with PostgreSQL backups.

Weap.io allows you to schedule backups for your PostgreSQL databases and to choose the storage location (AWS S3, Wasabi, DigitalOcean Spaces and Backblaze B2).
Our PostgreSQL backup solution comes with a default storage location of up to 250GB. That's in case you don't want to bring your own storage.
Thanks to the intuitive user interface, getting started with your first PostgreSQL backup is simple and fast.
1. Open Weap.io dashboard
Open your Weap.io dashboard and click on the Database Backups menu button. On the page just opened, click the button Add database.
2. Add a new server
If your server was already added previously, you can skip this step by clicking "Choose an existent server".
Weap.io needs to be able to connect to a server that can connect to your PostgreSQL database. It can be the server on which the database is hosted or simply another server. Next, you need to enter the server details:
Friendly name: a friendly name that will help you recognize the server later
Server user: the user that Weap.io will use to SSH into the server. It can be root or one specially created for Weap. If you need help creating a new user, check this guide.
Server IP or hostname: the IP or hostname of the server.
Server port: The SSH port of the server. The default one is 22.
After filling the details, click the button Next.
3. Add the SSH key to the server
If your server was already added previously, you can skip this step by clicking "Choose an existent server".
Weap.io generated a new SSH key for your server. The key must be added to your authorized_keys file. All the required instructions are already displayed during the setup process.
4. Connect to the database
If everything went ok with the previous step, Weap.io was able to SSH into your server. Now it's time to establish a connection with your PostgreSQL database. To be able to do that, you will need to enter the details of the database:
User: the user of the database. It can be root a one specially created for Weap. If you need help creating a new PostgreSQL user, check this guide.
Password: the password of the PostgreSQL user.
Host: the host of the database. If the database is stored on the same server added previously, it's localhost or 127.0.0.1. If the database is running on a remote server, the host will be the IP (or hostname) of that server.
Port: the port of the database, usually 3306.
5. Select the databases to backup
After successfully connecting to the database, Weap will show you a list of all databases available. You can select 1, more or all databases available. After selecting the databases, click the button Backup selected databases.
6. Conclusion
Congratulations! Your database is now automatically backed-up using the default retention policy and stored on your default storage location (the one provided by Weap if you didn't change it). 
Feel free to change the retention & frequency as needed.

Database backups - Previous

PostgreSQL backups

Auto-synchronize your PostgreSQL databases

Last modified 1yr ago

Copy link

Outline

1. Open Weap.io dashboard

2. Add a new server

3. Add the SSH key to the server

4. Connect to the database

5. Select the databases to backup

6. Conclusion