File tree Expand file tree Collapse file tree 2 files changed +24
-2
lines changed Expand file tree Collapse file tree 2 files changed +24
-2
lines changed Original file line number Diff line number Diff line change 1
1
.\" This is -*-nroff-*-
2
2
.\" XXX standard disclaimer belongs here....
3
- .\" $Header: /cvsroot/pgsql/src/man/Attic/pg_dump.1,v 1.5 1997/01/17 18:36:32 momjian Exp $
3
+ .\" $Header: /cvsroot/pgsql/src/man/Attic/pg_dump.1,v 1.6 1997/01/23 06:01:00 momjian Exp $
4
4
.TH PG_DUMP UNIX 1/20/96 PostgreSQL PostgreSQL
5
5
.SH NAME
6
6
pg_dump \(em dumps out a Postgres database into a script file
@@ -112,5 +112,15 @@ the same as above. Partial index predicates are stored as plans)
112
112
.BR " large objects"
113
113
pg_dump does not handle large objects. Large objects are ignored and
114
114
must be dealt with manually.
115
+ .SH EXAMPLES
116
+ .nf
117
+ To dump a database:
118
+
119
+ pg_dump >db.out
120
+
121
+ To reload it:
122
+
123
+ psql -e database <db.out
124
+
115
125
.SH "SEE ALSO"
116
126
copy(l)
Original file line number Diff line number Diff line change 1
1
.\" This is -*-nroff-*-
2
2
.\" XXX standard disclaimer belongs here....
3
- .\" $Header: /cvsroot/pgsql/src/man/Attic/pg_dumpall.1,v 1.1 1997/01/16 15:28:34 momjian Exp $
3
+ .\" $Header: /cvsroot/pgsql/src/man/Attic/pg_dumpall.1,v 1.2 1997/01/23 06:01:07 momjian Exp $
4
4
.TH pg_dumpall UNIX 1/20/96 PostgreSQL PostgreSQL
5
5
.SH NAME
6
6
pg_dumpall \(em dumps out all Postgres databases into a script file
@@ -11,7 +11,19 @@ pg_dumpall \(em dumps out all Postgres databases into a script file
11
11
.IR " pg_dumpall"
12
12
is a utility for dumping out all Postgres databases into one file.
13
13
It also dumps the pg_user table, which is global to all databases.
14
+ pg_dumpall creates each dumped database before loading.
14
15
pg_dumpall takes all pg_dump options, but \fB -f \fR and \fB dbname \fR
15
16
should not be used.
17
+ .SH EXAMPLES
18
+ .nf
19
+ To dump all databases (you can use pg_dump options):
20
+
21
+ pg_dumpall -o >db.out
22
+
23
+ To reload into a fresh installation (you can use psql options):
24
+
25
+ psql -e template1 <db.out
26
+
27
+ .fi
16
28
.SH "SEE ALSO"
17
29
pg_dump(1)
You can’t perform that action at this time.
0 commit comments