How to configure PostgreSQL to accept all incoming connections

by

Just use 0.0.0.0/0.

host    all             all             0.0.0.0/0            md5

Make sure the listen_addresses in postgresql.conf (or ALTER SYSTEM SET) allows incoming connections on all available IP interfaces.

listen_addresses="*"

After the changes you have to reload the configuration. One way to do this is execute this SELECT as a superuser.

SELECT pg_reload_conf();

Note: to change listen_addresses, a reload is not enough, and you have to restart the server.

More Related Contents:

  1. How to reset postgres’ primary key sequence when it falls out of sync?
  2. PostgreSQL LIKE query performance variations
  3. How to import CSV file data into a PostgreSQL table
  4. Calculating and saving space in PostgreSQL
  5. The forgotten assignment operator “=” and the commonplace “:=”
  6. Equivalent to unpivot() in PostgreSQL
  7. Passing user id to PostgreSQL triggers
  8. PostgreSQL: ERROR: 42601: a column definition list is required for functions returning “record”
  9. I forgot the password I entered during postgres installation
  10. Do nullable columns occupy additional space in PostgreSQL?
  11. how to emulate “insert ignore” and “on duplicate key update” (sql merge) with postgresql?
  12. How do I efficiently select the previous non-null value?
  13. Copy a few of the columns of a csv file into a table
  14. Postgres query to check a string is a number
  15. Using pyspark to connect to PostgreSQL
  16. Returning from a function with OUT parameter
  17. ERROR: permission denied for relation tablename on Postgres while trying a SELECT as a readonly user
  18. How do you create a random string that’s suitable for a session ID in PostgreSQL?
  19. Joining Results from Two Separate Databases
  20. PL/pgSQL functions: How to return a normal table with multiple columns using an execute statement
  21. Update timestamp when row is updated in PostgreSQL
  22. Postgresql query array of objects in JSONB field
  23. Multicolumn index on 3 fields with heterogenous data types
  24. How to add a conditional unique index on PostgreSQL
  25. Select from a table variable
  26. PostgreSQL INSERT ON CONFLICT UPDATE (upsert) use all excluded values
  27. Hashing a String to a Numeric Value in PostgreSQL
  28. Spring Docker container cannot access Postgres Docker container
  29. Format specifier for integer variables in format() for EXECUTE?
  30. PostgreSQL composite primary key

Leave a Comment