Attn: Vista Users Installing PostgreSQL 8.3

[HanTheMan]

Hey

I bought this pt3 but after many hours I still cant get it working because of these problems. I first installed this service pack1 but it said that my Vista is installed with wrong language. I tried to change the language to english but it still says the same.

Then today I have tried to install the old version of postgre but now I got this error when I try to log in:
"Unable to connect database. Please check the configuration"

Try using the default password, 'dbpass' (no quotes).

If that does not work, go Start->Programs->PostgreSQL->Configuration Files->Edit pg_hba.conf.

At the bottomYou can now proceed with leaving the password field empty.

two lines that end with 'md5'. Change both 'md5' to 'trust'. File->Save.

Then go Start->Programs->PostgreSQL->Reload Configurations.

I tried this but it says "Given path cant be found"(my translation from finnish, might be bit different in english) when I go to Edit pg_hba.conf

Also, should install that PostgreSQL to some special folder and during the installation should I put some password to those empty fields?
Is it possible to get that service pack to work somehow?


Im bad with computers and this thing is giving me a lot of stress

[dmorris68]

I'm running Vista Ultimate SP1, UAC disabled, with admin priviledges. I'm actually a developer myself, and have installed, used, and coded for most databases on the market. Including PostgreSQL on Linux, but this is the first time I've tried it on Windows.

Both the 8.7.3 embedded installer as well as the 8.2.7 suggested here fail silently during installation. The msiexec.exe process is left behind as a zombie and has to be manually killed. The install log file shows an error with the GetAvailableLocales API call. Here's the last part of the log:

MSI (c) (60:A4) [15:02:57:233]: Doing action: AppSearch
Action 15:02:57: AppSearch. Searching for installed applications
Action start 15:02:57: AppSearch.
MSI (c) (60:A4) [15:02:57:234]: Note: 1: 2205 2: 3: AppSearch
MSI (c) (60:A4) [15:02:57:234]: Note: 1: 2228 2: 3: AppSearch 4: SELECT `Property`, `Signature_` FROM `AppSearch`
Action ended 15:02:57: AppSearch. Return value 0.
MSI (c) (60:A4) [15:02:57:234]: Doing action: LaunchConditions
Action 15:02:57: LaunchConditions. Evaluating launch conditions
Action start 15:02:57: LaunchConditions.
Action ended 15:02:57: LaunchConditions. Return value 1.
MSI (c) (60:A4) [15:02:57:234]: Doing action: GetAvailableLocales
Action 15:02:57: GetAvailableLocales.
Action start 15:02:57: GetAvailableLocales.
MSI (c) (60:78) [15:02:57:238]: Invoking remote custom action. DLL: D:\Temp\tmp\MSI8D07.tmp, Entrypoint: GetAvailableLocales@4
MSI (c) (60:2C) [15:02:57:239]: Cloaking enabled.
MSI (c) (60:2C) [15:02:57:239]: Attempting to enable all disabled privileges before calling Install on Server
MSI (c) (60:2C) [15:02:57:239]: Connected to service for CA interface.
MSI (c) (60!C8) [15:02:57:541]: Note: 1: 2259 2: 3: 4:
MSI (c) (60:78) [15:02:57:590]: Leaked MSIHANDLE (3) of type 790540 for thread 3016
MSI (c) (60:78) [15:02:57:590]: Note: 1: 2769 2: GetAvailableLocales 3: 1
MSI (c) (60:78) [15:02:57:590]: Note: 1: 2205 2: 3: Error
MSI (c) (60:78) [15:02:57:590]: Note: 1: 2228 2: 3: Error 4: SELECT `Message` FROM `Error` WHERE `Error` = 2769
DEBUG: Error 2769: Custom Action GetAvailableLocales did not close 1 MSIHANDLEs.
The installer has encountered an unexpected error installing this package. This may indicate a problem with this package. The error code is 2769. The arguments are: GetAvailableLocales, 1,
Action ended 15:02:57: GetAvailableLocales. Return value 1.
MSI (c) (60:A4) [15:02:57:591]: Doing action: CheckAvailableDLLs
Action 15:02:57: CheckAvailableDLLs.

This appears to be MSI related rather than PostgreSQL related, but the fact remains I have no issues with other MSI installers. Any suggestions as to how to proceed would be appreciated, otherwise it looks like I'll have to wait out the new version of PokerEV (which looks like a promising competitor to PT3) or go with PO or HM, whichever one doesn't require PostgreSQL.

On a completely different note, speaking as a developer, I'm also curious as to why PT chose a full local-server implementation of PostgreSQL instead of a self-contained embedded database such as HSQL, MySQL embedded, etc.? Seems a bit overkill for the sort of DB requirements PT would have, and I'm not crazy about having excess services running on my desktop machine. Is it possible for PT to start/stop the PostgreSQL service on demand, to avoid having it run at startup? Alternatively, could I point PT3 at a remote PostgreSQL server running on one of my Linux servers?

[dmorris68]

I guest post editing is disabled, so sorry for the double post.

I just found the problem with the GetAvailableLocale issue I was having. The nature of my problem was such that probably not many of your customers will have it, unless they're geeks like me. Still, I'll post the solution for those fellow geeks who come behind me.

http://www.postgresql.org/docs/faqs.FAQ ... s.html#3.1

The first likely suspects mentioned are personal firewall and antivirus software, particularly NOD32. I had eliminated those possibilities early on, but keep it in mind for others. Here's what bit me:

There is also an issue if you have installed cygwin, and the cygwin\bin directory is present in the system PATH variable. There are DLL files in the cygwin directory related to interpreted languages (TCL, perl, python) that contain bugs that can cause the installer or the installed version of PostgreSQL to either hang or crash. Remove the cygwin\bin directory from your path before running the installer!

I use Cygwin quite a bit, and of course it was in my path. Removing it allowed PostgreSQL (and PT3) to finish installation.

[decoy411]

desintalled postgre sql 8.3 because couldnt find a password. then I try to reinstall it and they say...'Invalid username specified : Logon failure: unkonown user name or bad password.
am I fucked ?

ty sam

[WhiteRider]

Please see details of how to completely uninstall postgres here: this topic

[le_stud]

Help...

I had already make it worked on my computer but i had to reinstall vista.
This time i doesn't work. always the same message with "initdb"? I installed postgres 2.7 but there is nothing to do.

What should i do ?

Thank you for your answer.

[GreetUrDs]

Sorry for dumb question, but why am I not allowed to install/create psotgreSQL. I use Vista, I downloaded that 8.2.7.1 as suggested, but when I proceed the installation and try to configurate the "service account", it doesn't accept any password I enter for account name :"postgres"

How am I supposed to do this configuration? I

[WhiteRider]

The password needs to be REALLY complex. Is there a button offering to create a password for you? If so, let it.

[GreetUrDs]

I entered quite a complex password (KaNo0Tt19) but it just says "invalid username specified". It gives the same msg also if I leave the password field blank, trying to auto-generate it....?

[WhiteRider]

Passwords need to be MUCH more complex than that, it's not just a case of mixing letters and numbers, you need some obscure symbols too.
It it is a long time since I did this, but I got stuck at the same place and I'm sure there was a button to auto-generate a password. You should leave the username at the default ("postgres"?).