SQL problem need help?

PostgreSQL is the database server used to store information. Do you have a question or are you having problem with PostgreSQL? If so, post them here.

Moderator: Moderators

Re: SQL problem need help?

Postby 2Poker4forlife » Tue Sep 01, 2009 1:34 pm

It said command Completed
2Poker4forlife
 
Posts: 12
Joined: Mon Aug 31, 2009 4:58 pm

Re: SQL problem need help?

Postby 2Poker4forlife » Tue Sep 01, 2009 2:08 pm

I tried 2 Install 8.3 and I got stuck in Initializing database cluster. Error popup "failed to create temporary directory."?
2Poker4forlife
 
Posts: 12
Joined: Mon Aug 31, 2009 4:58 pm

Re: SQL problem need help?

Postby kraada » Tue Sep 01, 2009 2:15 pm

This error message occurs as a result of another program not allowing PostgreSQL to install properly. The solution is to uninstall PostgreSQL completely and reinstall it in Safe Mode. To boot into safe mode, click Start --> Run type "msconfig" and hit OK. Under the "Boot.ini" tab, check "Safe boot" and "Network". Click Apply, then OK, and restart your computer. It will boot automatically into safe mode. Double click on "My Computer", then browse to your PostgreSQL directory and delete it (the default is C:\Program Files\PostgreSQL). Click Start --> Run, type "cmd" and hit enter. At the command prompt type "net user postgres /delete" and hit enter. Exit the command prompt, and proceed with the PostgreSQL installation. Once the PostgreSQL installation has finished, go back into the msconfig window again as directed previously, and uncheck the "Safe boot" checkbox. Then reboot your computer and PostgreSQL will be properly installed.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: SQL problem need help?

Postby 2Poker4forlife » Tue Sep 01, 2009 4:20 pm

I couldn't install using safe mode. But I got it Install normally I unchecked the box on Cluster when installing tho. I don't know what that done when I start up PT3 I get this.

Unable th create PostgreSQL database (template1). Reason: could not connect to server: connection refused (0x0000274D/10061) Is the server running on host "localhost" and accepting TCP/IP connections on port 5432?

I don't know whats going on here....
2Poker4forlife
 
Posts: 12
Joined: Mon Aug 31, 2009 4:58 pm

Re: SQL problem need help?

Postby kraada » Tue Sep 01, 2009 4:53 pm

Create a support ticket using this link and we'll schedule you for a remote assistance session and get everything resolved and working for you.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Previous

Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 13 guests

cron
highfalutin