Backup – ir a una carpeta por ejemplo cd /root/backups allí se almacenaran:

pg_dump -U postgres -W -h localhost dbevext > dbevext_backup.sql
pg_dump -U postgres -W -h localhost dbevext > dbevext_backup.tar

Para comprimir db:

gzip -9 dbevext_backup.sql

Restore Backup:

psql -h localhost -p 5432 postgres -f dbevext_backup.sql nuevadbcreada
Was this answer helpful? 0 Users Found This Useful (0 Votes)

Powered by WHMCompleteSolution