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
As the Axiacore CEO, Camilo writes about the intersection of technology, design, and business. With a strategic mindset and a deep understanding of the industry, he is dedicated to helping companies grow.