Unable to connect PostgreSQL to remote database using pgAdmin

by

It is actually a 3 step process to connect to a PostgreSQL server remotely through pgAdmin3.

Note: I use Ubuntu 11.04 and PostgreSQL 8.4.

  1. You have to make PostgreSQL listening for remote incoming TCP connections because the default settings allow to listen only for connections on the loopback interface. To be able to reach the server remotely you have to add the following line into the file /etc/postgresql/8.4/main/postgresql.conf:

    listen_addresses=”*”

  2. PostgreSQL by default refuses all connections it receives from any remote address, you have to relax these rules by adding this line to /etc/postgresql/8.4/main/pg_hba.conf:

    host all all 0.0.0.0/0 md5

    This is an access control rule that let anybody login in from any address if he can provide a valid password (the md5 keyword). You can use needed network/mask instead of 0.0.0.0/0 .

  3. When you have applied these modifications to your configuration files you need to restart PostgreSQL server. Now it is possible to login to your server remotely, using the username and password.

More Related Contents:

  1. docker postgres pgadmin local connection
  2. In PostgreSQL, how to insert data with COPY command?
  3. pgAdmin III Why query results are shortened?
  4. How should I import data from CSV into a Postgres table using pgAdmin 3?
  5. Insert, on duplicate update in PostgreSQL?
  6. How does the search_path influence identifier resolution and the “current schema”
  7. Run batch file with psql command without password
  8. invalid byte sequence for encoding “UTF8”
  9. Postgresql: Conditionally unique constraint
  10. How do you use variables in a simple PostgreSQL script?
  11. How to switch databases in psql?
  12. Cannot create a database table named ‘user’ in PostgreSQL
  13. Postgresql Truncation speed
  14. Buffers (Circle) in PostGIS
  15. How to customize the configuration file of the official PostgreSQL Docker image?
  16. How to convert a postgres database to sqlite
  17. How does PostgreSQL perform ORDER BY with a b-tree index on the field?
  18. Error when setting n_distinct using a plpgsql variable
  19. Function to loop through and select data from multiple tables
  20. SQL query column does not exist error
  21. Switch role after connecting to database
  22. SQL Sub queries in check constraint
  23. When do Postgres column or table names need quotes and when don’t they?
  24. How can I get a list of all functions stored in the database of a particular schema in PostgreSQL?
  25. PostgreSQL how to concat interval value ‘2 days’
  26. Displaying image in Ireports using PostgreSql
  27. Postgres default sort by id – worldship
  28. Best way to install hstore on multiple schemas in a Postgres database?
  29. Loop through columns of RECORD
  30. How to drop PostgreSQL database through command line [closed]

Leave a Comment