PDA

View Full Version : Problem instal postgres : come back :(



Flola
11-28-2011, 04:22 PM
Hello, I come back, I didn't find any solution to reinstall postgres. I try version 2, 3, 4 (combo). Always the same problem : not connecting.

I try so many things written like here :

This is usually a firewall or windows update issue.

First try to reboot.

If no help, try this:

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

Start > Programs > PostgreSQL > 8.x > Start Service

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

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

Please try following these FAQs, step by step:

Done, done and done. I know, almost, how unstall postgres correctly...

I look in Event observator, here is a log with a problem with Postgres :

- <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
- <System>
<Provider Name="PostgreSQL" />
<EventID Qualifiers="0">0</EventID>
<Level>4</Level>
<Task>0</Task>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2011-11-27T10:44:31.000Z" />
<EventRecordID>76608</EventRecordID>
<Channel>Application</Channel>
<Computer>PC-de-Florent</Computer>
<Security />
</System>
- <EventData>
<Data>Dépassement du délai pour le démarrage du serveur</Data>
</EventData>
</Event>

"Dépassement du délai pour le démarrage du serveur" means : "Timeout for server startup"

Thank you...

Patvs
11-29-2011, 06:00 AM
Turn on the secondary Logon. The secondary logon service is a standard windows service which is available on every windows computer. 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.



Install 8.2: http://wwwmaster.postgresql.org/download/mirrors-ftp/binary/v8.2.21/win32/postgresql-8.2.21-1.zip to port 5433
With these install instructions: http://faq.holdemmanager.com/questions/70/ReinstallPostgreSQL

Which Operating System, Firewall, and Anti-Virus are you using?

Please update to the latest beta - http://www.holdemmanager.com/Downloads/HmUpdate.exe

For W7 and Vista you must set \holdem manager\dbcontrolpanel.exe, holdemmanager.exe and hmhud.exe are started as administrator. Run the windows explorer and navigate to your Holdemmanager installation directory. Right click the executables and select properties... then select "Run as admin" from the compatibility tab.

Add exceptions to the windows firewall for holdemmanager.exe and hmhud.exe, even if the firewall is turned off. If you have a 3rd party firewall, do the equivalent or uninstall it temporarily.

Make sure your video card drivers and windows auto updates are fully updated. Make sure you have Microsoft .NET Framework 3.5 SP1 (or later for w7) installed.

Flola
12-01-2011, 03:56 PM
Thank you, but still the same problem.


Turn on the secondary Logon. The secondary logon service is a standard windows service which is available on every windows computer. 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.
I check it, it's on.



Install 8.2: http://wwwmaster.postgresql.org/download/mirrors-ftp/binary/v8.2.21/win32/postgresql-8.2.21-1.zip to port 5433
With these install instructions: http://faq.holdemmanager.com/questions/70/ReinstallPostgreSQL
I try with port 5433 or 5432 with theses instructions.



Which Operating System, Firewall, and Anti-Virus are you using?
I have Vista. I use only windows firewall. I unstalled Avast 10 days ago.



Please update to the latest beta - http://www.holdemmanager.com/Downloads/HmUpdate.exe
It's done.



For W7 and Vista you must set \holdem manager\dbcontrolpanel.exe, holdemmanager.exe and hmhud.exe are started as administrator. Run the windows explorer and navigate to your Holdemmanager installation directory. Right click the executables and select properties... then select "Run as admin" from the compatibility tab.
Done.


Add exceptions to the windows firewall for holdemmanager.exe and hmhud.exe, even if the firewall is turned off.
Done and I stop windows firewall service.


If you have a 3rd party firewall, do the equivalent or uninstall it temporarily.
No other firewall.


Make sure your video card drivers and windows auto updates are fully updated. Make sure you have Microsoft .NET Framework 3.5 SP1 (or later for w7) installed.
Done...

But still the same problem. With postgres 2, I cant start the service : "you do not have sufficient privileges for starting system services".

I dont understand, i have HEM since 2009 and i dont meet a problem like that, so long to solve.

Flola
12-01-2011, 04:40 PM
I tried on another PC (portable, Vista...), I succed to install HEM in 3 minutes, grrr... Without turn off firewall or windows defender... I dont understand what s the problem on my main PC.

Patvs
12-01-2011, 10:09 PM
Turn off User Account Control: How to Disable and Turn Off UAC in Windows 7 « My Digital Life (http://www.mydigitallife.info/2008/12/30/how-to-disable-and-turn-off-uac-in-windows-7/)
And reboot.
Is Vista Update to Service Pack 2?
Run a manual Windows Update and install ALL updates.


Retry: http://ftp.postgresql.org/pub/binary/v8.2.22/win32/postgresql-8.2.22-1.zip
At which stage during the 8.2 installation will you get an error?

Flola
12-02-2011, 02:18 PM
Turn off User Account Control: How to Disable and Turn Off UAC in Windows 7 « My Digital Life (http://www.mydigitallife.info/2008/12/30/how-to-disable-and-turn-off-uac-in-windows-7/)
And reboot.
Already done


Is Vista Update to Service Pack 2?
Run a manual Windows Update and install ALL updates.
I didn t have Service pack 2 but now, it s ok, it s install.


Retry: http://ftp.postgresql.org/pub/binary/v8.2.22/win32/postgresql-8.2.22-1.zip
At which stage during the 8.2 installation will you get an error?
I tried again, but still the same problem :
http://img15.hostingpics.net/pics/2969421310.jpg (http://www.hostingpics.net/viewer.php?id=2969421310.jpg)
"fails to start Postgres service. Make sure you have sufficient privileges to start system services".

I tried to install not in Program files but in C: but it's still the same problem.

I test ping 127.0.0.1, it seems to be ok :
"Ping de 127.0.0.1 :

PING 127.0.0.1 (127.0.0.1) 56(84) bytes of data.
64 bytes from 127.0.0.1: icmp_seq=1 ttl=64 time=0.022 ms
64 bytes from 127.0.0.1: icmp_seq=2 ttl=64 time=0.016 ms
64 bytes from 127.0.0.1: icmp_seq=3 ttl=64 time=0.021 ms
64 bytes from 127.0.0.1: icmp_seq=4 ttl=64 time=0.018 ms
64 bytes from 127.0.0.1: icmp_seq=5 ttl=64 time=0.030 ms

--- 127.0.0.1 ping statistics ---
5 packets transmitted, 5 received, 0% packet loss, time 3999ms
rtt min/avg/max/mdev = 0.016/0.021/0.030/0.006 ms"

Flola
12-02-2011, 04:16 PM
When i try to install Postgre 4 with the combo, I have this :

http://img11.hostingpics.net/pics/6201387415.jpg (http://www.hostingpics.net/viewer.php?id=6201387415.jpg)

Patvs
12-03-2011, 05:57 AM
Please schedule a remote support session with our support. Email support@holdemmanager.net, with a link to this thread and your forum name, so we can setup a Teamviewer (http://www.holdemmanager.net/teamviewer) session.

stock1010
01-07-2012, 08:04 AM
I need help!
I try to install HM2-trial, to me an idea about software.
Download, installation begins, but towards the end I sent that, I'm sorry but Postgre Sql can not be installed.
I installed separately HM2, and tried to install the H Postgre manager ... same situation, what happens? that is the cause?

Patvs
01-07-2012, 06:53 PM
Turn on the secondary Logon. The secondary logon service is a standard windows service which is available on every windows computer. 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.


Try installing PostgreSQL separately with the 8.4.x installer from PostgreSQL: Welcome (http://www.postgresql.org)

stock1010
01-08-2012, 05:06 AM
I accessed administrative tools / services, and dont work.
dbpass password, postgrespass not valid

Patvs
01-08-2012, 11:36 AM
click on Start and go to Programs -> Accessories -> Command Prompt

* If you are on Vista, rightclick and choose "Run as Administrator".


A black box should appear. Type 'net user postgres /delete' (without the quotes) and press enter.

The user is now deleted and you can (re)install PostgreSQL.

/-


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.
This means: if you have Russian (or French, or else) Windows - your PC name possibly contains "non-english" letters.
Like "????-PC" or "Rene-PC"
The same with windows username. Or spaces in the name.
Postgres doesn't like that - and won't run as a result of it.
3) Secondary logon service must be set to "Autostart".
This is a standard windows service which is available on every windows computer. In the latest versions it is not started automatically. You need to start it via control panel > administrative tools > services.
4) UAC = OFF ( How to Disable and Turn Off UAC in Windows 7 � My Digital Life (http://www.mydigitallife.info/2008/12/30/how-to-disable-and-turn-off-uac-in-windows-7/) )
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 Download PostgreSQL | EnterpriseDB (http://www.enterprisedb.com/products-services-training/pgdownload#windows)
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 install 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 /del
exactly as shown. You should get a confirmation if it was successful.
11) Run all pokerclients "as admin" too.




--




Then reinstall PostgreSQL with the 8.4. installer from PostgreSQL: Welcome (http://www.postgresql.org)
If 8.4 doesn't run, try 8.2: http://ftp.postgresql.org/pub/binary/v8.2.22/win32/postgresql-8.2.22-1.zip