How to pass in password to pg_dump?

by

Create a .pgpass file in the home directory of the account that pg_dump will run as.

The format is:

hostname:port:database:username:password

Then, set the file’s mode to 0600. Otherwise, it will be ignored.

chmod 600 ~/.pgpass

See the Postgresql documentation libpq-pgpass for more details.

More Related Contents:

  1. Expansion of variables inside single quotes in a command in Bash
  2. Reading quoted/escaped arguments correctly from a string
  3. Can a shell script set environment variables of the calling shell? [duplicate]
  4. How to add a progress bar to a shell script?
  5. What is the purpose of “&&” in a shell command?
  6. How can I remove the extension of a filename in a shell script?
  7. sudo echo “something” >> /etc/privilegedFile doesn’t work [duplicate]
  8. Convert absolute path into relative path given a current directory using Bash
  9. While-loop subshell dilemma in Bash
  10. How do I escape the wildcard/asterisk character in bash?
  11. How do I grab an INI value within a shell script?
  12. How to create a cron job using Bash automatically without the interactive editor?
  13. Convert date time string to epoch in Bash
  14. How do I put an already-running process under nohup?
  15. How to obtain the absolute path of a file via Shell (BASH/ZSH/SH)?
  16. How can I count all the lines of code in a directory recursively?
  17. How does Ctrl-C terminate a child process?
  18. Running multiple commands in one line in shell
  19. Copy folder recursively, excluding some folders
  20. Variable interpolation in the shell
  21. How to remove filename prefix with a Posix shell
  22. How to pipe multiple commands into a single command in the shell? (sh, bash, …)
  23. What does ” 2>&1 ” mean?
  24. How do I read user input into a variable in Bash?
  25. Why do I get “/bin/sh: Argument list too long” when passing quoted arguments?
  26. Count number of lines in a git repository
  27. How do I check if a directory exists or not in a Bash shell script?
  28. shell script respond to keypress
  29. How to properly nest Bash backticks
  30. Subtract two variables in Bash

Leave a Comment