<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:'times new roman', 'new york', times, serif;font-size:12pt"><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif" size="3">Thank you very much for your help! but I did not know how to process as you </font><font class="Apple-style-span" face="'times new roman', 'new york', times, serif">mention, could you please explain as step by step.</font></div><div style="color: black; font-family: 'times new roman', 'new york', times, serif; font-size: 12pt; "><br></div><div style="color: black; font-family: 'times new roman', 'new york', times, serif; font-size: 12pt; ">So today I tried to do </div><div style="color: black; font-family: 'times new roman', 'new york', times, serif; font-size: 12pt; ">1.Add/remove PostgreSQL </div><div style="color: black; font-family: 'times new roman', 'new york', times, serif;
font-size: 12pt; ">2.delete postgres user and pass by NET USER postgres /delete</div><div style="color: black; font-family: 'times new roman', 'new york', times, serif; font-size: 12pt; ">3. delete folder of postgreSQL</div><div style="color: black; font-family: 'times new roman', 'new york', times, serif; font-size: 12pt; ">4. Delete in side regiter of winXP in side <span class="Apple-style-span" style="font-family: verdana, arial, helvetica, sans-serif; font-size: 12px; line-height: 18px; -webkit-border-horizontal-spacing: 1px; -webkit-border-vertical-spacing: 1px; ">KEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\</span></div><div style="color: black; font-family: 'times new roman', 'new york', times, serif; font-size: 12pt; "><br></div><div style="color: black; font-family: 'times new roman', 'new york', times, serif; font-size: 12pt; ">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</div><div style="color: black; font-family: 'times new roman', 'new york', times, serif; font-size: 12pt; "><br></div><div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><i>Starting the database server...</i></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><i>Executing cscript //NoLogo "C:\Program Files\PostgreSQL\8.4\installer\server\startserver.vbs" postgresql-8.4</i></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><i>Script exit code: 0</i></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><i><br></i></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><i>Script output:</i></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times,
serif"><i> Starting postgresql-8.4</i></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><i>Service postgresql-8.4 started successfully</i></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><i>startserver.vbs ran to completion</i></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><i><br></i></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><i>Script stderr:</i></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"> </font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><i>Loading additional SQL modules...</i></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><i>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"</i></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><i>Script exit code: 0</i></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><br></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><i>Script output:</i></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><i> Installing pl/pgsql in the template1 databases...</i></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><i> Executing 'C:\DOCUME~1\quang\LOCALS~1\Temp\radEC6B1.bat'...</i></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><i>psql: could
not connect to server: Connection refused (0x0000274D/10061)</i></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><i><span class="Apple-tab-span" style="white-space:pre"> </span>Is the server running on host "???" and accepting</i></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><i><span class="Apple-tab-span" style="white-space:pre"> </span>TCP/IP connections on port 5432?</i></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><i><br></i></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><i>Installing the adminpack module in the postgres database...</i></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><i> Executing 'C:\DOCUME~1\quang\LOCALS~1\Temp\radEC6B1.bat'...</i></font></div><div><font
class="Apple-style-span" face="'times new roman', 'new york', times, serif"><i>psql: could not connect to server: Connection refused (0x0000274D/10061)</i></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><i><span class="Apple-tab-span" style="white-space:pre"> </span>Is the server running on host "???" and accepting</i></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><i><span class="Apple-tab-span" style="white-space:pre"> </span>TCP/IP connections on port 5432?</i></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><i><br></i></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><i>loadmodules.vbs ran to completion</i></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><i><br></i></font></div><div><font
class="Apple-style-span" face="'times new roman', 'new york', times, serif"><i>Script stderr:</i></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><i> </i></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><i>[15:40:28] Write the data directory to the ini file...</i></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><i>[15:40:28] Write the port number, service ID, locale and superuser to the ini file...</i></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><i>[15:40:28] Write ServiceID(postgresql-8.4) to registry/ini...</i></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><i>[15:40:28] Write Superuser to ini file and windows registry...</i></font></div><div><font class="Apple-style-span" face="'times new
roman', 'new york', times, serif"><i>[15:40:28] Write Service Account to ini file and windows registry...</i></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><i>[15:40:28] Write the server description to the ini file...</i></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><i>[15:40:28] Write the server branding to the ini file...</i></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><i>[15:40:28] Write the 'whether stack-builder is disabled or not' to the ini file...</i></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><i>[15:40:28] Finished running post-installation/upgrade tasks.</i></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><i>Creating Uninstaller</i></font></div><div><font class="Apple-style-span"
face="'times new roman', 'new york', times, serif"><i>Creating uninstaller 25%</i></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><i>Creating uninstaller 50%</i></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><i>Creating uninstaller 75%</i></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><i>Creating uninstaller 100%</i></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><i>Installation completed</i></font></div><div><font class="Apple-style-span" face="'times new roman', 'new york', times, serif"><i>Log finished 05/17/11 at 15:40:38</i></font></div><div style="color: black; font-family: 'times new roman', 'new york', times, serif; font-size: 12pt; "><br></div></div><div style="color: black; font-family: 'times new roman', 'new york', times, serif;
font-size: 12pt; "><br></div><div style="color: black; font-family: 'times new roman', 'new york', times, serif; font-size: 12pt; ">And when I started server by using pgAdim the server response as below:</div><div style="color: black; font-family: 'times new roman', 'new york', times, serif; font-size: 12pt; "><br></div><div style="color: black; font-family: 'times new roman', 'new york', times, serif; font-size: 12pt; ">Server doesn't listen </div><div style="color: black; font-family: 'times new roman', 'new york', times, serif; font-size: 12pt; "><br></div><div style="color: black; font-family: 'times new roman', 'new york', times, serif; font-size: 12pt; ">the server doesn't accept connections: the connection library repots</div><div style="color: black; font-family: 'times new roman', 'new york', times, serif; font-size: 12pt; "><br></div><div style="color: black; font-family: 'times new roman', 'new york', times, serif; font-size: 12pt;
">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?</div><div style="color: black; font-family: 'times new roman', 'new york', times, serif; font-size: 12pt; "><br></div><div style="color: black; font-family: 'times new roman', 'new york', times, serif; font-size: 12pt; ">Thank again and very sorry for this question </div><div style="color: black; font-family: 'times new roman', 'new york', times, serif; font-size: 12pt; "><br></div><div style="color: black; font-family: 'times new roman', 'new york', times, serif; font-size: 12pt; ">Many thanks</div><div style="color: black; font-family: 'times new roman', 'new york', times, serif; font-size: 12pt; "><br></div><div style="color: black; font-family: 'times new roman', 'new york', times, serif; font-size: 12pt; ">T.X.Quang.</div><div style="color: black; font-family: 'times new roman', 'new
york', times, serif; font-size: 12pt; "><br></div><div style="color: black; font-family: 'times new roman', 'new york', times, serif; font-size: 12pt; "><br></div><div style="color: black; font-family: 'times new roman', 'new york', times, serif; font-size: 12pt; "><br><div style="font-family:arial, helvetica, sans-serif;font-size:13px"><font size="2" face="Tahoma"><hr size="1"><b><span style="font-weight: bold;">From:</span></b> "postgis-users-request@postgis.refractions.net" <postgis-users-request@postgis.refractions.net><br><b><span style="font-weight: bold;">To:</span></b> postgis-users@postgis.refractions.net<br><b><span style="font-weight: bold;">Sent:</span></b> Mon, May 16, 2011 9:00:02 PM<br><b><span style="font-weight: bold;">Subject:</span></b> postgis-users Digest, Vol 109, Issue 15<br></font><br>
Send postgis-users mailing list submissions to<br> <a ymailto="mailto:postgis-users@postgis.refractions.net" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br><br>To subscribe or unsubscribe via the World Wide Web, visit<br><span> <a target="_blank" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a></span><br>or, via email, send a message with subject or body 'help' to<br> <a ymailto="mailto:postgis-users-request@postgis.refractions.net" href="mailto:postgis-users-request@postgis.refractions.net">postgis-users-request@postgis.refractions.net</a><br><br>You can reach the person managing the list at<br> <a ymailto="mailto:postgis-users-owner@postgis.refractions.net"
href="mailto:postgis-users-owner@postgis.refractions.net">postgis-users-owner@postgis.refractions.net</a><br><br>When replying, please edit your Subject line so it is more specific<br>than "Re: Contents of postgis-users digest..."<br><br><br>Today's Topics:<br><br> 1. Re: Clip a table using a donut geometry (J?lio Almeida)<br> 2. Help for my error when I install Postgis (truongxuan quang)<br> 3. Re: Help for my error when I install Postgis (Ren? Riech)<br><br><br>----------------------------------------------------------------------<br><br>Message: 1<br>Date: Mon, 16 May 2011 15:31:23 +0100<br>From: J?lio Almeida <<a ymailto="mailto:julio.augusto.almeida@gmail.com" href="mailto:julio.augusto.almeida@gmail.com">julio.augusto.almeida@gmail.com</a>><br>Subject: Re: [postgis-users] Clip a table using a donut geometry<br>To: Ralf Suhr <<a ymailto="mailto:Ralf.Suhr@itc-halle.de"
href="mailto:Ralf.Suhr@itc-halle.de">Ralf.Suhr@itc-halle.de</a>><br>Cc: PostGIS Users Discussion <<a ymailto="mailto:postgis-users@postgis.refractions.net" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>><br>Message-ID: <<a ymailto="mailto:BANLkTikGUwnzvU23ABYEvmdKeaY-TeFzvA@mail.gmail.com" href="mailto:BANLkTikGUwnzvU23ABYEvmdKeaY-TeFzvA@mail.gmail.com">BANLkTikGUwnzvU23ABYEvmdKeaY-TeFzvA@mail.gmail.com</a>><br>Content-Type: text/plain; charset="utf-8"<br><br>Thanks Ralf for your suggestion.<br><br>I solved it by doing it in two steps.<br>First, I created a temporary table with the donut geometry:<br><br>EXECUTE 'create table tempdonut as SELECT<br>ST_Difference(st_buffer(the_geom,buffer_radius), the_geom) as the_geom<br> from designprocess.dp_zn_boundaries<br> where type = site_name);<br><br>Second, I did de Intersects query:<br><br>EXECUTE 'INSERT
INTO tempdonut SELECT<br> r.the_geom, r.gid FROM urbanenvironment.ue_ms_crossings_wegdeel_punt<br>AS r, tempdonut as m<br> WHERE ST_Intersects(r.the_geom, m.the_geom)';<br><br>Thanks again,<br><br>j?lio almeida<br>-------------- next part --------------<br>An HTML attachment was scrubbed...<br><span>URL: <<a target="_blank" href="http://postgis.refractions.net/pipermail/postgis-users/attachments/20110516/212d79ac/attachment-0001.html">http://postgis.refractions.net/pipermail/postgis-users/attachments/20110516/212d79ac/attachment-0001.html</a>></span><br><br>------------------------------<br><br>Message: 2<br>Date: Mon, 16 May 2011 10:23:15 -0700 (PDT)<br>From: truongxuan quang <<a ymailto="mailto:truongxuanquang@yahoo.com" href="mailto:truongxuanquang@yahoo.com">truongxuanquang@yahoo.com</a>><br>Subject: [postgis-users] Help for my error when I install Postgis<br>To: <a
ymailto="mailto:postgis-users@postgis.refractions.net" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>Message-ID: <<a ymailto="mailto:11939.11902.qm@web114704.mail.gq1.yahoo.com" href="mailto:11939.11902.qm@web114704.mail.gq1.yahoo.com">11939.11902.qm@web114704.mail.gq1.yahoo.com</a>><br>Content-Type: text/plain; charset="us-ascii"<br><br>Dear list<br><br>I face with some problem in installation PostgreSQL 8.3 on winXP , long time <br>before I use PostgreSQL and PostGIS for managing shape file data. Last week I <br>tried to install PostgreSQL 8.4, after that I remove PostgreSQL 8.3 (I only <br>uninstalled inside windows control panel/add and then I delete all folder inside <br>window programs) and I reinstall PostgreSQL 8.4, and problem was starting happen <br>from this step, until now, I could not connect data by my user and password or <br>start PostgreSQL8.4 service from Administrative Tools .
Even I tried to <br>uninstall and reinstall for at least 20 times, delete folder, remove <br>user/password on Administrative Tools. <br><br>Could you please help me to fix my problem <br><br>Many thanks<br><br>T.X.Quang<br>-------------- next part --------------<br>An HTML attachment was scrubbed...<br><span>URL: <<a target="_blank" href="http://postgis.refractions.net/pipermail/postgis-users/attachments/20110516/3cd27eaa/attachment-0001.html">http://postgis.refractions.net/pipermail/postgis-users/attachments/20110516/3cd27eaa/attachment-0001.html</a>></span><br><br>------------------------------<br><br>Message: 3<br>Date: Mon, 16 May 2011 19:50:34 +0200<br>From: Ren? Riech <<a ymailto="mailto:rene.riech@arcor.de" href="mailto:rene.riech@arcor.de">rene.riech@arcor.de</a>><br>Subject: Re: [postgis-users] Help for my error when I install Postgis<br>To: "PostGIS Users Discussion" <<a ymailto="mailto:postgis-users@postgis.refractions.net"
href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>><br>Message-ID: <op.vvk46kax1ftthu@roarglch><br>Content-Type: text/plain; charset=iso-8859-15; format=flowed;<br> delsp=yes<br><br>On Mon, 16 May 2011 19:23:15 +0200, truongxuan quang <br><<a ymailto="mailto:truongxuanquang@yahoo.com" href="mailto:truongxuanquang@yahoo.com">truongxuanquang@yahoo.com</a>> wrote:<br><br>> Dear list<br>><br>> I face with some problem in installation PostgreSQL 8.3 on winXP , long <br>> time<br>> before I use PostgreSQL and PostGIS for managing shape file data. Last <br>> week I<br>> tried to install PostgreSQL 8.4, after that I remove PostgreSQL 8.3 (I <br>> only<br>> uninstalled inside windows control panel/add and then I delete all <br>> folder inside<br>> window programs) and I reinstall PostgreSQL 8.4, and problem was <br>>
starting happen<br>> from this step, until now, I could not connect data by my user and <br>> password or<br>> start PostgreSQL8.4 service from Administrative Tools . Even I tried to<br>> uninstall and reinstall for at least 20 times, delete folder, remove<br>> user/password on Administrative Tools.<br><br>Hi Truongxuan,<br><br><br>I once had also a problem with a deinstallation of PostgreSQL. I found that<br>script, It deletes everytthing what stays after the deinstallation.<br><br><br>echo on<br>@REM <br>********************************************************************************<br>@REM<br>@REM NAME : Remove_PostgreSQL_Total.CMD<br>@REM<br>@REM DESCRIPTION : Entfernt vollst?ndig alle Verzeichnisse und Eintr?ge <br>die durch<br>@REM die De-Installation von PostgreSQL nicht entfernt
<br>wurden.<br>@REM<br>@REM Diese Datei darf erst nach der De-Installtion von <br>PostgreSQL<br>@REM gestartet werden. Sie mu? von dem User ausgef?hrt <br>werden, unter<br>@REM dem die Installation von PostgreSQL erfolgte. <br>Normalerweise ist<br>@REM das der Administrator unter Windows.<br>@REM<br>@REM Die Verzeichnisse beziehen sich auf eine <br>PostgreSQL-Standard-<br>@REM Installation!<br>@REM<br>@REM <br>********************************************************************************<br><br>@REM
-------------------------------------------------------------<br>@REM Benutzerkonto, unter dem der PostgreSQL-Datenbankserver l?uft<br>@REM -------------------------------------------------------------<br><br> @set WIN_USER=postgres<br><br>@REM <br>================================================================================<br><br> NET USER %WIN_USER% /DELETE<br><br> rmdir /S /Q "%SystemDrive%\Dokumente und <br>Einstellungen\%USERNAME%\Anwendungsdaten\PostgreSQL"<br> rmdir /S /Q "%SystemDrive%\Dokumente und Einstellungen\%WIN_USER%"<br> rmdir /S /Q "%ProgramFiles%\PostgreSQL"<br><br><br><br>Use this script AFTER the deinstallation of PostgreSQL as an administrator <br>user.<br><br>maybe this helps.<br><br>with
regards<br><br>Ren?<br><br><br>------------------------------<br><br>_______________________________________________<br>postgis-users mailing list<br><a ymailto="mailto:postgis-users@postgis.refractions.net" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br><a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br><br><br>End of postgis-users Digest, Vol 109, Issue 15<br>**********************************************<br></div></div><div style="color: black; font-family: 'times new roman', 'new york', times, serif; font-size: 12pt; position: fixed; "></div>
</div></body></html>