[GRASS-user] postgres connection failure SOLVED

[Dave Roberts]

Friends,

    Deleting the postgres installed from source and re-installing 
postgres from pacman (arch linux) solved the problem, although it did 
require a full database dump and restore.

    I still find the interaction between user postgres and systemd init 
files to be confusing, but for now perhaps I'm alright.

Dave

On 11/19/16 11:45, Dave Roberts wrote:
> Friends,
>
>    I recently made some changes to postgresql (deleted from package
> manager and installed from source 9.5.1).  It was a hassle because they
> install in different locations and put the bin files in different
> places, etc.  It's all working now, except for GRASS, which seems to be
> running a command from the old installation and failing to connect.  E.g.
>
> GRASS GIS 7.3.svn > db.connect driver=pg
>     database="host=127.0.0.1,dbname=beartooth"
> GRASS GIS 7.3.svn > db.tables
> DBMI-PostgreSQL driver error:
> Connection failed.
> could not connect to server: No such file or directory
>     Is the server running locally and accepting
>     connections on Unix domain socket
>         "/run/postgresql/.s.PGSQL.5432"?
>
> HOWEVER
>
> GRASS GIS 7.3.svn > pgsql -h 127.0.0.1 -d beartooth -p 5432
> psql (9.5.1)
> Type "help" for help.
> \d
>
> beartooth=# \d
>              List of relations
>  Schema |       Name       | Type  | Owner
> --------+------------------+-------+--------
>  public | boundary         | table | dvrbts
>  public | draft_map        | table | dvrbts
>    .         .                  .       .
>    .         .                  .       .
>  public | vmap             | table | dvrbts
> (31 rows)
> \q
>
> run from inside GRASS shows that postgres is running and accepting
> connections on the default port.
>
> The connection failure message is commonly produced from a mismatch of
> versions of postgres, so I'm guessing that somewhere GRASS is trying the
> old version.
>
> Any ideas?
>
> Thanks, Dave
>
> GRASS GIS 7.3.svn (r69510)
> Linux luthertucker 4.8.7-1-ARCH #1 SMP PREEMPT Thu Nov 10 17:22:48 CET
> 2016 x86_64 GNU/Linux
>
>
> _______________________________________________
> grass-user mailing list
> grass-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/grass-user