<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/3.30.3">
</HEAD>
<BODY>
Hello,<BR>
<BR>
Yes, the Postgresql server is running. This really seems to be a socket name problem: <BR>
<BR>
- the server created the "/tmp/.s.PGSQL.5432" socket<BR>
- pgsql2shp tries to connect using '/var/run/postgresql/.s.PGSQL.5432' <BR>
<BR>
If I create a link from /var/run/postgresql -> /tmp, pgsql2shp connects successfully.<BR>
<BR>
The pgsql2shp program seems to connect to the database using a standard postgresql api call, so I don't understand how this can happen.<BR>
I searched a hardcoded string '/var/run/postgresql' in the postgresql sources, but I didn't find it.<BR>
<BR>
Vincent<BR>
<BR>
<BR>
<BR>
<BR>
<BR>
<BR>
<BR>
On Mon, 2011-05-02 at 12:16 +0200, René Riech wrote:
<BLOCKQUOTE TYPE=CITE>
<PRE>
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:
<A HREF="http://www.revsys.com/writings/postgresql/errors.html#cannot-connect-local">http://www.revsys.com/writings/postgresql/errors.html#cannot-connect-local</A>
With regards,
René
2011/4/30 Vincent De Groote <<A HREF="mailto:vdg.encelade@gmail.com">vdg.encelade@gmail.com</A>>:
> 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
> <A HREF="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A>
> <A HREF="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</A>
>
>
_______________________________________________
postgis-users mailing list
<A HREF="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A>
<A HREF="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</A>
</PRE>
</BLOCKQUOTE>
<BR>
</BODY>
</HTML>