PDA

View Full Version : Postgresproblems



El Helado
04-13-2011, 05:11 PM
I have succesfully installed HM and postgres 10 times+ on different computers and so on but having problems now. I previously had problems installing postgres but then I just made a new windows installation and installed it there instead. Now I want to go back to that old windows version and went back with the postgres-problem.

I uninstalled all postgres versions, deleted all referenses in the regedit and then made a new installment of postgres 8.4. I tried to install it on port 5345 instead of 5342 since that is the port where I installed it last time.

So now I get to the DB-screen and it says "A connection to postgresSQL could not be made. Would you like HM attempting to start the service?". I obviously press YES and then it just says "Sorry HM was unable to start the service.

What shall I do?

fopah
04-13-2011, 06:00 PM
This is usually a firewall or windows update issue and the following guide will help you to fix this problem.

Go to Start > Programs (or all programs) > PostgreSQL 8.x > choose Stop Service

Start > Programs (or all programs) > PostgreSQL 8.x and choose Start Service. This may take some time and a black dos window may appear while it�s starting. If it fails to start delete the C:\Program Files\postgresql\8.x\data\postmaster.pid file, if you see it. Do not delete any other files

Add exceptions to the windows firewall, even if it is off. If you have a 3rd party firewall, do the equivalent or uninstall it temporarily � http://faq.holdemmanager.com/questions/275/Windows+Firewall+%7B47%7D+Defender+Problems - Windows Firewall / Defender Problems

If none of those worked Please reboot and try following these FAQs, step by step:

1) http://faq.holdemmanager.com/questions/91/Can�t+Connect+%7B47%7D+Failed+to+Start+PostgreS QL+ Can�t Connect / Failed to Start PostgreSQL
2) Reinstall the same version of postgresql, using the same \data folder � http://faq.holdemmanager.com/questions/71/Reinstall+PostgreSQL+Preserving+Old+DatabaseReinst all PostgreSQL Preserving Old Database

Failing that you will probably have to reinstall PostgreSQL completely and reimport your archived hands using these instructions. Once you do this you won�t have access to the hands in the old database but since you can�t connect to the database your already in that situation. In the case it�s not possible to reconnect you can either contact the PostgreSQL forums who may be able to help with advanced connection issues or you can reinstall. I�ve listed 3 PostgreSQL forums below
PostgreSQL Help Forums (http://forums.devshed.com/postgresql-help-21/)
PostgreSQL (http://old.nabble.com/PostgreSQL-f759.html)
PostgreSQL - dBforums (http://www.dbforums.com/postgresql/)

1)Uninstall PostgreSQL via Control Panel > Programs & Features (Add/Remove Programs on XP).
2)Use our combo installer to reinstall PostgreSQL. Make sure you un-check Holdem Manager during installation. http://rvgsoftware.fileburst.com/Holdem_Manager_Setup.exe

If that installer fails to install PostgreSQL, please reinstall PostgreSQL using the following instructions:

The secondary logon service is a standard windows service which is available on every windows computer and is required to be running to install PostgreSQL. In the latest versions it is not started automatically. You need to start it via control panel > administrative tools > services. Starting it once should insure it works in the future also.

Go to Start > Programs > Accessories > Command Prompt > Right-Click > Run As Administrator
In the window that appears please type the following and press enter:

net user postgres /delete

Try installing this version of PostgreSQL � http://rvgsoftware.fileburst.com/Postgres_8.3.9-v1.0.7.exe
If that also fails Please follow step A again and try this version PostgreSQL: Choose a Mirror (http://wwwmaster.postgresql.org/download/mirrors-ftp/binary/v8.2.17/win32/postgresql-8.2.17-1.zip)

El Helado
04-16-2011, 09:05 PM
This is usually a firewall or windows update issue and the following guide will help you to fix this problem.

Go to Start > Programs (or all programs) > PostgreSQL 8.x > choose Stop Service

Start > Programs (or all programs) > PostgreSQL 8.x and choose Start Service. This may take some time and a black dos window may appear while it�s starting. If it fails to start delete the C:\Program Files\postgresql\8.x\data\postmaster.pid file, if you see it. Do not delete any other files


I assume you mean that we should go to "services" and stop all services? The first line doesnt really make sense otherwise.

El Helado
04-16-2011, 09:09 PM
Btw. I found that postgres isnt listed in the services and its probably due to the problem I have with installing. It says

Problem running post-install step. Installation may not complete correctly.

Error reading file
G:/Program/Postgresnewnew2/postgresql.conf

wltr
04-17-2011, 03:27 AM
I'm having this same problem. I've tryed to use Postgres 8.4 and 9.0 but the problem still continue. Well, it could be better I creat a another thread or I can "use" this? Because I have the same problem even the message at final of installation of Postgres.

Sarek
04-17-2011, 05:14 AM
If you have Win7 (or Vista), consider the following:
1) PC name must be in English and "in one word" - requires reboot after changing.
2) The same for Windows user name. If not - create new Win user with EN name and reboot PC for this user when install Postgres. And he must have admin rights. After installation you can kill this new user - his mission is completed.
3) Secondary logon service must be set to "Autostart"\
4) UAC = OFF
5) Disable firewall and antivirus when installing Postgres and HM. Or uninstall them at all.
6) All installations must run "as admin" (by right-click on file). And do them as first thing after PC reboot.
7) If you want to change install path for Postgres (or to set non-default folder for database cluster) - download "standalone" installation file from PostgreSQL: The world's most advanced open source database (http://www.postgresql.org).
8) If your Windows is not in English - you have to install Postgres not in default folder in Program_Files. Create new (example: c:\postgresql) first and select it when install.
9) Install Postgres and HM separarelly, one after one. As admin. If HM (when runs for the 1st time) says "no database" - simply create it via DBControlpanel.
10) If Postgres шnstall fails - after uninstalling don't forget to kill windows user named "postgres":
Go to Start > Programs > Accessories > Command Prompt > Right-Click > Run As Administrator
In the window that appears please type the following and press enter:
net user postgres /delete
exactly as shown. You should get a confirmation if it was successful.
11) Run all pokerclients "as admin" too.

