Get started
Get started with PostgreSQL backups.
Last updated
Was this helpful?
Get started with PostgreSQL backups.
Last updated
Was this helpful?
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.
Open your Weap.io dashboard and click on the Database Backups menu button. On the page just opened, click the button Add database.
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.
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.
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.
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.
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.
