Postgresql: Scripting psql execution with password

by

You may wish to read a summary of the ways to authenticate to PostgreSQL.

To answer your question, there are several ways provide a password for password-based authentication:

  1. Via the password prompt. Example:

    psql -h uta.biocommons.org -U foo
Password for user foo:

  2. In a pgpass file. See libpq-pgpass. Format:

    <host>:<port>:<database>:<user>:<password>

  3. With the PGPASSWORD environment variable. See libpq-envars. Example:

    export PGPASSWORD=yourpass
psql ...

# Or in one line for this invocation only:
PGPASSWORD=yourpass psql ...

  4. In the connection string The password and other options may be specified in the connection string/URI. See app-psql. Example:

    psql postgresql://username:password@dbmaster:5433/mydb?sslmode=require

More Related Contents:

  1. PostgreSQL “DESCRIBE TABLE”
  2. How to exit from PostgreSQL command line utility: psql
  3. In psql, why do some commands have no effect?
  4. How do I specify a password to ‘psql’ non-interactively?
  5. Run batch file with psql command without password
  6. Run a PostgreSQL .sql file using command line arguments
  7. How to switch databases in psql?
  8. “psql: could not connect to server: Connection refused” Error when connecting to remote database
  9. psql: FATAL: database “” does not exist
  10. PostgreSQL: Why psql can’t connect to server?
  11. Use variable set by psql meta-command inside of DO block
  12. Alternate output format for psql showing one column per line with column name
  13. Library not loaded: /usr/local/opt/readline/lib/libreadline.6.2.dylib
  14. PostgreSQL disable more output
  15. Importing .csv with timestamp column (dd.mm.yyyy hh.mm.ss) using psql \copy
  16. How to import CSV file data into a PostgreSQL table
  17. The forgotten assignment operator “=” and the commonplace “:=”
  18. Equivalent to unpivot() in PostgreSQL
  19. Passing user id to PostgreSQL triggers
  20. PostgreSQL: ERROR: 42601: a column definition list is required for functions returning “record”
  21. I forgot the password I entered during postgres installation
  22. Do nullable columns occupy additional space in PostgreSQL?
  23. PostgreSQL: serial vs identity
  24. Postgres query to check a string is a number
  25. Using pyspark to connect to PostgreSQL
  26. Returning from a function with OUT parameter
  27. How to add a conditional unique index on PostgreSQL
  28. Heroku database restore issue
  29. user postgres launches process that takes all CPUs 100% usage
  30. How do I get min, median and max from my query in postgresql?

Leave a Comment