[postgis-users] postgis socket name problem

[Vincent De Groote]

Hello,

Yes, the Postgresql server is running.  This really seems to be a socket
name problem:  

- the server created the "/tmp/.s.PGSQL.5432" socket
- pgsql2shp tries to connect using '/var/run/postgresql/.s.PGSQL.5432' 

If I create a link from /var/run/postgresql -> /tmp, pgsql2shp connects
successfully.

The pgsql2shp program seems to connect to the database using a standard
postgresql api call, so I don't understand how this can happen.
I searched a hardcoded string '/var/run/postgresql' in the postgresql
sources, but I didn't find it.

Vincent







On Mon, 2011-05-02 at 12:16 +0200, René Riech wrote:

> Hi Vincent,
> 
> maybe a stupid question, but your PostgreSQL process, the server,
> is running?
> What does: ps auxw | grep post
> say?
> 
> I found that, regarding to your error:
> http://www.revsys.com/writings/postgresql/errors.html#cannot-connect-local
> 
> 
> With regards,
> 
> René
> 
> 
> 2011/4/30 Vincent De Groote <vdg.encelade at gmail.com>:
> > Hello,
> >
> > I'm installing postgresql 8.4.8 and postgis 1.5.2 on an ubuntu computer.
> > Everything is installed in a subdirectory of my home directory, using my
> > standard user id (I'm not using a postgres user id)
> >
> > for postgresql, geos and proj, the configure / make / make check / make
> > install worked without problem
> > for postgis, the configure / make worked.
> >
> > The make check target fails because the pgsql2shp program tries to connect
> > to the database using a unix socket named
> > '/var/run/postgresql/.s.PGSQL.5432', but the server uses a socket named
> > '/tmp/.s.PGSQL.5432'.
> >
> > I cannot find where the socket name used by pgsql2shp comes from.
> > /var/run/postgresql was never used as a parameter of configure files:  all
> > configure scripts were run with --prefix=<subdir of my home dir>
> >
> > Any idea ?
> >
> > Thanks for your reply
> >
> > Vincent De Groote
> >
> >
> > _______________________________________________
> > 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


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20110502/7a084743/attachment.html>