pg_dumpall(UNIX)

pg_dumpall(UNIX)

pg_dump Home Page User Commands Index pg_passwd


NAME
       pg_dumpall  -  dumps  out  all  Postgres  databases into a
       script file

SYNOPSIS
       pg_dumpall [pg_dump options]

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  cre-
       ates  each  dumped  database  before  loading.  pg_dumpall
       takes all pg_dump options, but -f and dbname should not be
       used.

EXAMPLES
       To dump all databases (you can use pg_dump options):

            pg_dumpall -o >db.out

       To reload into a fresh installation (you can use psql options):

            psql -e template1 <db.out

SEE ALSO
       pg_dump(1) 

pg_dump Home Page User Commands Index pg_passwd