[postgis-users] createlang plpgsql mydatabase

[Paul Ramsey]

You can force this to work with judicious use of editing the sql file 
and other tricks, but fundamentally it looks like the postgres 
installation you actually have running does not know where its library 
directory is. This is usually a result of compiling in one spot and 
moving to another. So it sounds like you have a mixed install of 
different components, or multiple components. Could you have left the 
binary deb/rpm components in place when you compiled from source? That 
trips people up all the time.

On Friday, April 16, 2004, at 08:09 AM, Robert Aldridge wrote:

> Thanks for the quick reply.  That very well could be
> the problem, I suppose.  In my excitement to get
> everything set up on this new laptop, I could have
> messed something up.  I went through several
> iterations of trying to install postgresql from .deb
> files without success.  I finally ended up installing
> postgresql and postgis from source.  Everything seemed
> to install correctly.
>
> I gave up on using createlang and used the
> instructions from the PostgreSQL Documentation on
> 'CREATE LANGUAGE' to manually create the language.
> Again, everyting seemed to go fine with no errors.
>
> However, when I try to run 'psql -f postgis -d
> mydatabase', I get:
>
> psql:postgis.sql:44: NOTICE: type "histogram2d" is not
> yet defined
> DETAIL:  Creating a shell type definition.
> psql:postgis.sql:44: ERROR: could not access file
> "$libdir/libpostgis.so.0.8": No such file or directory
>
> This is followed by lots of 'ERROR: current trasaction
> is aborted, commands ignored until end of transaction
> block' errors.
>
> Is this install fixable, or do I need to try starting
> over from scratch?
>
> Thanks,
>
> Robert Aldridge
>
> Could you have different versions of createlang and
> psql? Because they
> both use libpq, if they are compiled at the same time,
> with the same
> configuration, they generally work identically (same
> libpq defaults),
> so the problem you are getting should not occur.
>
> On Friday, April 16, 2004, at 07:30 AM, Robert
> Aldridge wrote:
>
>> I'm having problems with the createlang command
> when,
>> as the postgres user, I run:
>>
>> createlang plpgsql mydatabase
>>
>> I get:
>>
>> createlang: could not connect to database
> mydatabase:
>> could not connect to server: No such file or
> directory
>>      Is the server running locally and accepting
>>      connections on Unix domain socket
>> "/tmp/.s.PGSQL.5432"?
>>
>> However, if I run:
>>
>> psql -d mydatabase
>>
>> It connects to the database fine.  I get:
>>
>> mydatabase=#
>>
>>
>> Any ideas why createlang isn't working?  Do I have
> to
>> install the language before I can create it on a
>> database?
>>
>> Thanks for any input you can provide,
>>
>> Robert Aldridge
>
>
> 	
> 		
> __________________________________
> Do you Yahoo!?
> Yahoo! Tax Center - File online by April 15th
> http://taxes.yahoo.com/filing.html
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
      Paul Ramsey
      Refractions Research
      Email: pramsey at refractions.net
      Phone: (250) 885-0632