Page 1 of 4

Problem when installing Postgre SQL

PostPosted: Thu Jan 31, 2008 10:44 pm
by Harrold
PT3 installs fine, but after that the Postgre has problems,

Error 1 is followed by Error 2 shortly after.... The computer is new, it's running XP, as administrator etc etc.

[imgpat]http://img408.imageshack.us/img408/3723/error1xp1.jpg[/imgpat]

[imgpat]http://img508.imageshack.us/img508/8647/error2zw0.jpg[/imgpat]

Re: Problem when installing Postgre SQL

PostPosted: Thu Jan 31, 2008 11:40 pm
by APerfect10
Go Start->Control Panel->Administrative Tools->Services.

Scroll down the list of services and find the one named "Secondary Logon". Double click it.

Click "Start" and change the Startup Type to "Automatic". Apply->OK.

Reinstall.

Best regards,

Derek

Re: Problem when installing Postgre SQL

PostPosted: Fri Feb 01, 2008 1:44 am
by adamsowell
doubled clicked Secondary logon

however

the (Start) button isn't highlighted, so i am unable to click it

Re: Problem when installing Postgre SQL

PostPosted: Fri Feb 01, 2008 2:34 am
by APerfect10
It sounds like the Startup Type is "Disabled". Change it to "Automatic" then click "Apply". You should now be able to start it.

Best regards,

Derek

Re: Problem when installing Postgre SQL

PostPosted: Fri Feb 01, 2008 1:03 pm
by Harrold
I made sure this was all correct before doing this,

this isn't the problem,

what is the next plan of action?

Re: Problem when installing Postgre SQL

PostPosted: Fri Feb 01, 2008 6:59 pm
by APerfect10
When you get the failed to run initdb message, can you please post the contents of the log file it mentions (prior to pressing OK)?

Best regards,

Derek

Re: Problem when installing Postgre SQL

PostPosted: Fri Feb 01, 2008 7:23 pm
by Harrold
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.

The database cluster will be initialized with locale C.

initdb: directory "C:/Program Files/PostgreSQL/8.2/data" exists but is not empty
If you want to create a new database system, either remove or empty
the directory "C:/Program Files/PostgreSQL/8.2/data" or run initdb
with an argument other than "C:/Program Files/PostgreSQL/8.2/data".

Re: Problem when installing Postgre SQL

PostPosted: Fri Feb 01, 2008 9:54 pm
by APerfect10
Did you have PostgreSQL previously installed? It looks like your database cluster has already been created therefore you cannot run initdb again...

Best regards,

Derek

Re: Problem when installing Postgre SQL

PostPosted: Fri Feb 01, 2008 10:45 pm
by Harrold
no, completely new computer.

I have tried about 10 times now, completely refreshing everything, including deleting the postgre sql.

Re: Problem when installing Postgre SQL

PostPosted: Fri Feb 01, 2008 10:48 pm
by APerfect10
What is displayed when you startup PT3? Is it still trying to install PostgreSQL or are you getting the 2nd message you posted in your OP.

You are either stuck mid-way through an installation or PostgreSQL has already been installed...

If you go Start->Control Panel->Administrative Tools->Services, do you see "PostgreSQL Database Server" listed in your list of services?

Best regards,

Derek