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.
Create a Dump
Runpg_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.Restore the Dump
Runpg_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.