Conversion of the database to postgresSQL

[SlaSh]

Hi,

I am running PT2 version 2.17.01g with PAH version beta 1.19.5. Everything works fine until a couple days. The problem is that PAH stats updating is very slow, or it seem doesn’t work.

I read somewhere in PT2 website that we have to compact the database frequently in order to makes the database run at it's optimal speed. I did. They also said that we have to “vaccum/analyse” the database, I didn’t. Here comes the real problem, I just can do this operation. In fact, I can’t convert the database to postgresSQL.

My postgresSQL setting is :
Port : 5432
Server : localhost
Username : postgres1 (and not postgres, Cf. note)
Password : “the password that I put when I install postgresSQL”
ODBC entry to use : postgresSQL ANSI
Encoding : SQL_ASC_II

And when I start the conversion, a message error appear (sorry can’t screenshot)
Database error
Error connecting to the default PostgreSQL database:
101 – SQLSTATE = 08001
Could not connect to server : Connection refused (0x0000274D/10061)
Is the server running on host “localhost” and accepting
TCP/IP connections on port 5432?

This could be because you have…
1. Entered the wrong user name/ password / server name / port. (everything should be ok..)
2. Not started the PostgreSQL database server. (dunno what is this..)
3. Not installed the PostgreSQL ODBC driver. (done)




Note : I unistall and reinstall PosgresSQL 8.2. I follow those steps http://www.pokertracker3.com/products/P ... nstallSQL2.
But for the service configuration step, when I reinstall the program, I forget the password for the account name : postgres. (is there anyway to retreve this password?). So I put a new name “postgres1” and a new password.

Another thing, I don’t know if this is a big deal but, I didn’t use the NTFS file system. I have read this in the postgreSQL FAQ : “It is recognised however, that on some systems such as developer's PCs, FAT partitions may be the only choice. In such cases, you can simply install PostgreSQL as normal, but without initialising the database cluster. When the installation has finished, manually run the 'initdb.exe' program on the FAT partition. Security and reliability will be compromised however, and any attempts to create tablespaces will fail.”

So I didn’t initialize the database cluster, howover I could find the ‘initdb.exe’

What should I do ? Thanks for your help.

SlaSh

[APerfect10]

[quote="SlaSh"x5b]Note : I unistall and reinstall PosgresSQL 8.2. I follow those steps http://www.pokertracker3.com/products/P ... nstallSQL2.
But for the service configuration step, when I reinstall the program, I forget the password for the account name : postgres. (is there anyway to retreve this password?). So I put a new name “postgres1” and a new password.[/quotex5b]

That is fine to create a new account. There is no way to recover your forgotten password but you can:

[list=1x5b][*x5b]Delete the service account and recreate it with a new password[/*:mx5b]
[*x5b]Set PostgreSQL so that it does not require a password to login[/*:mx5b][/list:ox5b]

[quotex5b]So I didn’t initialize the database cluster, howover I could find the ‘initdb.exe’[/quotex5b]

initdb is located in your PostgreSQL\8.2\bin directory and you need to run from the command prompt.

Best regards,

Derek