[postgis-users] Installation - help

Riyaz Prasla riyazprasla at yahoo.com
Tue Jul 30 06:07:26 PDT 2002


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




More information about the postgis-users mailing list