PG_DUMPALL(1)                                       PG_DUMPALL(1)

NAME
       pg_dumpall  - Extract all Postgres databases into a script
       file

SYNOPSIS
       pg_dumpall
       pg_dumpall [ -h host ] [ -p port ] [ -a ] [ -d ] [ -D ] [ -o ] [ -s ] [ -u ] [ -v ] [ -x ]

   INPUTS
       pg_dumpall accepts the following command line arguments:

       -a     Dump out only the data, no schema (definitions).

       -d     Dump data as proper insert strings.

       -D     Dump data as inserts with attribute names

       -n     Suppress double quotes  around  identifiers  unless
              absolutely necessary.  This may cause trouble load-
              ing this dumped data if there  are  reserved  words
              used for identifiers.

       -o     Dump object identifiers (OIDs) for every table.

       -s     Dump out only the schema (definitions), no data.

       -u     Use  password  authentication. Prompts for username
              and password.

       -v     Specifies verbose mode

       -x     Prevent dumping ACLs  (grant/revoke  commands)  and
              table ownership information.

       pg_dumpall  also  accepts the following command line argu-
       ments for connection parameters:

       -h host
              Specifies the hostname of the machine on which  the
              postmaster  is  running.  Defaults to using a local
              Unix domain socket rather than an IP connection..

       -p port
              Specifies the Internet TCP/IP port  or  local  Unix
              domain  socket file extension on which the postmas-
              ter is listening for connections. The  port  number
              defaults  to 5432, or the value of the PGPORT envi-
              ronment variable (if set).

       -u     Use password authentication.  Prompts for  username
              and password.

   OUTPUTS
       pg_dumpall will create a file or write to stdout.

       Connection to database 'template1' failed.
              pg_dumpall  could not attach to the postmaster pro-
              cess on the specified host and  port.  If  you  see
              this message, ensure that the postmaster 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.

       Connection to database 'dbname' failed.
              You  do  not  have  a  valid  entry in the relation
              pg_shadow and and will not  be  allowed  to  access
              Postgres.  Contact your Postgres administrator.

       dumpSequence(table): SELECT failed
              You  do  not  have permission to read the database.
              Contact your Postgres site administrator.

              Note: pg_dumpall internally executes SELECT  state-
              ments.  If  you  have  problems running pg_dumpall,
              make sure you are able to select  information  from
              the database using, for example, psql.

DESCRIPTION
       pg_dumpall  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.  pg_dumpall
       includes in this file the proper commands to automatically
       create each dumped database before loading.

       pg_dumpall  takes  all  pg_dump  options,  but  -f, -t and
       dbname should be omitted.

       Refer to pg_dump(1) for more information on this  capabil-
       ity.

USAGE
       To dump all databases:

       % pg_dumpall -o > db.out

              Tip:   You   can   use  most  pg_dump  options  for
              pg_dumpall.

       To reload this database:

       % psql -e template1 < db.out

              Tip: You can use most psql options when  reloading.

Application               15 August 1999                        1