no pg_hba.conf entry for host

by

If you can change this line:

host    all        all         192.168.0.1/32        md5

With this:

host    all        all         all                   md5

You can see if this solves the problem.

But another consideration is your postgresql port(5432) is very open to password attacks with hackers (maybe they can brute force the password). You can change your postgresql port 5432 to ‘33333’ or another value, so they can’t know this configuration.

More Related Contents:

  1. What is PostgreSQL equivalent to autoincrement?
  2. How do I specify a password to ‘psql’ non-interactively?
  3. INSERT with dynamic table name in trigger function
  4. psql: FATAL: Ident authentication failed for user “postgres”
  5. Use multiple conflict_target in ON CONFLICT clause
  6. PostgreSQL -must appear in the GROUP BY clause or be used in an aggregate function
  7. How to find table creation time?
  8. What is the format for the PostgreSQL connection string / URL?
  9. Where does PostgreSQL store the database?
  10. How to add “on delete cascade” constraints?
  11. Is there a way to disable function overloading in Postgres
  12. Grant all on a specific schema in the db to a group role in PostgreSQL
  13. Can I make a plpgsql function return an integer without using a variable?
  14. Migrate database from Postgres to MySQL [closed]
  15. How can I start PostgreSQL on Windows?
  16. PostgreSQL – max number of parameters in “IN” clause?
  17. SQLAlchemy, Psycopg2 and Postgresql COPY
  18. How to find out if an upsert was an update with PostgreSQL 9.5+ UPSERT?
  19. Why can I create a table with PRIMARY KEY on a nullable column?
  20. Oracle SQL Developer and PostgreSQL
  21. PostgreSQL array of elements that each are a foreign key
  22. How to reset sequence in postgres and fill id column with new data?
  23. Custom ORDER BY Explanation
  24. PostgreSQL – disabling constraints
  25. PostgreSQL authentication method 10 not supported
  26. How to delete an enum type value in postgres?
  27. Why unsigned integer is not available in PostgreSQL?
  28. now() default values are all showing same timestamp
  29. What’s the difference between pg_table_size, pg_relation_size & pg_total_relation_size? (PostgreSQL)
  30. JPA and PostgreSQL with GenerationType.IDENTITY

Leave a Comment