[POSTGRESQL] backup & restore - fourslickz/notes GitHub Wiki

backup

PGPASSWORD="5IeRsQs85haT" pg_dumpall -U postgres > /tmp/all_databases.sql

export postre

pg_dump -U itinerary_user -h 127.0.0.1 -d itinerary_dev -F p > itinerary_dev.sql

import postgre

psql -U itinerary_user -d itinerary_dev < itinerary_dev.sql