PDA

View Full Version : Problem after format



crusherusher
06-14-2011, 10:28 AM
I did format, and my problem is:
1. Im trying instal HM + Postgre, but I can't, and don't know why. This is my details, maybe it will help.

Output folder: C:\Program Files\PSQLINSTALL
top level install dir -->C:\Program Files
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: 0
firewall not 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\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:\Program Files\PostgreSQL\8.4 --> C:\Program Files\PostgreSQL\8.4-prev-2011-17-May-10-31-43
Create folder: C:\Program Files\PostgreSQL\8.4-prev-2011-17-May-10-31-43
Moving files: C:\Program Files\PostgreSQL\8.4\*.* to C:\Program Files\PostgreSQL\8.4-prev-2011-17-May-10-31-43\
Remove folder: C:\Program Files\PostgreSQL\8.4\
renamed dir
wrote testfile
Delete file: C:\Program Files\PostgreSQL\testfile
Extract: postgresql-8.4.7-1-windows.exe... 100%
Execute: "C:\Program Files\PSQLINSTALL\postgresql-8.4.7-1-windows.exe" --mode unattended --superpassword postgrespass
postgres installdir: C:\Program Files\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


2. Before format someone tell me I have to copy all PostgreSQL 8.4 folder to keep data base, I did this and what I have to do now to back my data base?

Patvs
06-14-2011, 10:38 AM
First of all try get the PostgreSQL server running.
Turn on 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 HoldemManager with the full installer: full installer @ http://www.holdemmanager.com/Downloads/Holdem_Manager_Setup.exe
(don't install PostgreSQL, just HoldemManager)


Install PostgreSQL manually with this installer: Download PostgreSQL | EnterpriseDB (http://www.enterprisedb.com/products-services-training/pgdownload)

Let me know if you any error during the installation with the 8.4.8 installer.

Password is: postgrespass
If it won't accept the password during the installation, delete the postgres user.

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.

crusherusher
06-14-2011, 11:53 AM
I'm in services but I don't see "postgressql" nowhere...

Patvs
06-14-2011, 12:18 PM
In services find: secondary logon (which must be started)

Then install PostgreSQL.

If you successfully install PostgreSQL, it will also be added to services.
Check in services if it's stopped (not running) or started (running)

crusherusher
06-14-2011, 02:41 PM
Holdem manager is working, but my second question is:

Before format I did copy all PostgresSQL folder, how can I back my all data base?

Patvs
06-14-2011, 06:54 PM
Were you using SQL 8.3 or 8.4 before?

Move the PostgreSQL/8.x/data folder (your backup) to the existing location.
Then reinstall PostgreSQL to that location. (again you may need to delete the postgres user first).

Use the manual installer from Download PostgreSQL | EnterpriseDB (http://www.enterprisedb.com/products-services-training/pgdownload).

If you used SQL 8.3 before, also first install SQL 8.3 (since 8.3 is not compatible with 8.4)

----

There is a 50% chance it will detect the old data folder.
If you get any ERROR, there likely was a corruption in the old database, and it will not be able to connect to it.

Instead, reimport the original handhistories into an empty database.

crusherusher
06-15-2011, 05:26 PM
I ran holdem manager with new data base, and after this I coped my "data" from old base and foldet to new data folder. I deteled user from "command" and instal new postgres 8.4 install (last data base was 8.4 also).

Now I can't open holdem manager, because I have standart problem with error connection to 127.0.0.1 , help?!

Patvs
06-15-2011, 06:50 PM
If it won't connect to the old database, there was a corruption in the old database.

Moving back a PostgreSQL/data folder rarely works.
If you want to perform a backup, read: http://faq.holdemmanager.com/questions/72/Backup%26RestoreDatabase


For now, just create a new empty database (first delete the corrupt data folder, then reinstall PostgreSQL again) and reimport the original handhistories.