[postgis-users] Installation - help
Paul Ramsey
pramsey at refractions.net
Tue Jul 30 09:19:14 PDT 2002
Even without the -i, you can run on different unix ports (strange, yes).
The clue here is the port number. The 'createlang' program for some
reason tried to connect to port 5583, which is not the standard port.
This says to me "this guy has a second copy of createlang hanging around
which was compiled with odd defaults". Type "which createlang", I bet it
is not the one your are expecting.
If you are on an RPM based Linux, do a "rpm -qa | grep post" and then
*remove* all the old postgresql packages you have hanging around. When
installing from source, always remove the existing stuff from the
distribution in order to avoid these problems.
P.
Chris Hodgson wrote:
>
> 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
> >
> >
>
> _______________________________________________
> 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
\_
More information about the postgis-users
mailing list