[GRASS-user] Grass PostgreSQL problem

[Martin Album Ytre-Eide]

After trying different options - I now get :
DBMI-Postgres driver error:
Cannot connect to Postgres: could not connect to server: No such file or directory
	Is the server running locally and accepting
	connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
(The same problem for grass 6.4.2)

Postgres use the unix_domain_socket /tmp/ - so it seems to me that grass is listening to the wrong place. This could be changed in  postgresql.conf file at database build time.

Is there a way to change what unix_domain_socket grass is listening to?

postgres server and databases seems to be working ok, and I can connect trough psql. 

Martin



________________________________________
Fra: neteler.osgeo at gmail.com [neteler.osgeo at gmail.com] på vegne av Markus Neteler [neteler at osgeo.org]
Sendt: 26. september 2013 12:11
Til: Martin Album Ytre-Eide
Kopi: grass-user at lists.osgeo.org
Emne: Re: [GRASS-user] Grass70 PostgreSQL problem

On Wed, Sep 25, 2013 at 10:51 AM, Martin Album Ytre-Eide
<Martin.Album.Ytre-Eide at nrpa.no> wrote:
> Hello all.
>
> I have done this before on different installs, but this time I can't get it
> right.
>
> I am trying to add a table to a postgres database, by importing a .shp-file.
> It fails to import the table and gives this error:
>
> DBMI-PostgreSQL driver error:
> Connection failed.
> fe_sendauth: no password supplied

This is probably a backend setup error (not related to GRASS itself).
See for example (random link):

http://superuser.com/questions/565510/postgresql-authentication-failure-with-trust-option

Markus