Dump, compare and check db integrity

database_magic.md

Database Backup and comparation

Dump Postgres DB

pg_dump --data-only --inserts -h <DB_URL> -U <DB_USER> -f <FILE_NAME_TO_CREATE.sql> <DB_NAME>

Notes:

• --data-only will dump only data to be inserted (not tables strcuture and relations)
• --inserts will force to use INSERT statements and not COPY to avoid driver issues later on

Generate dump hash

shasum -a 256 <FILE_NAME>

Compare differences

Old school way

diff <file_1> <file_2>

Fancy way (preview in VSCode)

code --diff <file_1> <file_2>