PDA

View Full Version : Problem with postgreSQL



axelaxelj
12-09-2011, 05:35 PM
I tried to use the comboinstaller for reinstalling postgreSQL but the installation stopped. So I tried to install v.8.3 manually and it worked fine, but I can still not open the database with HM.

Patvs
12-09-2011, 09:20 PM
On which port did you install SQL 8.3?
Run dbcontrolpanel.exe from the HoldemManager folder:
-connect to the database using the correct port settings
-create a new database--> start HoldemManager


If you can't connect, the PostgreSQL server isn't running properly. Try installing http://ftp.postgresql.org/pub/binary/v8.2.22/win32/postgresql-8.2.22-1.zip to a different port and connect to that instead.

axelaxelj
12-10-2011, 09:36 AM
On which port did you install SQL 8.3?

I skipped that part. I tried to use Port:5432 but it said it was already in use so I unchecked initialize database cluster


Run dbcontrolpanel.exe from the HoldemManager folder:
-connect to the database using the correct port settings
What is correct port settings? Now I use 5432 and can´t connect.


-create a new database--> start HoldemManager
How do I create a new database when I cannot open HM?


If you can't connect, the PostgreSQL server isn't running properly. Try installing http://ftp.postgresql.org/pub/binary...l-8.2.22-1.zip to a different port and connect to that instead.
I try port 5431 and then the installing is stopped where it says "Service "PostgreSQL Database Server 8.2 failed to start. Verify that you have sufficient privileges to start system services."

Patvs
12-10-2011, 10:35 AM
Which Operating System, Firewall, and Anti-Virus are you using?
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


Run a manual Windows Update and install ALL updates.
Then try reinstalling PostgreSQL 8.2 to port 5431.

axelaxelj
12-10-2011, 11:45 AM
Which Operating System, Firewall, and Anti-Virus are you using?
I have windows 7 with no firewall or Anti-virus


Turn off User Account Control: How to Disable and Turn Off UAC in Windows 7 « My Digital Life
and reboot
It is off already



Run a manual Windows Update and install ALL updates.
Done!


Then try reinstalling PostgreSQL 8.2 to port 5431.

I need to change account name to "postgres1"
Then I use "postgres1" as Super user name too and choose port 5431 and then it says the port is already is in use.
And when I try other port numbers I got the message "The specified data directory is not empty. If you have an existing database with the same major version number, you do not need to initialise a database cluster .."

Patvs
12-10-2011, 04:24 PM
Try 9.1 from PostgreSQL: Welcome (http://www.postgresql.org)
Install it to an unused port using these install instructions: http://faq.holdemmanager.com/questions/70/ReinstallPostgreSQL

axelaxelj
12-11-2011, 05:05 AM
In the installation of this they have pre-choosen the service account (postgres) and when I write in the passowrd (postgrespass) they say it is incorrect. What shall I do?

axelaxelj
12-14-2011, 06:59 PM
I need some more help here

Patvs
12-14-2011, 07:40 PM
Delete the postgres user first:
click on Start and go to Progr ams -> 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.
And it will accept: postgrespass

axelaxelj
12-14-2011, 08:22 PM
The installation worked but I can still not connect to the database in the databes control panel.

Patvs
12-14-2011, 09:11 PM
Is it running from a non default port?
Did you change the port from 5432--> to 5433?


Try 8.2 again: http://ftp.postgresql.org/pub/binary/v8.2.22/win32/postgresql-8.2.22-1.zip

axelaxelj
12-15-2011, 08:00 AM
Actullay I used port 5432, but now I re-installed with 5433 and I can still not connect. The installation of version 8.2 stops when it is on "Starting serivces"

Patvs
12-16-2011, 01:46 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.