Neon PostgreSQL

Prerequisites

• A SimpleBackups account.

• Access to your Neon database and permission to create new users/roles.

• Network access from SimpleBackups to your Neon database.

Step 1: Create a Backup User in Neon

1. Log in to your Neon dashboard.

2. Navigate to the database you wish to back up.

3. Click on “Overview” then “Connect” or just on the Dashboard, refer to “Connection Details”

4. Create a new user (or role) with RW or read-only access to the necessary database. This user will be used by SimpleBackups to connect to your database securely.

5. Copy the connection string (make sure you replace the **** by the actual password)

Step 2: Whitelist SimpleBackups IP Addresses

1. In the Neon dashboard, go to the "Project settings" then "IP Allow"

2. Add the IP addresses provided by SimpleBackups to the whitelist. This allows SimpleBackups to connect to your database.

Step 3: Create a New Database Backup on SimpleBackups

1. Navigate to the "Backups" section and click on "Create Backup."

2. Select "Database Backup."

3. You may use your own server to dump the backups, but we recommend the “serverless” option.

Step 4: Configure Database Backup Settings

1. Choose PostgreSQL as the database type.

2. Click “Paste connection string instead”

3. Fill in the complete connection string for your Neon database (make sure the password is added as well and not the asterisks *****)

4. Click “Validate Connection”

Step 5: Schedule and Customize Your Backup

1. Set a schedule for your backups according to your needs (e.g., daily, weekly).

2. Customize your backup settings, such as retention policies and storage.

Step 6: Save and Activate the Backup

1. Review your backup configuration to ensure all details are correct.

2. Save your backup configuration. SimpleBackups will automatically start the backup process according to your schedule.