Обсуждение: Question

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
modules aparently run well, but the command window "psql to postgres" doesn't
appear.

We hope somebody could help us.

Thank you very much.

--

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

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