[postgis-users] Postgis install

[strk]

On Wed, Jun 16, 2004 at 04:25:22PM -0400, Kralidis,Tom [Burlington] wrote:
> 
> 
> > -----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

You need to find the first ERROR line.
Dump error to a file and look for that, that will help.
--strk;

> 
> 
>  
> > 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
> > 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users