File: app-pg-dumpall.html

package info (click to toggle)
mpsql 2.1-2
links: PTS
area: non-free
in suites: potato
size: 3,528 kB
ctags: 4,886
sloc: ansic: 35,184; makefile: 3,761; sh: 44
file content (521 lines) | stat: -rw-r--r-- 7,474 bytes
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML
><HEAD
><TITLE
>pg_dumpall</TITLE
><META
NAME="GENERATOR"
CONTENT="Modular DocBook HTML Stylesheet version 1.19"><LINK
REL="HOME"
TITLE="PostgreSQL User's Guide"
HREF="user.html"><LINK
REL="UP"
TITLE="Utility Applications"
HREF="utilities.html"><LINK
REL="PREVIOUS"
TITLE="pg_dump"
HREF="app-pg-dump.html"><LINK
REL="NEXT"
TITLE="psql"
HREF="app-psql.html"></HEAD
><BODY
BGCOLOR="#FFFFFF"
TEXT="#000000"
><DIV
CLASS="NAVHEADER"
><TABLE
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TH
COLSPAN="3"
ALIGN="center"
>PostgreSQL User's Guide</TH
></TR
><TR
><TD
WIDTH="10%"
ALIGN="left"
VALIGN="bottom"
><A
HREF="app-pg-dump.html"
>Prev</A
></TD
><TD
WIDTH="80%"
ALIGN="center"
VALIGN="bottom"
></TD
><TD
WIDTH="10%"
ALIGN="right"
VALIGN="bottom"
><A
HREF="app-psql.html"
>Next</A
></TD
></TR
></TABLE
><HR
ALIGN="LEFT"
WIDTH="100%"></DIV
><H1
><SPAN
CLASS="APPLICATION"
>pg_dumpall</SPAN
></H1
><DIV
CLASS="REFNAMEDIV"
><H2
>Name</H2
><SPAN
CLASS="APPLICATION"
>pg_dumpall</SPAN
> &#8212; Extract all <SPAN
CLASS="PRODUCTNAME"
>Postgres</SPAN
> databases into a script file</DIV
><DIV
CLASS="REFSYNOPSISDIV"
><PRE
CLASS="SYNOPSIS"
>pg_dumpall
pg_dumpall [ -h <TT
CLASS="REPLACEABLE"
><I
>host</I
></TT
> ] [ -p <TT
CLASS="REPLACEABLE"
><I
>port</I
></TT
> ]
    [ -a ] [ -d ] [ -D ] [ -o ] [ -s ] [ -u ] [ -v ] [ -z ]</PRE
><DIV
CLASS="REFSECT2"
><H3
>Inputs</H3
><P
><SPAN
CLASS="APPLICATION"
>pg_dumpall</SPAN
> accepts the following command line arguments:

<P
></P
></P><DL
><DT
>-a</DT
><DD
><P
>Dump out only the data, no schema (definitions).&#13;</P
></DD
><DT
>-d</DT
><DD
><P
>Dump data as proper insert strings.&#13;</P
></DD
><DT
>-D</DT
><DD
><P
>Dump data as inserts with attribute names&#13;</P
></DD
><DT
>-n</DT
><DD
><P
>Suppress double quotes around identifiers unless absolutely necessary.
This may cause trouble loading this dumped data if there are reserved words
used for identifiers.&#13;</P
></DD
><DT
>-o</DT
><DD
><P
>Dump object identifiers (<SPAN
CLASS="ACRONYM"
>OID</SPAN
>s) for every table.&#13;</P
></DD
><DT
>-s</DT
><DD
><P
>Dump out only the schema (definitions), no data.&#13;</P
></DD
><DT
>-u</DT
><DD
><P
>Use password authentication. Prompts for username and password.&#13;</P
></DD
><DT
>-v</DT
><DD
><P
>Specifies verbose mode&#13;</P
></DD
><DT
>-z</DT
><DD
><P
>Include ACLs (grant/revoke commands) and table ownership information.&#13;</P
></DD
></DL
><P>&#13;</P
><P
><SPAN
CLASS="APPLICATION"
>pg_dumpall</SPAN
> also accepts 
the following command line arguments for connection parameters:

<P
></P
></P><DL
><DT
>-h <TT
CLASS="REPLACEABLE"
><I
>host</I
></TT
></DT
><DD
><P
>Specifies the hostname of the machine on which the 
<SPAN
CLASS="APPLICATION"
>postmaster</SPAN
>
is running.  Defaults to using a local Unix domain socket
 rather than an IP connection..&#13;</P
></DD
><DT
>-p <TT
CLASS="REPLACEABLE"
><I
>port</I
></TT
></DT
><DD
><P
>Specifies the Internet TCP/IP port or local Unix domain socket file 
extension on which the <SPAN
CLASS="APPLICATION"
>postmaster</SPAN
>
is listening for connections.  The port number defaults to 5432,
 or the value of the <TT
CLASS="ENVAR"
>PGPORT</TT
>
environment variable (if set).&#13;</P
></DD
><DT
>-u</DT
><DD
><P
>Use password authentication. 
Prompts for
<TT
CLASS="REPLACEABLE"
><I
>username</I
></TT
>
 and <TT
