Utility that gives ability to call pg_dump and pg_restore from nodejs with all parameters. Please see the pg_dump and pg_restore documentation for details on the arguments. execa for details on the output streams.
import { pgDump, pgRestore } from "pg-dump-restore";
async function main() {
const { stdout, stderr } = await pgDump(
{
port, // defaults to 5432
host,
database,
username,
password,
},
{
file: "./dump.sql",
format, // defaults to 'custom'
},
); // outputs an execa object
}import { pgDump, pgRestore } from "pg-dump-restore";
async function main() {
const { stdout, stderr } = await pgRestore(
{
port, // defaults to 5432
host,
database,
username,
password,
},
{
filename: "./dump.sql", // note the filename instead of file, following the pg_restore naming.
clean, // defaults to false
create, // defaults to false
}
); // outputs an execa object
}The excludeTableDataPattern command allows excluding data from one or more tables during an operation. It can receive an array of names or patterns to specify the tables to be excluded. This option is useful when you only need the definition of a particular table but do not require the data it contains.
import { pgDump, pgRestore } from "pg-dump-restore";
async function main() {
const { stdout, stderr } = await pgDump(
{
port, // defaults to 5432
host,
database,
username,
password,
},
{
file: "./dump.sql",
format, // defaults to 'custom'
excludeTableDataPattern: ["table1", "table2"]
},
); // outputs an execa object
}