0

I have created user in PostgreSQL database that don't have password.

When I tried to connect to same user in pgAdmin3 it asks for password for the user every time I want to connect to server.

what i did was following:sudo vi /etc/postgresql/10.2/main/pg_hba.conf # Add following lines above first uncommented line # Allow user login without password # TYPE DATABASE USER ADDRESS METHOD local all user trust # Save file and restart Postgresql sudo service postgresql restart

How to access database for user without password in pgAdmin3? What are the config changes required in pgAdmin3?

codeScoop
  • 1
  • 1
  • 3
  • See if this may be of help: https://dba.stackexchange.com/questions/8111/pgadmin-iii-how-to-connect-to-database-when-password-is-empty – Kamil Gosciminski Sep 24 '18 at 12:12
  • Are you connecting without a password for the same user via different client like **psql**? – Kamil Gosciminski Sep 24 '18 at 12:12
  • i have created a user whose password is empty in postgres and created database under that user .Now i want to access database under the created user – codeScoop Sep 24 '18 at 13:08
  • the link you provided is not helpful – codeScoop Sep 24 '18 at 13:09
  • Probably unrelated, but: an "empty password" is something different than "no password". –  Sep 24 '18 at 13:27
  • what i did was following:sudo vi /etc/postgresql/10.2/main/pg_hba.conf # Add following lines above first uncommented line # Allow user login without password # TYPE DATABASE USER ADDRESS METHOD local all user trust # Save file and restart Postgresql sudo service postgresql restart – codeScoop Sep 24 '18 at 13:34
  • sudo vi /etc/postgresql/10.2/main/pg_hba.conf in that made : DATABASE USER ADDRESS METHOD local all user trust – codeScoop Sep 24 '18 at 13:36
  • to remove password for user .now when i am trying to access that user in pgadmin i am unable to do that – codeScoop Sep 24 '18 at 13:36
  • You should get your story straight in the question. Do edit it and attach additional information on what you have tried, to keep it all together instead of separate comments. It seems like you've tried some things. Share it. – Kamil Gosciminski Sep 24 '18 at 20:31
  • Okay thanks kamil G .i will do it soon – codeScoop Sep 25 '18 at 08:06

0 Answers0