pg_dumpall.1 867 字节
Newer Older
B
Bruce Momjian 已提交
1 2
.\" This is -*-nroff-*-
.\" XXX standard disclaimer belongs here....
B
cleanup  
Bruce Momjian 已提交
3
.\" $Header: /cvsroot/pgsql/src/man/Attic/pg_dumpall.1,v 1.5 1998/06/24 13:21:28 momjian Exp $
B
Bruce Momjian 已提交
4 5
.TH pg_dumpall UNIX 1/20/96 PostgreSQL PostgreSQL
.SH NAME
B
Bruce Momjian 已提交
6
pg_dumpall - dumps out all Postgres databases into a script file
B
Bruce Momjian 已提交
7 8 9 10 11 12
.SH SYNOPSIS
.BR pg_dumpall 
[pg_dump options]
.SH DESCRIPTION
.IR "pg_dumpall"
is a utility for dumping out all Postgres databases into one file.
B
Bruce Momjian 已提交
13
It also dumps the pg_shadow table, which is global to all databases.
B
Bruce Momjian 已提交
14
pg_dumpall creates each dumped database before loading.
B
Bruce Momjian 已提交
15 16
pg_dumpall takes all pg_dump options, but \fB-f\fR and \fBdbname\fR
should not be used.
B
Bruce Momjian 已提交
17 18 19 20 21 22 23 24 25 26 27
.SH EXAMPLES
.nf
To dump all databases (you can use pg_dump options):

	pg_dumpall -o >db.out

To reload into a fresh installation (you can use psql options):

	psql -e template1 <db.out

.fi
B
Bruce Momjian 已提交
28
.SH "SEE ALSO"
B
cleanup  
Bruce Momjian 已提交
29
pg_dump(1).