PDA

View Full Version : Installing PostgreSQL win 7



elpuppyreta
04-25-2011, 11:23 PM
Sorry, Could not install PostgreSQL

details

Installation aborted

Connection to database failed --> could not connect to server...
Is the server running on host "127.0.0.1" and accepting
TCP/IP connections on port 5432?
<-- error
1
testclient return status: 1
testclient return from file : 1
-----------------------

What I have to do?

Sarek
04-26-2011, 03:07 AM
If you have Win7 (or Vista), consider the following:
1) PC name must be in English and "in one word" - requires reboot after changing.
2) The same for Windows user name. If not - create new Win user with EN name and reboot PC for this user when install Postgres. And he must have admin rights. After installation you can kill this new user - his mission is completed.
3) Secondary logon service must be set to "Autostart"\
4) UAC = OFF
5) Disable firewall and antivirus when installing Postgres and HM. Or uninstall them at all.
6) All installations must run "as admin" (by right-click on file). And do them as first thing after PC reboot.
7) If you want to change install path for Postgres (or to set non-default folder for database cluster) - download "standalone" installation file from PostgreSQL: The world's most advanced open source database (http://www.postgresql.org).
8) If your Windows is not in English - you have to install Postgres not in default folder in Program_Files. Create new (example: c:\postgresql) first and select it when install.
9) Install Postgres and HM separarelly, one after one. As admin. If HM (when runs for the 1st time) says "no database" - simply create it via DBControlpanel.
10) If Postgres install fails - after uninstalling don't forget to kill windows user named "postgres":
Go to Start > Programs > Accessories > Command Prompt > Right-Click > Run As Administrator
In the window that appears please type the following and press enter:
net user postgres /delete
exactly as shown. You should get a confirmation if it was successful.
11) Run all pokerclients "as admin" too.

elpuppyreta
04-26-2011, 12:52 PM
I cant install yet
I change the names of the PC and user name
UAC is off
second logon is activated
put all "as admin"
deactived firewall and antivirus
change de directory cause I have windows in spanish
even I try with the CMD --> user net postgres /delete to reinstall but nothing

Patvs
04-26-2011, 08:12 PM
Go to PostgreSQL: The world's most advanced open source database (http://www.postgresql.org) and manually install PostgreSQL.
Try 9.0.4 first. Which error do you get during installation?

If 8.4.x and 9.0.x won't install use 8.2.x: PostgreSQL: Choose a Mirror (http://wwwmaster.postgresql.org/download/mirrors-ftp/binary/v8.2.21/win32/postgresql-8.2.21-1.zip)