<refname>pg_dump</refname>

<refpurpose>

extract a <productname>PostgreSQL</productname> databaseinto ascriptfileor otherarchive file

export a <productname>PostgreSQL</productname> databaseas an SQLscript ortootherformats

</refpurpose>

</refnamediv>

<refnamediv>

<refname>pg_dumpall</refname>

<refpurpose>extract a <productname>PostgreSQL</productname> database cluster using a specified dump format</refpurpose>

<refpurpose>

export a <productname>PostgreSQL</productname> database cluster as an SQL script or to other formats

</refpurpose>

</refnamediv>

<refsynopsisdiv>

<para>

<application>pg_dumpall</application> is a utility for writing out

(<quote>dumping</quote>) all <productname>PostgreSQL</productname> databases

of a cluster into an archive. Thearchive contains

of a cluster into anSQL script file or anarchive. Theoutput contains

<acronym>SQL</acronym> commands that can be used as input to <xref

linkend="app-psql"/> to restore the databases. It does this by

calling <xref linkend="app-pgdump"/> for each database in the cluster.

<refname>pg_restore</refname>

<refpurpose>

restorea<productname>PostgreSQL</productname>database or cluster

from an archivecreated by <application>pg_dump</application> or

restore <productname>PostgreSQL</productname>databases from archives

created by <application>pg_dump</application> or

<application>pg_dumpall</application>

</refpurpose>

</refnamediv>

static void

help(const char *progname)

{

printf(_("%sdumps a database asa text file or to other formats.\n\n"), progname);

printf(_("%sexports aPostgreSQLdatabase asan SQL script or to other formats.\n\n"), progname);

printf(_("Usage:\n"));

printf(_(" %s [OPTION]... [DBNAME]\n"), progname);

help(void)

{

printf(_("%sextracts a PostgreSQL database clusterbased on specified dump format.\n\n"),progname);

printf(_("%sexports a PostgreSQL database clusteras an SQL script or to other formats.\n\n"),progname);

printf(_("Usage:\n"));

printf(_(" %s [OPTION]...\n"),progname);