DataImporter: Percona Operator for PostgreSQL¶
The everest-percona-pg-operator
dataimporter allows you to import backups taken using the Percona PostgreSQL Operator.
Prerequisites¶
-
Backup taken only using the Percona PostgreSQL operator stored in an S3-compatible storage bucket
Note
Backups created by other tools directly in an S3 bucket are not supported.
-
Credentials to access the S3 bucket (
AccessKeyID
andSecretAccessKey
)
How to import external PostgreSQL backups using the Percona Everest UI¶
This section outlines the step-by-step process for importing backups using the Percona Everest UI.
-
Log in to the Percona Everest UI.
-
From the Percona Everest homepage, click Import. Select the database type you want to import(MySQL, PostgreSQL, or MongoDB). The Basic Information page will be displayed.
-
Fill in the details on the Basic information page and click Continue. This will take you to the Import information page.
-
Select the
DataImporter
from the dropdown on the Import information page.-
Click Fill details to provide your S3 storage details. The S3 details page will open. Enter the following:
- Bucket name: Enter the unique name identifying your S3 storage bucket.
- Region: Select the geographical AWS region where your bucket is hosted (e.g., us-east-1, eu-west-1)
- Access key: Enter your AWS Access Key ID (like a username for API access).
- Secret key: Enter your AWS Secret Access Key (like a password for secure API access).
Click Save.
-
In the File directory section, specify the path within your S3 bucket where the backup files are stored. Click Save.
Important
Percona Everest does not validate file paths or verify the existence of files in the specified storage buckets. Make sure that the backup directory path is correct and accessible.
To verify that the specified path exists, you can use the AWS CLI:
aws s3 ls s3://<bucket-name>/<path-to-backup> --region <region>
Find the file path using AWS CLI
Find the file path using AWS CLI
Prerequisites: Ensure AWS CLI is installed and configured on your system. To install AWS CLI, refer to the AWS CLI installation guide.
-
Run the following command:
cat > ~/.aws/credentials [default] aws_access_key_id = SECRET aws_secret_access_key = SECRET
-
Navigate your S3 bucket structure:
# List the folders in the bucket aws s3 ls <S3 bucket-name> # Output PRE postgresql-nf9/ # List the subfolders: aws s3 ls <S3 bucket-name>/postgresql-nf9/ # Output PRE bd68c303-33eb-4368-b564-2cc4b9c71163/ # Drill down further: aws s3 ls <S3 bucket-name>/postgresql-nf9/bd68c303-33eb-4368-b564-2cc4b9c71163/ # Output PRE archive/ PRE backup/ # Go into the backup folder aws s3 ls <S3 bucket-name>/postgresql-nf9/bd68c303-33eb-4368-b564-2cc4b9c71163/backup/ # Output PRE db/ # Go into the db folder aws s3 ls <S3 bucket-name>/postgresql-nf9/bd68c303-33eb-4368-b564-2cc4b9c71163/backup/db/ # Output PRE 20250702-085755F/ PRE backup.history/ 2025-07-02 14:28:53 1174 backup.info 2025-07-02 14:28:53 1174 backup.info.copy The full file path for PostgreSQL will be: /postgresql-nf9/bd68c303-33eb-4368-b564-2cc4b9c71163/backup/db/20250702-085755F/
-
-
Click Continue. You will see the basic information page for your target database.
-
Enter the information and click Continue until you reach the end of the wizard.
Your backup import process will now start. Once the import is successful, the database status will eventually change to Up.