[postgis-users] Installation - help

Tue Jul 30 09:10:24 PDT 2002

I don't know... if you don't specify a port parameter, it should default to
unix sockets... the other way is to run postmaster with the -i option, to
allow inet socket connections.

Chris
----- Original Message -----
From: "Riyaz Prasla" <riyazprasla at yahoo.com>
To: <postgis-users at postgis.refractions.net>
Sent: Tuesday, July 30, 2002 6:07 AM
Subject: Re: [postgis-users] Installation - help

> Chris,
>   When I run: psql -p 5583 test
>
> I get the following error:
> psql: could not connect to server: Connection refused
>         Is the server running locally and accepting
>         connections on Unix domain socket
> "/tmp/.s.PGSQL.5583"?
>
> How can I make createlang use default Unix sockets?
>
> Thanks,
> Riyaz
>
> --- Chris Hodgson <chodgson at refractions.net> wrote:
> > 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
> > >
> > >
> >
> === message truncated ===
>
>
> __________________________________________________
> 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
>
>