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
[email protected]
http://lists.osgeo.org/mailman/listinfo/grass-user
_______________________________________________
grass-user mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/grass-user
