[postgis-users] Installation - help

[Chris Hodgson]

Is postgresql running with the -i option? it seems like createlang is trying
to connect via inet sockets and not the default unix sockets... what happens
if you do:
psql -p 5583 test

If you get the same error, then you must not be running with the -i
option... but I'm not sure why createlang isn't using unix sockets by
default...

Chris
----- Original Message -----
From: "Riyaz Prasla" <riyazprasla at yahoo.com>
To: <postgis-users at postgis.refractions.net>
Sent: Monday, July 29, 2002 2:52 PM
Subject: Re: [postgis-users] Installation - help


> I am not getting that error anymore but I am getting a
> different one now. So when I type: createlang plpgsql
> test --pglib /usr/local/pgsql/lib, I get the following
> error:
>
>
> Connection to database 'test' failed.
> connectDB() -- connect() failed: Connection refused
> Is the postmaster running at 'localhost' and accepting
> connections on Unix socke
> t '5583'?
> Cannot install language
>
>
> Even though my postmaster is running. I have checked
> that by connecting to the database by this command:
> psql mydatabase
>
> Also, I am running Linux on a Cobalt Qube.I have
> installed the 7.2 version of postgres and trying to
> install 0.7.1 version of postgis.
>
> Any help on this, appreciated.
>
> -Riyaz.
>
> --- Chris Hodgson <chodgson at refractions.net> wrote:
> > Sorry, please give us some more info to work with
> > here... what platform are
> > you on? where exactly are the pglibs? have you had
> > other versions of
> > postgres installed before (could  you be using
> > createlang from a different
> > version of postgres than your libraries are?), did
> > the createdb command not
> > give you any problems? (that seems weird, it should
> > need the same libraries)
> >
> > Also, you need to be a postgres user with full
> > access permissions (root
> > postgres user is simplest) in order to run the
> > createlang command. (this
> > isn't the right error message for that problem, but
> > I've never seen this
> > message before, so I'm grabbing at straws here)
> >
> > If none of this helps, perhaps you should post to
> > the postgres list, as your
> > problem is more specific to postgres than to
> > postgis...
> >
> > Chris
> >
> > ----- Original Message -----
> > From: "Riyaz Prasla" <riyazprasla at yahoo.com>
> > To: <postgis-users at postgis.refractions.net>
> > Sent: Monday, July 29, 2002 11:14 AM
> > Subject: Re: [postgis-users] Installation - help
> >
> >
> > > I tried setting the path but still gives the same
> > > error.
> > >
> > > Thanks,
> > > Riyaz
> > > --- Chris Hodgson <chodgson at refractions.net>
> > wrote:
> > > > Where did you install postgres to? It seems that
> > the
> > > > postgres libraries are not in your
> > > > LD_LIBRARY_PATH... they should either be in the
> > > > 'lib' subdirectory of where you installed
> > postgres,
> > > > or in /usr/lib somewhere. Where-ever they are,
> > you
> > > > need to find them, and add their location to
> > either
> > > > your LD_LIBRARY_PATH, or your PGLIB environment
> > > > variable. Something like:
> > > >
> > > > set
> > LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/opt/pgsql/lib
> > > >
> > > > should do it, with the correct location in place
> > of
> > > > /opt/pgsql/lib, depending on your shell...
> > > >
> > > > Chris
> > > >
> > > >   ----- Original Message -----
> > > >   From: Riyaz at umapinc.com
> > > >   To: postgis-users at postgis.refractions.net
> > > >   Sent: Monday, July 29, 2002 10:31 AM
> > > >   Subject: [postgis-users] Installation - help
> > > >
> > > >
> > > >
> > > >   Hello,
> > > >
> > > >   I am getting the error below when I try to run
> > > > this command:   createlang plpgsql databasename
> > > >
> > > >   Cannot determine PostgreSQL lib directory
> > (PGLIB).
> > > >
> > > >   You must identify the PGLIB either with a
> > --pglib
> > > > option
> > > >   or by setting the PGLIB environment variable.
> > > >
> > > >   Any help on this?
> > > >
> > > >   Thanks,
> > > >   Riyaz
> > > >
> > >
> > >
> > > __________________________________________________
> > > Do You Yahoo!?
> > > Yahoo! Health - Feel better, live better
> > > http://health.yahoo.com
> > >
> > > _______________________________________________
> > > 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
>
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Health - Feel better, live better
> http://health.yahoo.com
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>