El Helado
04-17-2011, 11:31 AM
If you have Win7 (or Vista), consider the following:
1) PC name must be in English and "in one word" - requires reboot after changing.
2) The same for Windows user name. If not - create new Win user with EN name and reboot PC for this user when install Postgres. And he must have admin rights. After installation you can kill this new user - his mission is completed.
3) Secondary logon service must be set to "Autostart"\
4) UAC = OFF
5) Disable firewall and antivirus when installing Postgres and HM. Or uninstall them at all.
6) All installations must run "as admin" (by right-click on file). And do them as first thing after PC reboot.
7) If you want to change install path for Postgres (or to set non-default folder for database cluster) - download "standalone" installation file from PostgreSQL: The world's most advanced open source database (http://www.postgresql.org).
8) If your Windows is not in English - you have to install Postgres not in default folder in Program_Files. Create new (example: c:\postgresql) first and select it when install.
9) Install Postgres and HM separarelly, one after one. As admin. If HM (when runs for the 1st time) says "no database" - simply create it via DBControlpanel.
10) If Postgres шnstall fails - after uninstalling don't forget to kill windows user named "postgres":
Go to Start > Programs > Accessories > Command Prompt > Right-Click > Run As Administrator
In the window that appears please type the following and press enter:
net user postgres /delete
exactly as shown. You should get a confirmation if it was successful.
11) Run all pokerclients "as admin" too.

You dont understand. We cannot fully install postgres, its saying


"Problem running post-install step. Installation may not complete correctly.

Error reading file
G:/Program/Postgresnewnew2/postgresql.conf "

If you check the services later on then you see that no postgres-service is created etc. I have tried 8.4 and 9.0 and this problem occurs with each installation.

wltr
04-17-2011, 11:24 PM
My OS is Windows XP SP3

netsrak
04-18-2011, 03:38 AM
@El Helado: which operating system. Is the windows secondary logon service running?
Please try to download and install postgresql 8.4 to a different folder / partition like c:\postgres

@wltr: XP usually has no such problems. You can try the manual installation like i wrote for El Helado.
Are you using any 3rd party firewall, anti-spyware, adaware, tuning or registry cleaning programs? And if yes which ones?

wltr
04-18-2011, 08:05 AM
@netsrak: I did the steps and works here. Thanks.

@El Helado: Try to follow step-to-step because to me it's worked. I hope you fix as soon your problem

