Load Your Own Data

The easiest way to copy data from another Postgres into ParadeDB is with the pg_dump and pg_restore utilities. These are installed by default when you install psql. This approach is ideal for quickly testing ParadeDB. See the deployment guide for how to deploy ParadeDB into production.

Creating a Dump

Run pg_dump to create a copy of your database. The pg_dump version needs be greater than or equal to that of your Postgres database. You can check the version with pg_dump --version. Below, we use the “custom” format (-Fc) for both pg_dump and pg_restore. Please review the Postgres pg_dump documentation for other options that may be more appropriate for your environment.

Replace host, username, and dbname with your existing Postgres database credentials. If you deployed ParadeDB within your VPC, the host will be the private IP address of your existing Postgres database.

pg_dump -Fc --no-acl --no-owner \
    -h <host> \
    -U <username> \
    <dbname> > old_db.dump

If your database is large, this can take some time. You can speed this up by dumping specific tables.

pg_dump -Fc --no-acl --no-owner \
    -h <host> \
    -U <username> \
    -t <table_name_1> -t <table_name_2> \
    <dbname> > old_db.dump

Restoring the Dump

Run pg_restore to load this data into ParadeDB. The pg_restore version needs be greater than or equal to that of your pg_dump. You can check the version with pg_restore --version.

Replace host, username, and dbname with your ParadeDB credentials.

pg_restore --verbose --clean --no-acl --no-owner \
    -h <host> \
    -U <username> \
    -d <dbname> \
    -Fc \
    old_db.dump

You’re ready to query your data. Explore ParadeDB’s query capabilities, or learn how to deploy to production.

Getting Started

Next Steps

Load Your Own Data

Creating a Dump

Restoring the Dump

​Creating a Dump

​Restoring the Dump

Creating a Dump

Restoring the Dump