How to change PostgreSQL user password?

To log in without a password:

sudo -u user_name psql db_name

To reset the password if you have forgotten:

ALTER USER user_name WITH PASSWORD 'new_password';

Related Posts:

  1. How to change PostgreSQL user password?
  2. PostgreSQL: Show tables in PostgreSQL
  3. Psql could not connect to server: No such file or directory, 5432 error?
  4. Getting error: Peer authentication failed for user “postgres”, when trying to get pgsql working with rails
  5. What is the format for the PostgreSQL connection string / URL?
  6. “use database_name” command in PostgreSQL
  7. PSQLException: current transaction is aborted, commands ignored until end of transaction block
  8. psql: FATAL: Ident authentication failed for user “postgres”
  9. fe_sendauth: no password supplied
  10. How can I drop all the tables in a PostgreSQL database?
  11. How to restart PostgreSQL in Ubuntu 18.04
  12. FATAL: password authentication failed for user “postgres” (postgresql 11 with pgAdmin 4)
  13. Postgresql: Scripting psql execution with password
  14. postgresql duplicate key violates unique constraint
  15. “psql: could not connect to server: Connection refused” Error when connecting to remote database
  16. No function matches the given name and argument types
  17. PostgreSQL error: Fatal: role “username” does not exist
  18. How to exit from PostgreSQL command line utility: psql
  19. psql: FATAL: database “” does not exist
  20. eroku “psql: FATAL: remaining connection slots are reserved for non-replication superuser connections”
  21. Permission denied for relation
  22. postgres does not know where to find server configuration
  23. input file appears to be a text format dump. Please use psql
  24. PG COPY error: invalid input syntax for integer
  25. Postgres: INSERT if does not exist already
  26. What’s the default superuser username/password for postgres after a new install?
  27. How to see active connections and “current activity” in PostgreSQL 8.4
  28. pg_dump and pg_restore: input file does not appear to be a valid archive
  29. What is this JavaScript “require”?
  30. What is this JavaScript “require”?
  31. PostgreSQL “DESCRIBE TABLE”
  32. How to UPSERT (MERGE, INSERT … ON DUPLICATE UPDATE) in PostgreSQL?
  33. How to restart Postgresql
  34. Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]
  35. What is the default password for Postgres
  36. Postgresql 9.2 pg_dump version mismatch
  37. How do I update the password for Git?
  38. missing FROM-clause entry for table
  39. PostgreSQL: Remotely connecting to Postgres instance using psql command
  40. Simple Random Samples from a Sql database
  41. Insert text with single quotes in PostgreSQL
  42. ERROR: there is no unique constraint matching given keys for referenced table “bar”
  43. Cannot simply use PostgreSQL table name (“relation does not exist”)
  44. Can’t find the ‘libpq-fe.h header when trying to install pg gem
  45. Simulate CREATE DATABASE IF NOT EXISTS for PostgreSQL?
  46. could not connect to server: No such file or directory (PG::ConnectionBad)
  47. Postgresql tables exists, but getting “relation does not exist” when querying
  48. PG::ConnectionBad: fe_sendauth: no password supplied
  49. “extra data after last expected column” while trying to import a csv file into postgresql
  50. postgresql: error duplicate key value violates unique constraint
  51. psql: command not found Mac
  52. pg_ctl: no database directory specified and environment variable PGDATA unset
  53. psql: FATAL: role “postgres” does not exist
  54. Postgres Error: More than one row returned by a subquery used as an expression
  55. PostgreSQL: Query has no destination for result data
  56. What is the difference between LATERAL JOIN and a subquery in PostgreSQL?
  57. PostgreSQL create table if not exists
  58. updating table rows in postgres using subquery
  59. PostgreSQL visual interface similar to phpMyAdmin?
  60. java.lang.ClassNotFoundException: org.postgresql.Driver, Android
  61. GROUP BY and COUNT using ActiveRecord
  62. Postgresql column reference “id” is ambiguous
  63. What is a postgres superuser
  64. GRANT SELECT to all tables in postgresql
  65. Is there an equivalent of MySQL’s SHOW CREATE TABLE in Postgres?
  66. Postgres equivalent to MySQL’s \G?
  67. Postgresql: what does GRANT ALL PRIVILEGES ON DATABASE do?
  68. Postgres equivalent to MySQL’s \G?
  69. Postgres equivalent to MySQL’s \G?

Leave a Comment