Backup y restauración en postgres

Camilo Nova
CEOA modo de guía rápida el comando para hacer un backup es:
PGPASSWORD=user_pass pg_dump -U user_name db_name -f filename --clean --no-owner
Para restaurarlo:
PGPASSWORD=user_pass psql -U user_name -d db_name -f filename
Written by Camilo Nova

With a deep passion for technology and a keen understanding of business, Camilo brings a fresh perspective to the intersection of technology, design, and business.