Forrest logo
back to context overview

pg_dumpall

List of commands for pg_dumpall:

  • pg_dumpall:tldr:b4bb9 pg_dumpall: Dump all databases using a specific username.
    $ pg_dumpall --username=${username} > ${filename-sql}
    try on your machine
    explain this command
  • pg_dumpall:tldr:dc6c0 pg_dumpall: Same as above, customize host and port.
    $ pg_dumpall -h ${host} -p ${port} > ${output_file-sql}
    try on your machine
    explain this command
  • pg_dumpall:tldr:ef370 pg_dumpall: Dump only schema (data definitions) into an SQL-script file.
    $ pg_dumpall -s > ${output_file-sql}
    try on your machine
    explain this command
  • pg_dumpall:tldr:f86ba pg_dumpall: Dump only database data into an SQL-script file.
    $ pg_dumpall --data-only > ${filename-sql}
    try on your machine
    explain this command
  • pg_dumpall:tldr:faa60 pg_dumpall: Dump all databases.
    $ pg_dumpall > ${filename-sql}
    try on your machine
    explain this command
  • pg_dumpall:tldr:fff02 pg_dumpall: Dump all databases into a custom-format archive file with moderate compression.
    $ pg_dumpall -Fc > ${output_file-dump}
    try on your machine
    explain this command
back to context overview