If you're interested in trying out `pgmigrate dump`, consider going through the quickstart example --- it should give you a decent starting point https://github.com/peterldowns/pgmigrate/tree/main/example