?
Solved

remote management in pgAdmin III

Posted on 2005-04-27
3
Medium Priority
?
429 Views
Last Modified: 2013-12-03
Hi everybody,
I have a problem with remote management in pgAdmin III. I have a PostgreSQL Server on a PC(Linux redhat-9) in the LAN and I want mange it through another PC of the same LAN, but when I try to connect at the PostgreSQL Server through pgAdmin III this error is shown me:
ERROR : Error connecting to the server: could not connect to server: Connection refused (0x0000274D/10061)
Is the server running on host "192.168.0.200" and accepting
TCP/IP connections on port 5432?

The server is either not running on the host or not accepting connections on 192.168.0.200, the error message is very precise.
Check listen_addresses in postgresql.conf.

Thanks to you.....


0
Comment
Question by:Mohan_Hasa
1 Comment
 
LVL 22

Accepted Solution

by:
earth man2 earned 280 total points
ID: 13875395
Look in your postgresql.conf file for :-

listen_addresses = 'localhost,192.168.0.200'    # what IP interface(s) to listen on;
                                # defaults to localhost, '*' = any
port = 5432

Modify pg_hba.conf file to give required access, see documentation
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Best database to use for Maps is PostgreSQL. This is an open source database. Comes as a package with most Linux OS. For more info visit the following site: http://www.postgresql.org/ (http://www.postgresql.org/) This requires some add-o…
By, Vadim Tkachenko. In this article we’ll look at ClickHouse on its one year anniversary.
Steps to create a PostgreSQL RDS instance in the Amazon cloud. We will cover some of the default settings and show how to connect to the instance once it is up and running.
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
Suggested Courses

594 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question