“psql: could not connect to server: Connection refused” Error when connecting to remote database

cd /etc/postgresql/9.x/main/

open file named postgresql.conf

sudo vi postgresql.conf

add this line to that file

listen_addresses = '*'

then open file named pg_hba.conf

sudo vi pg_hba.conf

and add this line to that file

host  all  all 0.0.0.0/0 md5

It allows access to all databases for all users with an encrypted password

restart your server

sudo /etc/init.d/postgresql restart

Related Posts:

  1. Postgresql: Scripting psql execution with password
  2. How to exit from PostgreSQL command line utility: psql
  3. psql: FATAL: database “” does not exist
  4. PostgreSQL: Show tables in PostgreSQL
  5. PostgreSQL “DESCRIBE TABLE”
  6. Psql could not connect to server: No such file or directory, 5432 error?
  7. Getting error: Peer authentication failed for user “postgres”, when trying to get pgsql working with rails
  8. What is the format for the PostgreSQL connection string / URL?
  9. “use database_name” command in PostgreSQL
  10. PSQLException: current transaction is aborted, commands ignored until end of transaction block
  11. psql: FATAL: Ident authentication failed for user “postgres”
  12. fe_sendauth: no password supplied
  13. How can I drop all the tables in a PostgreSQL database?
  14. How to restart PostgreSQL in Ubuntu 18.04
  15. FATAL: password authentication failed for user “postgres” (postgresql 11 with pgAdmin 4)
  16. PostgreSQL: Remotely connecting to Postgres instance using psql command
  17. postgresql duplicate key violates unique constraint
  18. How to change PostgreSQL user password?
  19. No function matches the given name and argument types
  20. PostgreSQL error: Fatal: role “username” does not exist
  21. psql: command not found Mac
  22. How to change PostgreSQL user password?
  23. eroku “psql: FATAL: remaining connection slots are reserved for non-replication superuser connections”
  24. Permission denied for relation
  25. postgres does not know where to find server configuration
  26. input file appears to be a text format dump. Please use psql
  27. PG COPY error: invalid input syntax for integer
  28. Postgres: INSERT if does not exist already
  29. What’s the default superuser username/password for postgres after a new install?
  30. How to see active connections and “current activity” in PostgreSQL 8.4
  31. pg_dump and pg_restore: input file does not appear to be a valid archive
  32. Cannot connect to the Docker daemon at unix:/var/run/docker.sock. Is the docker daemon running?
  33. How to find which version of TensorFlow is installed in my system?
  34. ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  35. error: command ‘gcc’ failed with exit status 1 while installing eventlet
  36. “Couldn’t find a file descriptor referring to the console” on Ubuntu bash on Windows
  37. What is this JavaScript “require”?
  38. What is this JavaScript “require”?
  39. How to establish ssh key pair when “Host key verification failed”
  40. Why does the terminal show “^[[A” “^[[B” “^[[C” “^[[D” when pressing the arrow keys in Ubuntu?
  41. How to solve “Kernel panic – not syncing – Attempted to kill init” — without erasing any user data
  42. “E: Unable to locate package python-pip” on Ubuntu 18.04 [duplicate]
  43. Failed to get D-Bus connection: Operation not permitted
  44. Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]
  45. After installing with pip, “jupyter: command not found”
  46. using pip3: module “importlib._bootstrap” has no attribute “SourceFileLoader”
  47. Failed to start mongod.service: Unit mongod.service not found
  48. gpg: no valid OpenPGP data found
  49. What is the default password for Postgres
  50. Ubuntu ‘-bash: nano: command not found’
  51. Unable to install gem – Failed to build gem native extension – cannot load such file — mkmf (LoadError)
  52. missing FROM-clause entry for table
  53. Unable to locate package libapache2-mod-php7
  54. Laravel 5.2 Storage::makeDirectory($dir) is not creating directory
  55. Valgrind permission denied on file
  56. Package php5 have no installation candidate (Ubuntu 16.04)
  57. pip connection failure: cannot fetch index base URL http://pypi.python.org/simple/
  58. “extra data after last expected column” while trying to import a csv file into postgresql
  59. postgresql: error duplicate key value violates unique constraint
  60. nginx – nginx: [emerg] bind() to [::]:80 failed (98: Address already in use)
  61. Unable to establish SSL connection upon wget on Ubuntu 14.04 LTS
  62. pg_ctl: no database directory specified and environment variable PGDATA unset
  63. Postgres Error: More than one row returned by a subquery used as an expression
  64. No module named ‘openpyxl’ – Python 3.4 – Ubuntu
  65. Telnet [Unable to connect to remote host: Connection refused]
  66. How to Install pip for python 3.7 on Ubuntu 18?
  67. When I run `npm install`, it returns with `ERR! code EINTEGRITY` (npm 5.3.0)
  68. How to verify if nginx is running or not?
  69. C++ error: undefined reference to ‘clock_gettime’ and ‘clock_settime’
  70. PostgreSQL create table if not exists
  71. make -j 8 g++: internal compiler error: Killed (program cc1plus)
  72. Firewalld is not running [closed]
  73. wget: unable to resolve host address `http’
  74. PostgreSQL visual interface similar to phpMyAdmin?
  75. pdflatex not found. pdflatex is needed for pdf output
  76. java.lang.ClassNotFoundException: org.postgresql.Driver, Android
  77. PIP Could not find any downloads that satisfy the requirement SQLAlchemy
  78. GROUP BY and COUNT using ActiveRecord
  79. Removing all installed OpenCV libs
  80. Getting a 500 Internal Server Error on Laravel 5+ Ubuntu 14.04
  81. Why can’t I print to terminal with my python script?
  82. how to search for a directory from the terminal in ubuntu
  83. whats the meaning of curl “-s” and “-m”
  84. What are the functional differences between .profile .bash_profile and .bashrc
  85. Difference in sites-available vs sites-enabled vs conf.d directories (Nginx)?
  86. How to view all ssl certificates in a bundle?
  87. GRANT SELECT to all tables in postgresql
  88. Can you run Docker natively on the new Windows 10 (Ubuntu) bash userspace?
  89. How do I reattach to Ubuntu Server’s ‘do-release-upgrade’ process?
  90. Postgresql: what does GRANT ALL PRIVILEGES ON DATABASE do?
  91. Postgres equivalent to MySQL’s \G?
  92. Postgres equivalent to MySQL’s \G?
  93. dpkg-reconfigure: unable to re-open stdin: No file or directory
  94. Heartbleed: how to reliably and portably check the OpenSSL version?
  95. Centos 7 save iptables settings
  96. How to open port for a specific IP address with firewall-cmd on CentOS? [duplicate]
  97. Apache2 config variable is not defined
  98. Automate the installation of postfix on Ubuntu
  99. What is the debian-sys-maint MySQL user (and more)?
  100. apache2: Could not reliably determine the server’s fully qualified domain name, using 127.0.1.1 for ServerName

Leave a Comment