Error Instalar PostgreSQL
Page 1 of 2 12 LastLast
Results 1 to 10 of 13
  1. #1
    HM2 Shark Tank Member Jorge_397's Avatar
    Join Date
    Apr 2013
    Posts
    63

    Default Error Instalar PostgreSQL

    Hi, I installed windows 10 and I have an error when installing
    PostgreSQL.


    I've tried installing version 8.4 that comes with hm2 and this error:
    Output folder: C:\Program Files (x86)\PSQLINSTALL
    top level install dir -->C:
    Is admin account
    fs=NTFS
    .NET found
    Extract: TestFirewall.exe... 100%
    Extract: TestFirewall.exe.config... 100%
    Antivirus Installed: False
    test antivirus returned 0
    seclogon error status: 0
    seclogon status: 4
    firewall enabled: 1
    firewall port 5432 enabled: 1
    port 5432 already enabled
    postgresql error status: 1060
    postgresql status: 0
    starting pgsql-8.3
    postgresql error status: 1060
    postgresql status: 0
    postgresql error status: 1060
    postgresql status: 0
    starting postgresql-8.4
    postgresql error status: 1060
    postgresql status: 0
    postgres installdir: C:\Program Files (x86)\PSQLINSTALL
    ==================== running PsqlTestClient
    try userid: postgres
    try pass: postgrespass
    try pass: postgrespass
    Connection to database failed: -->could not connect to server: Connection refused (0x0000274D/10061)
    Is the server running on host "127.0.0.1" and accepting
    TCP/IP connections on port 5432?
    <--error
    1
    testclient return status: 1
    testclient return from file: 1
    ==================== finished PsqlTestClient
    granting write permission on top level postgres directory
    found dir
    try rename C:\PostgreSQL --> C:\PostgreSQL-prev-2017-20-Apr-10-21-22
    Create folder: C:\PostgreSQL-prev-2017-20-Apr-10-21-22
    Moving files: C:\PostgreSQL\*.* to C:\PostgreSQL-prev-2017-20-Apr-10-21-22\
    Remove folder: C:\PostgreSQL\
    renamed dir
    wrote testfile
    Create folder: c:\postgreSQL
    Execute: "C:\Program Files (x86)\PSQLINSTALL\postgres84.exe" --mode unattended --superpassword postgrespass --prefix c:\postgreSQL --datadir c:\postgreSQL\data
    postgres installdir: C:\Program Files (x86)\PSQLINSTALL
    ==================== running PsqlTestClient
    try userid: postgres
    try pass: postgrespass
    try pass: postgrespass
    Connection to database failed: -->could not connect to server: Connection refused (0x0000274D/10061)
    Is the server running on host "127.0.0.1" and accepting
    TCP/IP connections on port 5432?
    <--error
    1
    testclient return status: 1
    testclient return from file: 1
    ==================== finished PsqlTestClient


    Then I have tried to manually install version 9.6 and measure this error of the images. What I can do??

    1ERROR.PNG


    2ERROR.png

  2. #2
    You're out! udbrky's Avatar
    Join Date
    Jul 2008
    Posts
    20,898

    Default

    Uninstall PostgreSQL & try the following steps:

    1) Run cmd.exe as Admin (Start > Search 'cmd' > Right-Click > Run As Admin)
    2) in CMD window run (type the code then hit Enter key) following command:
    net user postgres /del
    3) Reboot PC
    4) after reboot open cmd.exe again & run following commands:
    Code:
    net user postgres postgrespass /add
     net localgroup Administrators postgres /add
     net localgroup Users postgres /delete
     runas /user:postgres cmd.exe
    When it asks about password please input postgrespass & don`t worry if you don`t see any new symbols\inputs in cmd window. If you did all steps right then you should get new cmd window for postgres user.

    5) Download PostgreSQL installer (http://get.enterprisedb.com/postgres...-1-windows.exe) & move (copy/paste) it from the \Downloads folder to C:\
    6) in new cmd window for postgres user run following commands:
    cd c:\
    start postgresql-8.4.22-1-windows.exe
    Regards udbrky (Chris)

  3. #3
    HM2 Shark Tank Member Jorge_397's Avatar
    Join Date
    Apr 2013
    Posts
    63

    Default

    I have done all the steps and it gives me this error of the image

    Windows 10 has postgresql.conf file problems.
    error5.PNG

  4. #4
    HM2 Shark Tank Member Jorge_397's Avatar
    Join Date
    Apr 2013
    Posts
    63

    Default

    The postgresql.conf file is not downloaded with the first installation

    The program can not read the file postgresql.conf because it is not.

    How can I solve the problem of the file postgresql.conf???????? I'm desperate, Help me please!!!!

  5. #5
    HM2 Shark Tank Member Jorge_397's Avatar
    Join Date
    Apr 2013
    Posts
    63

    Default

    Quote Originally Posted by Jorge_397 View Post
    The postgresql.conf file is not downloaded with the first installation

    The program can not read the file postgresql.conf because it is not.

    How can I solve the problem of the file postgresql.conf???????? I'm desperate, Help me please!!!!
    PD:

    After much work on it I have come to the conclusion that the prostgres installer does not download the prostgres.conf file because the whole installation correctly does passwords, ports etc and at the end of everything when the final installation is already going to be done. Start the program jumps the error that the postgresql.conf file can not read.

    When the message appears I have not touched anything, I have gone to look in the indicated directory to see if this file is and is not, in the capeta "data" is only the folder "pg_log" and it is empty, There is the file postgresql. Conf



    The confguracion of my pc I think that is ok, deactivate UAC, firewall, Windows10 defend !!!! all

  6. #6
    HM2 Shark Tank Member Jorge_397's Avatar
    Join Date
    Apr 2013
    Posts
    63

    Default

    I have discovered that when installing prostgres this automatically creates a user on the pc that I have never created, the user creates it with the name of prostgres. This means that you do not recognize me as an administrator ??? it's very strange....

    error6.PNG

  7. #7
    You're out! udbrky's Avatar
    Join Date
    Jul 2008
    Posts
    20,898

    Default

    That's the Postgres user account and is necessary.

    What are your antivirus and firewall? Did you run the setup file as admin?

    Did you create the Postgres folder before and set the permissions on it?

    Make sure windows is fully updated until 'No New Important Updates are Found' (this may require multiple restarts and multiple 'check for updates'), including Internet Explorer (even if you use a different web browser).

    Which Operating System, Firewall, and Anti-Virus are you using? Many of those free Norton, Mcaffee, Comodo, Zonealarm, Avira, Avast, AVG, Bitdefender, etc, 'internet security' bundles can cause communication issues between Holdem Manager and PostgreSQL.

    Please do the following steps, so we can get your computer to a state that we know will work with Holdem Manager and we can rule out it being a security software issue:

    1) Uninstall any 3rd party security software bundles completely. Disabling them never fully disables them and they will continue to prevent communication in the background.
    2) Reboot your computer
    3) Enable Windows Firewall's recommended settings through your Control Panel, turn off Windows Defender, and add firewall exceptions for HM and SQL - Hold'Em Manager 2 FAQs - Poker Software :: Windows Firewall / Defender Problems
    4) Enable Windows Firewall's recommended settings through your Control Panel, turn off Windows Defender (unless you are using Windows 10, in which case it should be enabled), and add firewall exceptions for HM and SQL - Hold'Em Manager 2 FAQs - Poker Software :: Software Security Problems (Firewall)
    5) Install Microsoft Security Essentials (unless you are using Windows 10) for antivirus/malware protection and update it - https://support.microsoft.com/en-us/help/14210

    Please see the following guides for postgres related issues if you have further issues after installing.

    When installing, you may encounter an error referring to the database initialization. If so follow this part of the FAQ below:
    Hold'Em Manager 2 FAQs - Poker Software :: Can not Connect / Failed to Start PostgreSQL

    For other security software see here:
    Hold'Em Manager 2 FAQs - Poker Software :: Software Security Problems (Firewall)
    Regards udbrky (Chris)

  8. #8
    HM2 Shark Tank Member Jorge_397's Avatar
    Join Date
    Apr 2013
    Posts
    63

    Default

    I followed all the steps
    This is not the error "The database cluster initialization failed"
    The error is Unable to read the file postgresql.conf
    I always get this error
    What I can do?

  9. #9
    You're out! udbrky's Avatar
    Join Date
    Jul 2008
    Posts
    20,898
    Regards udbrky (Chris)

  10. #10
    Junior Member
    Join Date
    Aug 2017
    Posts
    2

    Default

    Hi Jorge,
    have you figured out this problem? I have the same issue but none of the solutions could help.

Similar Threads

  1. HM postgresql error
    By Bebik in forum General Support
    Replies: 1
    Last Post: 11-15-2011, 03:40 PM
  2. postgreSQL error
    By J. Bourne in forum Manager General
    Replies: 4
    Last Post: 10-29-2011, 01:37 AM
  3. PostgreSQL error
    By Biogaran in forum Manager General
    Replies: 2
    Last Post: 09-04-2011, 03:30 PM
  4. PostgreSQL Error
    By cha4zz in forum Manager General
    Replies: 2
    Last Post: 06-10-2010, 01:59 PM
  5. get postgresql error
    By demonseed in forum Manager General
    Replies: 3
    Last Post: 11-19-2008, 12:35 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
  •