For example, there is a postgres user, base and trust access.
Alex
6,232 5 gold signs 19 silver marks 29 bronze marks
stanislav stanislav
29.5k 20 gold marks 74 silver marks 192 bronze marks
|
2 answers
To save a database cluster:
pg_dumpall -U postgres -w > backup To restore a database cluster:
psql -U postgres -w -f backup postgres 
Nicolas Chabanovsky ♦ Nicolas Chabanovsky
38.1k 54 gold marks 222 silver marks 438 bronze marks
|
Backup base:
pg_dump -v -h 127.0.0.0 -F c -U postgres -W -f "base.backup" base 
Timofei Bondarev
6,940 3 gold marks 32 silver marks 51 bronze marks
cavinc cavinc
729 3 silver marks 8 bronze marks
|