Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 60DD39FB894 for ; Thu, 19 Apr 2007 02:41:50 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 90740-09 for ; Thu, 19 Apr 2007 02:41:46 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from mail.hq.astra.ph (unknown [202.78.101.198]) by postgresql.org (Postfix) with ESMTP id 487849FB893 for ; Thu, 19 Apr 2007 02:41:45 -0300 (ADT) Received: from [192.168.10.32] (thorin.hq1.astra.ph [192.168.10.32]) by mail.hq.astra.ph (Postfix) with ESMTP id CA58E1DBC6; Thu, 19 Apr 2007 13:38:37 +0800 (PHT) Message-ID: <462700D0.1010903@gmail.com> Date: Thu, 19 Apr 2007 13:40:32 +0800 From: Carlo Florendo User-Agent: Thunderbird 1.5.0.10 (Windows/20070221) MIME-Version: 1.0 To: =?ISO-8859-1?Q?Mar=EDa_Jos=E9_Peir=F3_Sim=F3?= Cc: pgsql-cygwin@postgresql.org Subject: Re: Question References: <1176817286.4624ce8652375@webmail.upv.es> In-Reply-To: <1176817286.4624ce8652375@webmail.upv.es> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/3 X-Sequence-Number: 4374 María José Peiró Simó wrote: > We are students of the Universidad Politécnica de Valencia and we have had > problems with the installation of Postgre 8.2.3 > > First of all, sorry about our english, but I suposse we can understand. > > We installed Postgre 8.2.3 for Windows from www.postgresql.org and it ran well. > The problem began when we uninstalled that, and installed Postgis. All the ^^^^^^^^^^ You are *not* supposed to uninstall PostgreSQL. The PostGIS website says that, to install PostGIS, you have to: Un-tar the PostGIS tar-ball in the 'contrib' directory of your PostgreSQL source tree. You must have the PL/pgSQL prodedural language installed before installing PostGIS. tar xvfz postgis-1.1.0.tar.gz cd postgis-1.1.0 ./configure make make install createlang plpgsql yourtestdatabase psql -d yourtestdatabase -f lwpostgis.sql psql -d yourtestdatabase -f spatial_ref_sys.sql You may want to look at the PostGIS site for documentation: http://postgis.refractions.net/documentation/ Thank you very much. Best Regards, Carlo -- Carlo Florendo Softare Engineer/Network Co-Administrator Astra Philippines Inc. UP-Ayala Technopark, Diliman 1101, Quezon City Philippines http://www.astra.ph -- The Astra Group of Companies 5-3-11 Sekido, Tama City Tokyo 206-0011, Japan http://www.astra.co.jp