This is usually a firewall or windows update issue and the following guide will help you to fix this problem.

Go to Start > Programs (or all programs) > PostgreSQL 8.x > choose Stop Service

Start > Programs (or all programs) > PostgreSQL 8.x and choose Start Service. This may take some time and a black dos window may appear while it�s starting. If it fails to start delete the C:\Program Files\postgresql\8.x\data\postmaster.pid file, if you see it. Do not delete any other files

Add exceptions to the windows firewall, even if it is off. If you have a 3rd party firewall, do the equivalent or uninstall it temporarily � http://faq.holdemmanager.com/questio...ender+Problems - Windows Firewall / Defender Problems

If none of those worked Please reboot and try following these FAQs, step by step:

1) http://faq.holdemmanager.com/questio...rt+PostgreSQL+ Can�t Connect / Failed to Start PostgreSQL

wltr
04-18-2011, 01:55 PM
I forgot to say that I installed the PostgreSQL 8.4 without holdem manager. I download the PostgreSQL at own website and installed.

El Helado
04-18-2011, 05:35 PM
If you have Win7 (or Vista), consider the following:
1) PC name must be in English and "in one word" - requires reboot after changing.
2) The same for Windows user name. If not - create new Win user with EN name and reboot PC for this user when install Postgres. And he must have admin rights. After installation you can kill this new user - his mission is completed.
3) Secondary logon service must be set to "Autostart"\
4) UAC = OFF
5) Disable firewall and antivirus when installing Postgres and HM. Or uninstall them at all.
6) All installations must run "as admin" (by right-click on file). And do them as first thing after PC reboot.
7) If you want to change install path for Postgres (or to set non-default folder for database cluster) - download "standalone" installation file from PostgreSQL: The world's most advanced open source database (http://www.postgresql.org).
8) If your Windows is not in English - you have to install Postgres not in default folder in Program_Files. Create new (example: c:\postgresql) first and select it when install.
9) Install Postgres and HM separarelly, one after one. As admin. If HM (when runs for the 1st time) says "no database" - simply create it via DBControlpanel.
10) If Postgres шnstall fails - after uninstalling don't forget to kill windows user named "postgres":
Go to Start > Programs > Accessories > Command Prompt > Right-Click > Run As Administrator
In the window that appears please type the following and press enter:
net user postgres /delete
exactly as shown. You should get a confirmation if it was successful.
11) Run all pokerclients "as admin" too.

The original file lets me choose where to install postgres and also lets me decide where the datafiles should be saved.

Btw, went to your link and CTRL+F standalone and also clicked on the 9-version but there isnt something labeled like that. Also made a googlesearch of "postgres standalone" and it only shows some version of 8.1 which is very old.

netsrak
04-19-2011, 03:50 AM
This is the latest 8.4 installer: Thank You... | EnterpriseDB (http://www.enterprisedb.com/postgresql-848-installers-win32?ls=Crossover&type=Crossover)

If that fails try 8.2: PostgreSQL: Choose a Mirror (http://wwwmaster.postgresql.org/download/mirrors-ftp/binary/v8.2.21/win32/postgresql-8.2.21-1.zip)

El Helado
04-23-2011, 11:23 AM
@El Helado: which operating system. Is the windows secondary logon service running?
Please try to download and install postgresql 8.4 to a different folder / partition like c:\postgres

@wltr: XP usually has no such problems. You can try the manual installation like i wrote for El Helado.
Are you using any 3rd party firewall, anti-spyware, adaware, tuning or registry cleaning programs? And if yes which ones?

Im using AVG. Btw, it says its unable to open G:/Program/Postgresnewnew2/postgresql.conf " but when I go to that folder there is no files there. Perhaps thats the problem?

Sarek
04-23-2011, 12:49 PM
Try to uninstall antivirus (disabling is not enough).

El Helado
04-24-2011, 11:18 AM
Try to uninstall antivirus (disabling is not enough).

Did that and rebooted my computer and the same error message showed up....

You are not up for a teamviewer-session?

Patvs
04-24-2011, 05:08 PM
Did you try installing 8.2 on port 5433?
8.2 should always run. Which error do you get during (or at the end of the) installation?

Also try 9.0.4 to port 5434. (64 bit if you have a 64 bit operation system)