[postgis-users] Still installation (last step) problems

[Darren Houston]

Hello Bato,

Unrelated to your psql question, you may have problems with Proj4 later on. If 
you configured Proj4 with --prefix=/usr/local/proj4 and did a make and make 
install (you need to be root for the make install), Proj4 directory should be 
in your /usr/local directory. If not, something went wrong or a step wasn't 
completed. Also, you will need to add an entry for the Proj4 libs 
in /etc/ld.so.conf and run ldconfig again (if the Proj4 libs are not 
in /usr/local/lib, add something like /usr/local/proj4/lib to ld.so.conf).

HTH,

Darren H.

On July 21, 2004 02:56 am, strk wrote:
> On Wed, Jul 21, 2004 at 12:21:26AM -0700, Bato Pure wrote:
> > Hi Folks,
> >
> > Even I followed Vautier's suggestion I could not solve
> > my problem on "psql -d mydb -f postgis.sql".
> >
> > Messages are:
> > BEGIN
> >         message
> > ------------------------
> >  PL/PgSQL is installed.
> > (1 row)
> >
> > psql:postgis.sql:38: ERROR:  function "histogram2d_in"
> > already exists with same argument types
> > psql:postgis.sql:43: ERROR:  current transaction is
> > aborted, commands ignored until end of transaction
> > block
> >
> > ... (all same)
>
> It seems you already installed postgis in 'mydb', can that be the
> case ? If 'mydb' is a new db try dropping and recreating again.
> Also give a try to postgis_undef.sql as it *could* work.
>
> --strk;
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users