Cant connect to postgres
Results 1 to 5 of 5
  1. #1
    Senior Member SW_Kaizer's Avatar
    Join Date
    Feb 2013
    Posts
    169

    Default Cant connect to postgres

    was working fine then all of a sudden i cant connect ot postgres sql, get the error message:

    errorPGSQL.JPG

    have 9.0 intalled, has been fine for ages and made no major changes apart from update HEM2 earlier to latest version which i would share if i could start HEM2 but i just get to the setup wizard and everythings broke.

    in task manager the service is stopped, and i can't start it.
    Last edited by SW_Kaizer; 01-03-2015 at 06:00 PM.

  2. #2
    HM Support Patvs's Avatar
    Join Date
    Feb 2009
    Location
    Amsterdam, the Netherlands
    Posts
    33,523

    Default

    This is usually a firewall or windows update issue.

    First try to reboot.

    If no help, try this:

    Start > Programs > PostgreSQL > 9.x > Stop Service

    Start > Programs > PostgreSQL > 9.x > Start Service

    If that doesnt help delete the \postgresql\9.x\data\postmaster.pid file, if you see it. And reboot.


    If that doesn't help you will have to reinstall PostgreSQL completely.
    (if 9.0 won't install anymore, try installing a different version to a different port, for example 9.2 to port 5433)
    Participate in the Beta release of the newest Hold'em Manager version: HM Cloud. Sign-up HERE.

    If you would like to leave some feedback to help us improve the quality of the solutions, and/or the support quality you received, - you can do this here

  3. #3
    Senior Member SW_Kaizer's Avatar
    Join Date
    Feb 2013
    Posts
    169

    Default

    Quote Originally Posted by Patvs View Post
    This is usually a firewall or windows update issue.

    First try to reboot.

    If no help, try this:

    Start > Programs > PostgreSQL > 9.x > Stop Service

    Start > Programs > PostgreSQL > 9.x > Start Service

    If that doesnt help delete the \postgresql\9.x\data\postmaster.pid file, if you see it. And reboot.


    If that doesn't help you will have to reinstall PostgreSQL completely.
    (if 9.0 won't install anymore, try installing a different version to a different port, for example 9.2 to port 5433)
    tried to use the

    "Start > Programs > PostgreSQL > 9.x > Stop Service

    Start > Programs > PostgreSQL > 9.x > Start Service"

    method but no where i can see it, see this screenshotIMG_2480.JPG

    So then i tried using PG admin assitant to start service, get a password popup then this error message: 1.JPG

    So next i looked in task manager and it says the postgres service is "starting" - not sure what that means???

    Anyway looked for the \postgresql\9.x\data\postmaster.pid file but only found a postmaster.opts file. Is that any good to delete ?

    Here are my excluded firewall locations from microsoft security essentials, anything stand out there to you?
    3.JPG

    Anyway i have a database i am desperate to save, it contains a ton of really valuable notes. Please help me save it
    Last edited by SW_Kaizer; 01-04-2015 at 12:09 AM.

  4. #4
    Senior Member SW_Kaizer's Avatar
    Join Date
    Feb 2013
    Posts
    169

    Default

    Is there any way to save all the notes from my current DB ???

    edit: WORKING the pid file mysteriously appeared (wasnt there last night or today ?!) deleted it and that sorted it out, have backed up DB now, anything else i should do now ?
    Last edited by SW_Kaizer; 01-04-2015 at 02:34 PM.

  5. #5
    *** HM3! *** fozzy71's Avatar
    Join Date
    Jun 2005
    Location
    HM Support
    Posts
    32,803

    Default

    Do not delete the .opts file.

    1) Uninstall PostgreSQL from the Windows Control Panel.


    2) Run the command - start > programs > accessories > command prompt > right-click > run as administrator and type the following and then press enter:


    net user postgres /delete


    3) You should get a successfully completed response if done correctly. If you get a permission type error you likely didnt run it as administrator as explained above.


    4) Reboot your PC


    5) Install the same version of PostgreSQL as your previous database using these instructions - http://hm2faq.holdemmanager.com/ques...rving+database

    If you still have the postgresql 9.0 installer in your downloads folder from postgresql.org use that and make sure you pick the proper \data directory when prompted if yours was in a non-default location.

Similar Threads

  1. Can't connect to postgres
    By tilteduser in forum Bug Reports
    Replies: 17
    Last Post: 05-09-2012, 11:21 PM
  2. Replies: 1
    Last Post: 08-11-2011, 08:57 PM
  3. Postgres cant connect
    By foldforchips in forum Manager General
    Replies: 5
    Last Post: 04-09-2011, 07:55 AM
  4. Cannot connect to postgres
    By Chillypill in forum Manager General
    Replies: 1
    Last Post: 12-12-2010, 05:48 AM
  5. cannot connect to postgres 127.0.0.1
    By zindinon in forum Manager General
    Replies: 14
    Last Post: 11-18-2010, 07:39 AM

Posting Permissions

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