Cannot connect to Server (login) through pgAdmin 3, says it failed to connect to DB
Results 1 to 4 of 4
  1. #1
    Member
    Join Date
    Apr 2010
    Posts
    30

    Default Cannot connect to Server (login) through pgAdmin 3, says it failed to connect to DB

    So basically I load up pgAdmin3, I click PostgreSQL 8.4 (localhost:5432) and it prompts for a password.

    I type in ' postgrespass ', it fails. So I'm thinking the pw I'm using is wrong, I then go into the pg_hba.conf file and change all md5 entries to trust. Meaning now I can use whatever password I would like, still no luck.

    NOW when I start HEM latest version, it says this error :

    ' The following error occurred when trying to open the dtabase: Failed to establish a connection to '127.0.0.1'.

    I click OK, the Database Control Panel comes up, here's the current settings
    Server Name : 172.0.0.1
    Port Number : 5432
    Login Name : postgres
    Password : postgrespass, password, admin, etc (it doesn't matter)

    I click ' Connect ' and receive this,

    ' A connection to PostgreSQL could not be made. Would you like to have HM attempt to start the service? '

    I click ' Yes ', receive this,

    ' Sorry, Holdem Manager was unable to start the service '

    I click ' Ok ', receive this,

    ' Holdem Manager has started the service. Please try again. '

    After clicking OK, I try connecting once more and see these same messages follow.

    Could someone please explain what is going on with my DB? I recently changed my IP from dynamic to static, but that shouldn't matter since it uses a loopback address anyway (127.0.0.1).

    I have one firewall which allows PostgreSQL/HEM full functionality within the network and have no blockages. I have even tried disabling the firewall with no improved results.

    I'm not sure where to even start with fixing this error, thanks for a response.

  2. #2
    HM Support netsrak's Avatar
    Join Date
    Feb 2009
    Location
    Germany
    Posts
    25,795

    Default

    Seems like you made something wrong with editing the conf file.
    Restore the original version and restart your postgresql service.

  3. #3
    Member
    Join Date
    Apr 2010
    Posts
    30

    Default

    Quote Originally Posted by netsrak View Post
    Seems like you made something wrong with editing the conf file.
    Restore the original version and restart your postgresql service.
    which conf file?

  4. #4
    HM Support netsrak's Avatar
    Join Date
    Feb 2009
    Location
    Germany
    Posts
    25,795

    Default

    The file you changed as you explained in your 1st post - pg_hba.conf

Similar Threads

  1. Failed to connect to server
    By suhleafs in forum Manager General
    Replies: 3
    Last Post: 09-12-2010, 11:58 PM
  2. Can't connect to the server...
    By blackrain17 in forum Manager General
    Replies: 2
    Last Post: 09-09-2010, 02:17 AM
  3. Replies: 4
    Last Post: 09-08-2010, 03:58 AM
  4. Failed to connect to 127.0.01
    By Nairb in forum Manager General
    Replies: 5
    Last Post: 01-05-2010, 05:13 PM
  5. Replies: 3
    Last Post: 02-08-2009, 08:07 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •