Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id C2528B5DBD3 for ; Tue, 17 May 2011 13:37:05 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 43979-01 for ; Tue, 17 May 2011 16:36:58 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from nm20.bullet.mail.ne1.yahoo.com (nm20.bullet.mail.ne1.yahoo.com [98.138.90.83]) by mail.postgresql.org (Postfix) with SMTP id 449D4B5D802 for ; Tue, 17 May 2011 13:36:57 -0300 (ADT) Received: from [98.138.90.57] by nm20.bullet.mail.ne1.yahoo.com with NNFMP; 17 May 2011 16:36:55 -0000 Received: from [98.138.89.232] by tm10.bullet.mail.ne1.yahoo.com with NNFMP; 17 May 2011 16:36:55 -0000 Received: from [127.0.0.1] by omp1047.mail.ne1.yahoo.com with NNFMP; 17 May 2011 16:36:54 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 962839.61603.bm@omp1047.mail.ne1.yahoo.com Received: (qmail 4820 invoked by uid 60001); 17 May 2011 16:36:54 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1305650214; bh=WxdWy0iA1FMxgmLQkML6DTfrCutcfAAPm3xSHUAGC+A=; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type; b=r4VLYsBRCb2eucB0o6Y7iP2qxdCdv7SNkMS5FfwhXJIizRgU7ycgZB9ZyqGD2pLJlFMK0pxB4baNPNKKnPa/ky8Mp50o4ZEtr0Ez2aOUpxDy7bTT9g/2vkY/tTFsjIjPpgd/92PaUdb4WVl0pKUvgAnxgpkPTcJJL4/nP12rPFw= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type; b=U6lPmboYkSr+8/j3wEteotboe65dIgfeQEfwgbshwHYAzCwq1dofkPDaWObHfs4Jlm1Ja41MFvvpaTbBMYZxIdSUavNmkVwCu45M6PlBZaGElH5I4W15paQFsWuFIJ/ruUlGlhcdJXrAVeV8UNiF+wDl2W4lVbwYBgME3q87esU=; Message-ID: <327028.1809.qm@web114706.mail.gq1.yahoo.com> X-YMail-OSG: NqLZKBcVM1kyxPXRBuTDpDzTAZSiNDoNv8riO2bhI9uw3L5 y3R.tV66ynjZOczEagIaPnuSrkKc5Yb1iuIfgbSDl47Edw1xLZnXGjgG.GpA 3jfdaZUpaV9GAt9vf_J4dRTGNrfaecwuYpmi7t50Lt.gmBOuNWuUVDOQruQe mvA5MpmOCuiEYgLApbZdWZJc3PSFK0Y4OUDftYfdM3MlQXYaLOwzkX__78BD JaGMTDhm90STABXt7Dmf57TKZK037I2kSYDnCTaxK5XakGC6y3ToN5wt2_Di ahRJds76qx1Iq0OWTmDHvThfN1qQiUZ55qbDH2XjSVj7j8TrUqW.Vv.ckl2n EIgMn7_YLlGKUpKp4GU2XfnB9KyefN6BqsmlO4TEdnt9QcQOLwyMNlBC3uEr Hha6LkziPvwpB6u6GmFSDlEnWrdA1sCNBX1BEqoXnvZXZEA8Gs.KFqZewU6u adK3NFvYlUATDsqtCL0maqX9u9K4hPb9nGBxg Received: from [131.175.57.10] by web114706.mail.gq1.yahoo.com via HTTP; Tue, 17 May 2011 09:36:54 PDT X-Mailer: YahooMailRC/567 YahooMailWebService/0.8.111.303096 Date: Tue, 17 May 2011 09:36:54 -0700 (PDT) From: truongxuan quang Subject: question about installation PostgreSQL To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1022186058-1305650214=:1809" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.906 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, HTML_FONT_FACE_BAD=0.981, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001, RFC_ABUSE_POST=0.001, T_FRT_BELOW2=0.01, T_RP_MATCHES_RCVD=-0.01, T_TO_NO_BRKTS_FREEMAIL=0.01 X-Spam-Level: X-Archive-Number: 201105/103 X-Sequence-Number: 37540 --0-1022186058-1305650214=:1809 Content-Type: text/plain; charset=us-ascii Dear list I face with some problem in installation PostgreSQL 8.3 on winXP , long time before I used PostgreSQL and PostGIS for managing shape file data. Last week I tried to install PostgreSQL 8.4, after that I removed PostgreSQL 8.3 (I only uninstalled inside windows control panel/add and then I deleted all folder inside window programs) and I reinstalled PostgreSQL 8.4, and problem was starting happen from this step, until now, I could not connect data by my user and password or start PostgreSQL8.4 service from Administrative Tools . Even I tried to uninstall and reinstall for at least 20 times, delete folder, remove user/password on Administrative Tools. Could you please help me to fix my problem So today I tried several of time as bellow 1.Add/remove PostgreSQL 2.delete postgres user and pass by NET USER postgres /delete 3. delete folder of postgreSQL 4. Delete in side regiter of winXP in side KEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\ But when I install it still got errors as the detail in install-postgresql.log, I added some few line of the last install-postgresql.log file Starting the database server... Executing cscript //NoLogo "C:\Program Files\PostgreSQL\8.4\installer\server\startserver.vbs" postgresql-8.4 Script exit code: 0 Script output: Starting postgresql-8.4 Service postgresql-8.4 started successfully startserver.vbs ran to completion Script stderr: Loading additional SQL modules... Executing cscript //NoLogo "C:\Program Files\PostgreSQL\8.4\installer\server\loadmodules.vbs" "postgres" "****" "C:\Program Files\PostgreSQL\8.4" "C:\Program Files\PostgreSQL\8.4\data" 5432 "1" Script exit code: 0 Script output: Installing pl/pgsql in the template1 databases... Executing 'C:\DOCUME~1\quang\LOCALS~1\Temp\radEC6B1.bat'... psql: could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "???" and accepting TCP/IP connections on port 5432? Installing the adminpack module in the postgres database... Executing 'C:\DOCUME~1\quang\LOCALS~1\Temp\radEC6B1.bat'... psql: could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "???" and accepting TCP/IP connections on port 5432? loadmodules.vbs ran to completion Script stderr: [15:40:28] Write the data directory to the ini file... [15:40:28] Write the port number, service ID, locale and superuser to the ini file... [15:40:28] Write ServiceID(postgresql-8.4) to registry/ini... [15:40:28] Write Superuser to ini file and windows registry... [15:40:28] Write Service Account to ini file and windows registry... [15:40:28] Write the server description to the ini file... [15:40:28] Write the server branding to the ini file... [15:40:28] Write the 'whether stack-builder is disabled or not' to the ini file... [15:40:28] Finished running post-installation/upgrade tasks. Creating Uninstaller Creating uninstaller 25% Creating uninstaller 50% Creating uninstaller 75% Creating uninstaller 100% Installation completed Log finished 05/17/11 at 15:40:38 And when I started server by using pgAdim the server response as below: Server doesn't listen the server doesn't accept connections: the connection library repots could not connect to server: Connection refused (0x0000274D/10061)Is the server running on host "127.0.0.1" and accepting TCP/IP connections on port 5432? Thank again and very sorry for this very long question Many thanks T.X.Quang. --0-1022186058-1305650214=:1809 Content-Type: text/html; charset=us-ascii
Dear list

