[postgis-users] install PostgreSQL

Tue May 17 07:10:24 PDT 2011

Thank you very much for your help! but I did not know how to process as 
you mention, could you please explain as step by step.

So today I tried to do 
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 question 

Many thanks

T.X.Quang.

________________________________
From: "postgis-users-request at postgis.refractions.net" 
<postgis-users-request at postgis.refractions.net>
To: postgis-users at postgis.refractions.net
Sent: Mon, May 16, 2011 9:00:02 PM
Subject: postgis-users Digest, Vol 109, Issue 15

Send postgis-users mailing list submissions to
    postgis-users at postgis.refractions.net

To subscribe or unsubscribe via the World Wide Web, visit
    http://postgis.refractions.net/mailman/listinfo/postgis-users
or, via email, send a message with subject or body 'help' to
    postgis-users-request at postgis.refractions.net

You can reach the person managing the list at
    postgis-users-owner at postgis.refractions.net

When replying, please edit your Subject line so it is more specific
than "Re: Contents of postgis-users digest..."

Today's Topics:

   1. Re: Clip a table using a donut geometry (J?lio Almeida)
   2. Help for my error when I install Postgis (truongxuan quang)
   3. Re: Help for my error when I install Postgis (Ren? Riech)

----------------------------------------------------------------------

Message: 1
Date: Mon, 16 May 2011 15:31:23 +0100
From: J?lio Almeida <julio.augusto.almeida at gmail.com>
Subject: Re: [postgis-users] Clip a table using a donut geometry
To: Ralf Suhr <Ralf.Suhr at itc-halle.de>
Cc: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
Message-ID: <BANLkTikGUwnzvU23ABYEvmdKeaY-TeFzvA at mail.gmail.com>
Content-Type: text/plain; charset="utf-8"

Thanks Ralf for your suggestion.

I solved it by doing it in two steps.
First, I created a temporary table with the donut geometry:

EXECUTE 'create table tempdonut as SELECT
ST_Difference(st_buffer(the_geom,buffer_radius), the_geom) as the_geom
      from designprocess.dp_zn_boundaries
      where type = site_name);

Second, I did de Intersects query:

EXECUTE 'INSERT INTO  tempdonut SELECT
      r.the_geom, r.gid FROM urbanenvironment.ue_ms_crossings_wegdeel_punt
AS r,  tempdonut as m
      WHERE ST_Intersects(r.the_geom, m.the_geom)';

Thanks again,

j?lio almeida
-------------- next part --------------
An HTML attachment was scrubbed...
URL: 
<http://postgis.refractions.net/pipermail/postgis-users/attachments/20110516/212d79ac/attachment-0001.html>

------------------------------

Message: 2
Date: Mon, 16 May 2011 10:23:15 -0700 (PDT)
From: truongxuan quang <truongxuanquang at yahoo.com>
Subject: [postgis-users] Help for my error when I install Postgis
To: postgis-users at postgis.refractions.net
Message-ID: <11939.11902.qm at web114704.mail.gq1.yahoo.com>
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 use PostgreSQL and PostGIS for managing shape file data. Last week I 
tried to install PostgreSQL 8.4, after that I remove PostgreSQL 8.3 (I only 
uninstalled inside windows control panel/add and then I delete all folder inside 

window programs) and I reinstall 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 

Many thanks

T.X.Quang
-------------- next part --------------
An HTML attachment was scrubbed...
URL: 
<http://postgis.refractions.net/pipermail/postgis-users/attachments/20110516/3cd27eaa/attachment-0001.html>

------------------------------

Message: 3
Date: Mon, 16 May 2011 19:50:34 +0200
From: Ren? Riech <rene.riech at arcor.de>
Subject: Re: [postgis-users] Help for my error when I install Postgis
To: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
Message-ID: <op.vvk46kax1ftthu at roarglch>
Content-Type: text/plain; charset=iso-8859-15; format=flowed;
    delsp=yes

On Mon, 16 May 2011 19:23:15 +0200, truongxuan quang  
<truongxuanquang at yahoo.com> wrote:

> Dear list
>
> I face with some problem in installation PostgreSQL 8.3 on winXP , long  
> time
> before I use PostgreSQL and PostGIS for managing shape file data. Last  
> week I
> tried to install PostgreSQL 8.4, after that I remove PostgreSQL 8.3 (I  
> only
> uninstalled inside windows control panel/add and then I delete all  
> folder inside
> window programs) and I reinstall 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.

Hi Truongxuan,

I once had also a problem with a deinstallation of PostgreSQL. I found that
script, It deletes everytthing what stays after the deinstallation.

echo on
@REM  
********************************************************************************
@REM
@REM  NAME          : Remove_PostgreSQL_Total.CMD
@REM
@REM  DESCRIPTION   : Entfernt vollst?ndig alle Verzeichnisse und Eintr?ge  
die durch
@REM                  die De-Installation von PostgreSQL nicht entfernt  
wurden.
@REM
@REM                  Diese Datei darf erst nach der De-Installtion von  
PostgreSQL
@REM                  gestartet werden. Sie mu? von dem User ausgef?hrt  
werden, unter
@REM                  dem die Installation von PostgreSQL erfolgte.  
Normalerweise ist
@REM                  das der Administrator unter Windows.
@REM
@REM                  Die Verzeichnisse beziehen sich auf eine  
PostgreSQL-Standard-
@REM                  Installation!
@REM
@REM  
********************************************************************************

@REM    -------------------------------------------------------------
@REM    Benutzerkonto, unter dem der PostgreSQL-Datenbankserver l?uft
@REM    -------------------------------------------------------------

         @set WIN_USER=postgres

@REM  
================================================================================

         NET USER %WIN_USER% /DELETE

         rmdir /S /Q "%SystemDrive%\Dokumente und  
Einstellungen\%USERNAME%\Anwendungsdaten\PostgreSQL"
         rmdir /S /Q "%SystemDrive%\Dokumente und Einstellungen\%WIN_USER%"
         rmdir /S /Q "%ProgramFiles%\PostgreSQL"

Use this script AFTER the deinstallation of PostgreSQL as an administrator  
user.

maybe this helps.

with regards

Ren?

------------------------------

_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

End of postgis-users Digest, Vol 109, Issue 15
**********************************************
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20110517/cae527a6/attachment.html>