[postgis-users] Postgis install

[Kralidis,Tom [Burlington]]

> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net 
> [mailto:postgis-users-bounces at postgis.refractions.net] On 
> Behalf Of dhouston at beyondcompliance.ca
> Sent: Wednesday, June 16, 2004 4:07 PM
> To: PostGIS Users Discussion
> Subject: Re: [postgis-users] Postgis install
> 
> 
> Hi Tom,
> 
> Make sure plpgsql is installed on your computer. Look for 
> plpgsql.so in the lib directory of your PostgreSQL 
> installation. If plpgsql is located on your computer try 
> using -L with createlang to specify the directory where 
> plpgsql resides.
>

Thanks.  Passing -L to createlang worked.  However, now I'm running into
issues when trying to feed postgis.sql into the db, i.e.

psql -f postgis.sql -d devgeo

<a bunch of lines like these)

psql:/usr/local/src/postgres/postgresql-7.4.3/contrib/postgis-0.8.2/post
gis.sql:1895: ERROR:  current transaction is aborted, commands ignored
until end of transaction block

..Tom


 
> Hope this helps,
> 
> Darren H.
> 
> Kralidis,Tom [Burlington] (Tom.Kralidis at ec.gc.ca) wrote:
> >
> >
> > Hi,
> >
> > I'm having trouble installing PostGIS:
> >
> > Environment:
> >
> > $ uname -a
> > Linux devgeo 2.6.5-1.358smp #1 SMP Sat May 8 09:25:36 EDT 2004 i686 
> > i686 i386 GNU/Linux
> >
> > postgresql-7.4.3 (from source)
> > postgis-0.8.2 (from source)
> >
> > All has been going well, until:
> >
> > [postgres at devgeo src]$ /usr/local/pgsql/bin/createlang 
> plpgsql devgeo
> > createlang: language installation failed: ERROR:  could not access 
> > file
> > "$libdir/plpgsql": No such file or directory
> > [postgres at devgeo src]$
> >
> > Any idea what gives?
> >
> > Thanks
> >
> > ..Tom
> >
> > =========================
> > Tom Kralidis
> > Systems Scientist
> > Environment Canada
> > Tel: +01-905-336-4409
> > http://www.ec.gc.ca/ _______________________________________________
> > postgis-users mailing list
> > postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> >
> 
> _______________________________________________
> postgis-users mailing list postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>