CLASS="REPLACEABLE"
><I
>password</I
></TT
>.&#13;</P
></DD
></DL
><P>&#13;</P
></DIV
><DIV
CLASS="REFSECT2"
><H3
>Outputs</H3
><P
><SPAN
CLASS="APPLICATION"
>pg_dumpall</SPAN
> will create a file or
 write to <TT
CLASS="FILENAME"
>stdout</TT
>.

<P
></P
></P><DL
><DT
>Connection to database 'template1' failed.
connectDB() failed: Is the postmaster running and accepting connections
 at 'UNIX Socket' on port '<TT
CLASS="REPLACEABLE"
><I
>port</I
></TT
>'?</DT
><DD
><P
><SPAN
CLASS="APPLICATION"
>pg_dumpall</SPAN
> could not attach to the 
<SPAN
CLASS="APPLICATION"
>postmaster</SPAN
> 
process on the specified host and port.  If you see this message,
ensure that the <SPAN
CLASS="APPLICATION"
>postmaster</SPAN
> 
is running on the proper host and that you have specified the proper
port.  If your site uses an authentication system, ensure that you
have obtained the required authentication credentials.&#13;</P
></DD
><DT
>Connection to database '<TT
CLASS="REPLACEABLE"
><I
>dbname</I
></TT
>' failed.
FATAL 1:  SetUserId: user '<TT
CLASS="REPLACEABLE"
><I
>username</I
></TT
>' is not in 'pg_shadow'</DT
><DD
><P
>You do not have a valid entry in the relation <TT
CLASS="LITERAL"
>pg_shadow</TT
>
and and will not be allowed to access <SPAN
CLASS="PRODUCTNAME"
>Postgres</SPAN
>. 
Contact your <SPAN
CLASS="PRODUCTNAME"
>Postgres</SPAN
> administrator.&#13;</P
></DD
><DT
>dumpSequence(<TT
CLASS="REPLACEABLE"
><I
>table</I
></TT
>): SELECT failed</DT
><DD
><P
>You do not have permission to read the database.
Contact your <SPAN
CLASS="PRODUCTNAME"
>Postgres</SPAN
> site administrator.&#13;</P
></DD
></DL
><P>

<BLOCKQUOTE
CLASS="NOTE"
><P
><B
>Note: </B
><SPAN
CLASS="APPLICATION"
>pg_dumpall</SPAN
> internally executes
<B
CLASS="COMMAND"
>SELECT</B
> statements. If you have problems running
<SPAN
CLASS="APPLICATION"
>pg_dumpall</SPAN
>,
make sure you are able to select information from the database using, for
example, <SPAN
CLASS="APPLICATION"
>psql</SPAN
>.</P
></BLOCKQUOTE
>&#13;</P
></DIV
></DIV
><DIV
CLASS="REFSECT1"
><H2
>Description</H2
><P
><SPAN
CLASS="APPLICATION"
>pg_dumpall</SPAN
>
is a utility for dumping out all Postgres databases into one file.
It also dumps the pg_shadow table, which is global to all databases.
<SPAN
CLASS="APPLICATION"
>pg_dumpall</SPAN
> includes in this file the proper commands
to automatically create each dumped database before loading.&#13;</P
><P
><SPAN
CLASS="APPLICATION"
>pg_dumpall</SPAN
> takes all <SPAN
CLASS="APPLICATION"
>pg_dump</SPAN
>
 options, but <SPAN
CLASS="OPTION"
>-f</SPAN
>, <SPAN
CLASS="OPTION"
>-t</SPAN
> and 
<TT
CLASS="REPLACEABLE"
><I
>dbname</I
></TT
>
should be omitted.&#13;</P
><P
>Refer to 
<A
HREF="app-pg-dump.html"
><I
><I
>pg_dump</I
></I
></A
>
 for more information on this capability.&#13;</P
></DIV
><DIV
CLASS="REFSECT1"
><H2
>Usage</H2
><P
>To dump all databases:

<PRE
CLASS="PROGRAMLISTING"
>% pg_dumpall -o &#62; db.out</PRE
>

<BLOCKQUOTE
CLASS="TIP"
><P
><B
>Tip: </B
>You can use most <SPAN
CLASS="APPLICATION"
>pg_dump</SPAN
> options
for <SPAN
CLASS="APPLICATION"
>pg_dumpall</SPAN
>.</P
></BLOCKQUOTE
>&#13;</P
><P
>To reload this database:

<PRE
CLASS="PROGRAMLISTING"
>psql -e template1 &#60; db.out</PRE
>

<BLOCKQUOTE
CLASS="TIP"
><P
><B
>Tip: </B
>You can use most <SPAN
CLASS="APPLICATION"
>psql</SPAN
> options
when reloading.</P
></BLOCKQUOTE
>&#13;</P
></DIV
><DIV
CLASS="NAVFOOTER"
><HR
ALIGN="LEFT"
WIDTH="100%"><TABLE
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
><A
HREF="app-pg-dump.html"
>Prev</A
></TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="user.html"
>Home</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
><A
HREF="app-psql.html"
>Next</A
></TD
></TR
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
><SPAN
CLASS="APPLICATION"
>pg_dump</SPAN
></TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="utilities.html"
>Up</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
><SPAN
CLASS="APPLICATION"
>psql</SPAN
></TD
></TR
></TABLE
></DIV
></BODY
></HTML
>