I face with some problem in installation PostgreSQL 8.3 on winXP , long time before I used PostgreSQL and PostGIS for managing shape file data. Last week I tried to install PostgreSQL 8.4, after that I removed PostgreSQL 8.3 (I only uninstalled inside windows control panel/add and then I deleted all folder inside window programs) and I reinstalled  PostgreSQL 8.4, and problem was starting happen from this step, until now, I could not connect data by my user and password or start PostgreSQL8.4 service from Administrative Tools . Even I tried to uninstall and reinstall for at least 20 times, delete folder, remove user/password on Administrative Tools. 

Could you please help me to fix my problem 

So today I tried several of time as bellow

1.Add/remove PostgreSQL 
2.delete postgres user and pass by NET USER postgres /delete
3. delete folder of postgreSQL
4. Delete in side regiter of winXP in side KEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\

But when I install it still got errors as the detail in install-postgresql.log, I added some few line of the last install-postgresql.log file

Starting the database server...
Executing cscript //NoLogo "C:\Program Files\PostgreSQL\8.4\installer\server\startserver.vbs" postgresql-8.4
Script exit code: 0

Script output:
 Starting postgresql-8.4
Service postgresql-8.4 started successfully
startserver.vbs ran to completion

Script stderr:
 
Loading additional SQL modules...
Executing cscript //NoLogo "C:\Program Files\PostgreSQL\8.4\installer\server\loadmodules.vbs" "postgres" "****" "C:\Program Files\PostgreSQL\8.4" "C:\Program Files\PostgreSQL\8.4\data" 5432 "1"
Script exit code: 0

Script output:
 Installing pl/pgsql in the template1 databases...
    Executing 'C:\DOCUME~1\quang\LOCALS~1\Temp\radEC6B1.bat'...
psql: could not connect to server: Connection refused (0x0000274D/10061)
Is the server running on host "???" and accepting
TCP/IP connections on port 5432?

Installing the adminpack module in the postgres database...
    Executing 'C:\DOCUME~1\quang\LOCALS~1\Temp\radEC6B1.bat'...
psql: could not connect to server: Connection refused (0x0000274D/10061)
Is the server running on host "???" and accepting
TCP/IP connections on port 5432?

loadmodules.vbs ran to completion

Script stderr:
 
[15:40:28] Write the data directory to the ini file...
[15:40:28] Write the port number, service ID, locale and superuser to the ini file...
[15:40:28] Write ServiceID(postgresql-8.4) to registry/ini...
[15:40:28] Write Superuser to ini file and windows registry...
[15:40:28] Write Service Account to ini file and windows registry...
[15:40:28] Write the server description to the ini file...
[15:40:28] Write the server branding to the ini file...
[15:40:28] Write the 'whether stack-builder is disabled or not' to the ini file...
[15:40:28] Finished running post-installation/upgrade tasks.
Creating Uninstaller
Creating uninstaller 25%
Creating uninstaller 50%
Creating uninstaller 75%
Creating uninstaller 100%
Installation completed
Log finished 05/17/11 at 15:40:38


And when I started server by using pgAdim the server response as below:

Server doesn't listen 

the server doesn't accept connections: the connection library repots

could not connect to server: Connection refused (0x0000274D/10061)Is the server running on host "127.0.0.1" and accepting TCP/IP connections on port 5432?

Thank again and very sorry for this very long question 

Many thanks

T.X.Quang.


--0-1022186058-1305650214=:1809--