1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
|
<!-- manual page source format generated by PolyglotMan v3.0.4, -->
<!-- available via anonymous ftp from ftp.cs.berkeley.edu:/ucb/people/phelps/tcltk/rman.tar.Z -->
<HTML>
<HEAD>
<TITLE>pg_dumpall(UNIX) manual page</TITLE>
</HEAD>
<BODY>
<A HREF="pgsql.html">PostgreSQL Contents</A>
<H2><A NAME="sect0" HREF="#toc0">NAME </A></H2>
pg_dumpall - dumps out all Postgres databases into a script file
<H2><A NAME="sect1" HREF="#toc1">SYNOPSIS </A></H2>
<B>pg_dumpall</B> [pg_dump options]
<H2><A NAME="sect2" HREF="#toc2">DESCRIPTION </A></H2>
<I>pg_dumpall</I> is a utility
for dumping out all Postgres databases into one file. It also dumps the
pg_user table, which is global to all databases. pg_dumpall creates each
dumped database before loading. pg_dumpall takes all pg_dump options, but
<B>-f </B> and <B>dbname </B> should not be used.
<H2><A NAME="sect3" HREF="#toc3">EXAMPLES </A></H2>
To dump all databases (you
can use pg_dump options): <BR>
<P>
<tt> </tt><tt> </tt>pg_dumpall -o >db.out <BR>
<P>
To reload into a fresh
installation (you can use psql options): <BR>
<P>
<tt> </tt><tt> </tt>psql -e template1 <db.out <BR>
<P>
<H2><A NAME="sect4" HREF="#toc4">SEE
ALSO </A></H2>
<A HREF="pg_dump.1.html">pg_dump(1)</A>
<P>
<HR><P>
<A NAME="toc"><B>Table of Contents</B></A><P>
<UL>
<LI><A NAME="toc0" HREF="#sect0">NAME</A></LI>
<LI><A NAME="toc1" HREF="#sect1">SYNOPSIS</A></LI>
<LI><A NAME="toc2" HREF="#sect2">DESCRIPTION</A></LI>
<LI><A NAME="toc3" HREF="#sect3">EXAMPLES</A></LI>
<LI><A NAME="toc4" HREF="#sect4">SEE ALSO</A></LI>
</UL>
</BODY></HTML>
|
