PDA

View Full Version : postgres installation



dan233
01-30-2010, 03:02 PM
hi
just purcahsed a new pc (windows 7)
installing postgres throught the combo installer failed so
I m trying to install postgres 8.4 to my laptops D:drive seperately, as advised.
the following error message appears after the installation:
http://img96.imageshack.us/img96/3972/postgresproblem.png (http://img96.imageshack.us/i/postgresproblem.png/)
any ideas?

netsrak
01-31-2010, 07:30 AM
Please try Postgresql 8.3: http://www.enterprisedb.com/getfile.jsp?fileid=806

We don't know why but on some Windows 7 installations postgresql 8.4 fails to install.

dan233
01-31-2010, 03:35 PM
Please try Postgresql 8.3: http://www.enterprisedb.com/getfile.jsp?fileid=806

We don't know why but on some Windows 7 installations postgresql 8.4 fails to install.
hi
did what you said; installed postgressql 8.3
same problem:
http://img12.imageshack.us/img12/7372/postgresprob2.png (http://img12.imageshack.us/i/postgresprob2.png/)
I had uninstalled the other version using revo and removed postgres user through the command promt as admin previous to this..

fozzy71
01-31-2010, 07:22 PM
Which Firewall, and Anti-Virus are you using?

Try turning down the UAC setting and reboot. Make sure you right-click > run as administrator when installing .exe files.

If you are still having problems, try our old 8.3 installer. Unzip to a new folder and then run the small .msi file. http://www.holdemmanager.com/downloads/postgresql.zip

You could also try older versions from here - http://www.postgresql.org/ftp/binary/

dan233
02-01-2010, 12:44 PM
Which Firewall, and Anti-Virus are you using?

Try turning down the UAC setting and reboot. Make sure you right-click > run as administrator when installing .exe files.

If you are still having problems, try our old 8.3 installer. Unzip to a new folder and then run the small .msi file. http://www.holdemmanager.com/downloads/postgresql.zip

You could also try older versions from here - http://www.postgresql.org/ftp/binary/

ok I m trying to install the data directory to D drive it says this:
http://img15.imageshack.us/img15/295/pstgresdatadir.png (http://img15.imageshack.us/i/pstgresdatadir.png/)my guess is that you cant install it on the D: partition without named subfolders?like this default one for example:http://img130.imageshack.us/img130/5695/postgresdird.png (http://img130.imageshack.us/i/postgresdird.png/)
so did you create these subfolders?( or is the problem something else)

netsrak
02-02-2010, 08:56 AM
Create a folder like d:\postgresql and choose this folder as the installation destination. It seems to make problems if you install directly to D:

dan233
02-02-2010, 11:32 AM
Create a folder like d:\postgresql and choose this folder as the installation destination. It seems to make problems if you install directly to D:

Ok that part worked.
I was prompted to put a "password" during the installation process.[I] dont know if this is to actually "create" a password but i just added a random one :"postgres"
now, when i try to access this "localhost" section(shown by the arrow) i am asked for a password. when i add the one i added during installation I get the following error message. is this normal?

http://img189.imageshack.us/img189/9749/passwordpostgres.png (http://img189.imageshack.us/i/passwordpostgres.png/)

fozzy71
02-02-2010, 04:16 PM
PT3's default name/password is - postgres/dbpass
HM's default name/password is - postgres/postgrespass

If that doesnt help:

1. Go to C:\Program Files\PostgreSQL\8.x\data, move the the pg_hba file to your Desktop and open it with notepad.
2. Scroll to the bottom and change all md5 to trust. Save and close the file
3. Move the file back to the data folder
4. Restart the PostgreSQL service: Control Panel -> Administrative Tools -> Services

HM will accept any password now.

http://faq.holdemmanager.com/questions/82/Password+Issues+(PostgreSQL)

dan233
02-02-2010, 05:29 PM
PT3's default name/password is - postgres/dbpass
HM's default name/password is - postgres/postgrespass

If that doesnt help:

1. Go to C:\Program Files\PostgreSQL\8.x\data, move the the pg_hba file to your Desktop and open it with notepad.
2. Scroll to the bottom and change all md5 to trust. Save and close the file
3. Move the file back to the data folder
4. Restart the PostgreSQL service: Control Panel -> Administrative Tools -> Services

HM will accept any password now.

http://faq.holdemmanager.com/questions/82/Password+Issues+(PostgreSQL)

I cant find the data folder (I have ticked the "show hidden folders")http://img683.imageshack.us/img683/5104/nodatafolder.png (http://img683.imageshack.us/i/nodatafolder.png/)
No pg_nba file in the "bin" folder either..

fozzy71
02-02-2010, 08:38 PM
It must have been installed to a different (Data) drive, like D:\

You should be able to find the data folder path by looking at the image path in the registry.



