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.
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.
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_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
.
host
, username
, and dbname
with your ParadeDB credentials.