pg_dumpallPostgreSQL User's GuidePrevNextpg_dumpallNamepg_dumpall — Extract all Postgres databases into a script filepg_dumpall pg_dumpall [ -h host ] [ -p port ] [ -a ] [ -d ] [ -D ] [ -o ] [ -s ] [ -u ] [ -v ] [ -z ]Inputspg_dumpall accepts the following command line arguments: -aDump out only the data, no schema (definitions). -dDump data as proper insert strings. -DDump data as inserts with attribute names -nSuppress double quotes around identifiers unless absolutely necessary. This may cause trouble loading this dumped data if there are reserved words used for identifiers. -oDump object identifiers (OIDs) for every table. -sDump out only the schema (definitions), no data. -uUse password authentication. Prompts for username and password. -vSpecifies verbose mode -zInclude ACLs (grant/revoke commands) and table ownership information. pg_dumpall also accepts the following command line arguments for connection parameters: -h hostSpecifies 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 portSpecifies the Internet TCP/IP port or local Unix domain socket file extension on which the postmaster is listening for connections. The port number defaults to 5432, or the value of the PGPORT environment variable (if set). -uUse password authentication. Prompts for username and password. Outputspg_dumpall will create a file or write to stdout. Connection to database 'template1' failed. connectDB() failed: Is the postmaster running and accepting connections at 'UNIX Socket' on port 'port'?pg_dumpall could not attach to the postmaster process 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. FATAL 1: SetUserId: user 'username' is not in 'pg_shadow'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 failedYou do not have permission to read the database. Contact your Postgres site administrator. Note: pg_dumpall internally executes SELECT statements. If you have problems running pg_dumpall, make sure you are able to select information from the database using, for example, psql. Descriptionpg_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 for more information on this capability. UsageTo 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. PrevHomeNextpg_dumpUppsql