fe_sendauth: no password supplied

After making changes to the pg_hba.conf or postgresql.conf files, the cluster needs to be reloaded to pick up the changes.

From the command line: pg_ctl reload

From within a db (as superuser): select pg_reload_conf();

From PGAdmin: right-click db name, select “Reload Configuration”

Note: the reload is not sufficient for changes like enabling archiving, changing shared_buffers, etc — those require a cluster restart.

Related Posts:

  1. PostgreSQL: Show tables in PostgreSQL
  2. Psql could not connect to server: No such file or directory, 5432 error?
  3. Getting error: Peer authentication failed for user “postgres”, when trying to get pgsql working with rails
  4. What is the format for the PostgreSQL connection string / URL?
  5. “use database_name” command in PostgreSQL
  6. PSQLException: current transaction is aborted, commands ignored until end of transaction block
  7. psql: FATAL: Ident authentication failed for user “postgres”
  8. How can I drop all the tables in a PostgreSQL database?
  9. How to restart PostgreSQL in Ubuntu 18.04
  10. FATAL: password authentication failed for user “postgres” (postgresql 11 with pgAdmin 4)
  11. Postgresql: Scripting psql execution with password
  12. postgresql duplicate key violates unique constraint
  13. “psql: could not connect to server: Connection refused” Error when connecting to remote database
  14. How to change PostgreSQL user password?
  15. No function matches the given name and argument types
  16. PostgreSQL error: Fatal: role “username” does not exist
  17. How to change PostgreSQL user password?
  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. ActionController::UnknownFormat
  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. cannot load such file — bundler/setup (LoadError)
  50. “extra data after last expected column” while trying to import a csv file into postgresql
  51. postgresql: error duplicate key value violates unique constraint
  52. Rails 4 RoutingError: No Route Matches
  53. couldn’t find file ‘jquery’ with type ‘application/javascript’
  54. psql: command not found Mac
  55. pg_ctl: no database directory specified and environment variable PGDATA unset
  56. psql: FATAL: role “postgres” does not exist
  57. Getting: “Migrations are pending; run ‘bin/rake db:migrate RAILS_ENV=development’ to resolve this issue.” after cloning and migrating the project
  58. Postgres Error: More than one row returned by a subquery used as an expression
  59. PostgreSQL: Query has no destination for result data
  60. PG::ConnectionBad – could not connect to server: Connection refused
  61. What is the difference between LATERAL JOIN and a subquery in PostgreSQL?
  62. bcrypt LoadError: Cannot load such file
  63. Rails: I installed Ruby, now “bundle install” doesn’t work
  64. PostgreSQL create table if not exists
  65. updating table rows in postgres using subquery
  66. PostgreSQL visual interface similar to phpMyAdmin?
  67. java.lang.ClassNotFoundException: org.postgresql.Driver, Android
  68. Rails button_to vs. HTML Button Tag
  69. GROUP BY and COUNT using ActiveRecord
  70. Postgresql column reference “id” is ambiguous
  71. What is a postgres superuser
  72. GRANT SELECT to all tables in postgresql
  73. Is there an equivalent of MySQL’s SHOW CREATE TABLE in Postgres?
  74. Postgres equivalent to MySQL’s \G?
  75. Postgresql: what does GRANT ALL PRIVILEGES ON DATABASE do?
  76. Postgres equivalent to MySQL’s \G?
  77. Postgres equivalent to MySQL’s \G?

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)