installation fails during postgreSQL phase on XP SP3

 

pasttools's picture

I am trying to do an install of PostBooks - downloaded from SourceForge - on an XP SP3 machine and it repeatedly fails with two error messages:

1) C:\Documents and Settings \(my user name)\Local Settings\Temp\postgresql_installer\validateuser.exe "." "postgres" "****"

2) C:\Documents and Settings \(my user name)\Local Settings\Temp\postgresql-9.1.2.1-windows.exe -mode unattended -superpassword (mypassword) -servport (port)

In both cases, the rest of the message says the program returned an incorrect code. The first message sticks around on screen for a few seconds and is replaced by the second message. When you click on OK, the installation terminates.

I have tried installing in C:\xtuple, as suggested by another thread. i tried changing the port, in case there was a conflict. No help. I do not have PostgreSQL installed on this machine - except that like every machine around here, it is configured as a web server, and Apache brings in some "stuff" related to PostgreSQL. But no services are running for it. I did a search in the registry for anything realted to PostgreSQL and other than the apache related keys, there isn't anything.

I'm pretty much just taking the defaults for everything in the installation dialog, except for seeing if changing the port number would help.

Any suggestions on how I can make some progress here?

Before anyone suggests it, since I develop database-driven web apps for a living, the idea of removing the web server software is a non-starter.

 
tomdatkins's picture
Offline
Joined: 10/09/2011
RE: [Initial Setup]: installation fails during postgreSQL phase on XP SP3

Have you tried just installing Postgres, then adding the databases with PGAdmin?
http://www.enterprisedb.com/products-services-training/pgdownload

I think I have used 9.1.8. Download it and separate the Postgres issue. Can you run the install as administrator?
Write down your settings during Postresql install.
Here is how to create a database with pgadmin.
Open pgadmin, connect to the server. ( pgadmin will be installed with Enterprise)

Right click the database icon in the left side menu. Select new database.
Properties TAB:
Database name, owner: admin

Definition TAB:
Encoding:UTF8
Template: template1

And select OK.

Right click newly created database and select restore:

File name: find your database to restore and select.

Role Name: admin

And click restore.
http://www.pgadmin.org/docs/1.8/using.html

Pick a distro and download.
http://sourceforge.net/projects/postbooks/files/03%20PostBooks-databases/

You will need to run a script to setup xtrole. That script is called init.sql and is in the folders for each version.

Highlight the database in PGAdmin, click the icon that says SQL on the top menu bar, and either paste in the sql or open the .sql file and click the green run arrow. That will setup the Postgres group xtrole.

Don’t forget the client:
http://sourceforge.net/projects/postbooks/files/02%20PostBooks-GUIclient...