barefoot: Matcher server Opening PostgreSQL connection failed

I followed the Matcher server part. In step 3 I got the following error.

$ java -jar target/barefoot-0.1.0-matcher-jar-with-dependencies.jar --geojson config/server.properties config/oberbayern.properties
2017-02-08 15:34:18,022 INFO  [main] ServerControl: initialize server
2017-02-08 15:34:18,027 INFO  [main] ServerControl: read database properties from file config/oberbayern.properties
2017-02-08 15:34:18,029 INFO  [main] Loader: load map from database oberbayern
2017-02-08 15:34:18,029 INFO  [main] Loader: open road reader for database oberbayern at localhost:5432
2017-02-08 15:34:18,029 INFO  [main] Loader: database.host=localhost
2017-02-08 15:34:18,030 INFO  [main] Loader: database.port=5432
2017-02-08 15:34:18,030 INFO  [main] Loader: database.name=oberbayern
2017-02-08 15:34:18,030 INFO  [main] Loader: database.table=bfmap_ways
2017-02-08 15:34:18,030 INFO  [main] Loader: database.user=osmuser
2017-02-08 15:34:18,030 INFO  [main] Loader: database.road-types=./map/tools/road-types.json
2017-02-08 15:34:18,065 INFO  [main] PostGISReader: open reader (standard)
2017-02-08 15:34:18,065 INFO  [main] PostGISReader: open reader (parameterized)
2017-02-08 15:36:25,268 ERROR [main] ServerControl: Opening PostgreSQL connection failed: The connection attempt failed.
2017-02-08 15:36:25,269 INFO  [Thread-0] ServerControl: stopping server
2017-02-08 15:36:25,270 ERROR [Thread-0] ServerControl: stopping server failed, not yet started

Thanks for your helps.

About this issue

Original URL
State: closed
Created 7 years ago
Comments: 18

Most upvoted comments

Thank you. These are the outputs:

$ sudo docker exec -it barefoot-oberbayern bash -c 'sudo service postgresql status'
9.3/main (port 5432): online


$ sudo docker exec -it barefoot-oberbayern bash -c 'sudo -u postgres psql -c "select * from pg_roles;"'


 rolname  | rolsuper | rolinherit | rolcreaterole | rolcreatedb | rolcatupdate | rolcanlogin | rolreplication | rolconnlimit | rolpassword | rolvaliduntil | rolconfig |  oid  
----------+----------+------------+---------------+-------------+--------------+-------------+----------------+--------------+-------------+---------------+-----------+-------
 postgres | t        | t          | t             | t           | t            | t           | t              |           -1 | ********    |               |           |    10
 osmuser  | f        | t          | f             | f           | f            | t           | f              |           -1 | ********    |               |           | 17791
(2 rows)



$ sudo docker exec -it barefoot-oberbayern bash -c 'psql -h localhost -d oberbayern -U osmuser -W'

Password for user osmuser: 
psql (9.3.15)
SSL connection (cipher: DHE-RSA-AES256-GCM-SHA384, bits: 256)
Type "help" for help.

oberbayern=>

I ziped four files : postgresql.log, postgresql.conf, pg_hba.conf and output of inspect command (inspect.txt).

files.zip

Thanks.

rahimramezanian on Feb 11, 2017