MAN page from Mandrake Other postgresql-clients-6.3.2-4.i386.rpm

pg_dumpall

Section: PostgreSQL (UNIX)
Updated: 1/20/96
Index 

NAME

pg_dumpall - dumps out all Postgres databases into a script file 

SYNOPSIS

pg_dumpall[pg_dump options] 

DESCRIPTION

pg_dumpallis 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 creates each dumped database before loading.pg_dumpall takes all pg_dump options, but -f and dbnameshould not be used. 

EXAMPLES

To dump all databases (you can use pg_dump options):        pg_dumpall -o >db.outTo reload into a fresh installation (you can use psql options):        psql -e template1 <db.out

 

SEE ALSO

pg_dump(1)

---

 

Index

NAME

SYNOPSIS

DESCRIPTION

EXAMPLES

SEE ALSO

---

This document was created byman2html,using the manual pages.