Can’t connect to Postgresql on port 5432

by

You have to edit postgresql.conf file and change line with ‘listen_addresses’.

This file you can find in the /etc/postgresql/9.3/main directory.

Default Ubuntu config have allowed only localhost (or 127.0.0.1) interface, which is sufficient for using, when every PostgreSQL client work on the same computer, as PostgreSQL server. If you want connect PostgreSQL server from other computers, you have change this config line in this way:

listen_addresses="*"

Then you have edit pg_hba.conf file, too. In this file you have set, from which computers you can connect to this server and what method of authentication you can use. Usually you will need similar line:

host    all         all         192.168.1.0/24        md5

Please, read comments in this file…

EDIT:

After the editing postgresql.conf and pg_hba.conf you have to restart postgresql server.

EDIT2: Highlited configuration files.

More Related Contents:

  1. PostgreSQL via SSH Tunnel
  2. How to reset postgres’ primary key sequence when it falls out of sync?
  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 do I efficiently select the previous non-null value?
  12. How to configure PostgreSQL to accept all incoming connections
  13. Postgresql : Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections [duplicate]
  14. Disable PostgreSQL foreign key checks for migrations
  15. Prevent recursive trigger in PostgreSQL
  16. serial in postgres is being increased even though I added on conflict do nothing
  17. Using pyspark to connect to PostgreSQL
  18. Returning from a function with OUT parameter
  19. ERROR: permission denied for relation tablename on Postgres while trying a SELECT as a readonly user
  20. How do you create a random string that’s suitable for a session ID in PostgreSQL?
  21. PL/pgSQL functions: How to return a normal table with multiple columns using an execute statement
  22. Update timestamp when row is updated in PostgreSQL
  23. Postgresql query array of objects in JSONB field
  24. How to add a conditional unique index on PostgreSQL
  25. PostgreSQL INSERT ON CONFLICT UPDATE (upsert) use all excluded values
  26. input file appears to be a text format dump. Please use psql
  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