pg_dump is a utility for backing up a PostgreSQL database. It makes consistent backups even if the database is being used concurrently.
pg_dump does not block other users accessing the database (readers or writers). Dumps can be output in script or archive file formats.
pg_dump -h localhost -U prisma -Fc prisma > customdumpfile