remote postgresql 9.1 database access on windows platform

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Blessy Benigna
    New Member
    • May 2014
    • 1

    #1

    remote postgresql 9.1 database access on windows platform

    i have created a postgresql 9.1 database on a windows 7 OS. now i want to access it via another windows 7 OS pc using pgadminIII.On the client pc i have also installed pgadminIII as a client application for the database and when i am trying to add a new server using pgadminIII, after filling in the server name, hostname, username and password i get the following error:Server doesn't listen. could not connect to server: connection refused (0x0000274D/10061# is the server running on host "localhost" #::1) and accepting TCP/IP connection on port 5432. i still get the same error on the server pc if i add this line to my pg_hba file: host all all 0.0.0.0/0
    any help please
  • mHealth
    New Member
    • Jun 2014
    • 13

    #2
    host all all <ip address>/24 trust
    and in postgresql.conf change
    listen_addresse s='*'

    Comment

    Working...