Windows XP
Go to Start > Run and type the following in the textbox: regedit and then press enter and a new window should appear like in the screenshot below:

Windows Vista/W7
Go to Start > All Programs > Accessories > Run then type the following in the textbox: regedit and then press enter and a new window should appear like in the screenshot below:

http://208.109.95.123/faq/files/Image/2PCpostgresRegedit.jpg

Navigate the folders to this path: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Servic es\pgsql-8.2 and you should then see the following screen:

http://208.109.95.123/faq/files/Image/2PCpostgresRegedit2.jpg

In the image above ive highlighted an example. Go to image path and right click and choose modify and you should see the following:

"C:\Program Files\PostgreSQL\8.2\bin\pg_ctl.exe" runservice -w -N "pgsql-8.2" -D "C:\Program Files\PostgreSQL\8.2\data\"

The last set of quotes is the data path.

dan233
02-02-2010, 09:15 PM
It must have been installed to a different (Data) drive, like D:\

You should be able to find the data folder path by looking at the image path in the registry.



Windows XP
Go to Start > Run and type the following in the textbox: regedit and then press enter and a new window should appear like in the screenshot below:

Windows Vista/W7
Go to Start > All Programs > Accessories > Run then type the following in the textbox: regedit and then press enter and a new window should appear like in the screenshot below:

http://208.109.95.123/faq/files/Image/2PCpostgresRegedit.jpg

Navigate the folders to this path: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Servic es\pgsql-8.2 and you should then see the following screen:

http://208.109.95.123/faq/files/Image/2PCpostgresRegedit2.jpg

In the image above ive highlighted an example. Go to image path and right click and choose modify and you should see the following:

"C:\Program Files\PostgreSQL\8.2\bin\pg_ctl.exe" runservice -w -N "pgsql-8.2" -D "C:\Program Files\PostgreSQL\8.2\data\"

The last set of quotes is the data path.
Ok I found it. As advised, I changed two "md5"" into "trust" and saved. even restarted service and computer

now I get this error message:
http://img268.imageshack.us/img268/1479/postga.png (http://img268.imageshack.us/i/postga.png/)
"A" is my username in windows. the message says that some sort of "role" associated to "A" doesnt exist. well, that REALLY clarifies things doesnt it..

fozzy71
02-03-2010, 12:14 AM
1) Uninstall PostgreSQL from the Windows Control Panel.
2) Start > Programs > Accessories > Command Prompt > Right-Click > Run As Administrator

net user postgres /delete
3) Reboot.
4) Install our old PostgreSQL 8.3 after you unzip it from this zip package - http://www.holdemmanager.com/downloads/postgresql.zip

If you have problems with that also, please email support@holdemmanager.com, with a link to this thread, and your forum name, so we can schedule a Teamviewer session. Download the Teamviewer Quick Support Module - http://www.holdemmanager.net/teamviewer. Please let us know what time zone you are in and what time/days are convenient for you.

dan233
02-03-2010, 01:42 PM
Ok.I m installing that older version of posgres following this tutorial:
http://faq.holdemmanager.com/questions/70/Reinstall+PostgreSQL
however, two additional windows with various settings (not included in this tutorial) appear:http://img23.imageshack.us/img23/5604/contribmode.png (http://img23.imageshack.us/i/contribmode.png/)
http://img535.imageshack.us/img535/2319/procedurallanguage.png (http://img535.imageshack.us/i/procedurallanguage.png/)
I just left the boxes ticked as they were in these pictures. is that ok?

Then I also get this error message when installing HEM:
http://img535.imageshack.us/img535/1732/hemprobinstall.png (http://img535.imageshack.us/i/hemprobinstall.png/)
what about that?

fozzy71
02-03-2010, 02:56 PM
....
I just left the boxes ticked as they were in these pictures. is that ok?

yes

[quote]Then I also get this error message when installing HEM:
....

Just hit OK and create a new DB. That is a standard warning because your config file is expecting to find your last selected DB, but you uninstalled it.

dan233
02-04-2010, 09:56 AM
yes

[quote]Then I also get this error message when installing HEM:
....

Just hit OK and create a new DB. That is a standard warning because your config file is expecting to find your last selected DB, but you uninstalled it.
Ok.Thanks
HEM seems to be working. I havent noticed any problems (due to mistakes I might have made) One thing I ve noticed is that I have to click on "refresh" for the session, graph etc to be updated when I want to check them out but I suppose this could be standard.
Also, how do I move the comunity cards from the previous hand (see pic)? they re hiding the upper part of my cards on a site;http://img714.imageshack.us/img714/9495/cards.png (http://img714.imageshack.us/i/cards.png/)

fozzy71
02-05-2010, 03:17 AM
hud options > tables preferences > [x] card and alignment edit > apply

right-click and drag

Then turn the option off and close the Tables Preferences menu.