I run the commands from your installation instructions after creating a docker file for the data and copying all data to the volume. The line terminators were changed to make this work from \r\n to \n. Otherwise, installation fails.
Now, I get an issue at the end of the build when I try to import the data at the end of the load. This is not from a combined file.
How can I resolve this? Can this be resolved? If so from the files, could someone either tell me how or do so? Thanks.
PS E:\nominatim-data\use> docker run -t -v postgres:/data nominatim sh /app/init.sh /data/north-america-latest.osm.pbf
postgresdata 2
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.
The database cluster will be initialized with locale "C.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
fixing permissions on existing directory /data/postgresdata ... ok
creating subdirectories ... ok
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default timezone ... Etc/UTC
selecting dynamic shared memory implementation ... posix
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
WARNING: enabling "trust" authentication for local connections
You can change this by editing pg_hba.conf or using the option -A, or
--auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
/usr/lib/postgresql/11/bin/pg_ctl -D /data/postgresdata -l logfile start
waiting for server to start....2019-06-24 08:47:21.321 UTC [26] LOG: listening on IPv4 address "127.0.0.1", port 5432
2019-06-24 08:47:21.321 UTC [26] LOG: could not bind IPv6 address "::1": Cannot assign requested address
2019-06-24 08:47:21.321 UTC [26] HINT: Is another postmaster already running on port 5432? If not, wait a few seconds and retry.
2019-06-24 08:47:21.433 UTC [26] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2019-06-24 08:47:21.635 UTC [27] LOG: database system was shut down at 2019-06-24 08:47:18 UTC
2019-06-24 08:47:21.704 UTC [26] LOG: database system is ready to accept connections
done
server started
NOTICE: database "nominatim" does not exist, skipping
DROP DATABASE
2019-06-24 08:56:13 == module path: /app/src/build/module
2019-06-24 08:56:13 == Create DB
2019-06-24 08:56:13.736 UTC [98] FATAL: database "nominatim" does not exist
2019-06-24 08:56:16 == Setup DB
Postgres version found: 11
Postgis version found: 2.5
2019-06-24 08:56:27 == WARNING: optional external UK postcode table file (/app/src/data/gb_postcode_data.sql.gz) not found. Skipping.
2019-06-24 08:56:28 == Import data
osm2pgsql version 0.96.0 (64 bit id space)
Parsing gazetteer style file '/app/src/settings/import-full.style'.
Using projection SRS 4326 (Latlong)
NOTICE: table "place" does not exist, skipping
Allocating memory for dense node cache
Allocating dense node cache in one big chunk
Allocating memory for sparse node cache
Sharing dense sparse
Node-cache: cache=4172MB, maxblocks=66752*65536, allocation method=11
Mid: pgsql, cache=4172
Setting up table: planet_osm_nodes
NOTICE: table "planet_osm_nodes" does not exist, skipping
Setting up table: planet_osm_ways
NOTICE: table "planet_osm_ways" does not exist, skipping
Setting up table: planet_osm_rels
NOTICE: table "planet_osm_rels" does not exist, skipping
Reading in file: /data/north-america-latest.osm.pbf
Using PBF parser.
Processing: Node(145900k 48.5k/s) Way(0k 0.00k/s) Relation(0 0.00/s)2019-06-24 09:47:03.275 UTC [319] LOG: using stale statistics instead of current ones because stats collector is not responding
Processing: Node(147560k 47.4k/s) Way(0k 0.00k/s) Relation(0 0.00/s)2019-06-24 09:49:03.333 UTC [323] LOG: using stale statistics instead of current ones because stats collector is not responding
Processing: Node(392170k 34.0k/s) Way(0k 0.00k/s) Relation(0 0.00/s)2019-06-24 12:09:05.878 UTC [603] LOG: using stale statistics instead of current ones because stats collector is not responding
Processing: Node(1094243k 29.6k/s) Way(86731k 0.32k/s) Relation(91790 15.89/s)2019-06-28 00:25:15.390 UTC [214] LOG: unexpected EOF on client connection with an open transaction
2019-06-28 00:25:15.983 UTC [213] LOG: unexpected EOF on client connection with an open transaction
Killed
2019-06-28 00:25:16.154 UTC [215] LOG: incomplete message from client
2019-06-28 00:25:16.154 UTC [215] CONTEXT: COPY planet_osm_rels, line 91836
2019-06-28 00:25:16.154 UTC [215] STATEMENT: COPY planet_osm_rels FROM STDIN
2019-06-28 00:25:16.393 UTC [215] ERROR: unexpected EOF on client connection with an open transaction
2019-06-28 00:25:16.393 UTC [215] CONTEXT: COPY planet_osm_rels, line 91836
2019-06-28 00:25:16.393 UTC [215] STATEMENT: COPY planet_osm_rels FROM STDIN
2019-06-28 00:25:16.154 UTC [212] LOG: incomplete message from client
2019-06-28 00:25:16.154 UTC [212] CONTEXT: COPY place, line 42107155
2019-06-28 00:25:16.154 UTC [212] STATEMENT: COPY place (osm_type, osm_id, class, type, name, admin_level, address, extratags, geometry) FROM STDIN
2019-06-28 00:25:16.424 UTC [215] LOG: could not send data to client: Broken pipe
2019-06-28 00:25:16.424 UTC [215] STATEMENT: COPY planet_osm_rels FROM STDIN
2019-06-28 00:25:16.428 UTC [212] ERROR: unexpected EOF on client connection with an open transaction
2019-06-28 00:25:16.428 UTC [212] CONTEXT: COPY place, line 42107155
2019-06-28 00:25:16.428 UTC [212] STATEMENT: COPY place (osm_type, osm_id, class, type, name, admin_level, address, extratags, geometry) FROM STDIN
2019-06-28 00:25:16.459 UTC [212] LOG: could not send data to client: Broken pipe
2019-06-28 00:25:16.459 UTC [212] STATEMENT: COPY place (osm_type, osm_id, class, type, name, admin_level, address, extratags, geometry) FROM STDIN
2019-06-28 00:25:25.196 UTC [102] ERROR: relation "place" does not exist at character 15
2019-06-28 00:25:25.196 UTC [102] STATEMENT: select * from place limit 1
2019-06-28 00:25:25.224 UTC [215] FATAL: terminating connection because protocol synchronization was lost
PHP Fatal error: Uncaught Nominatim\DatabaseError: [500]: Database query failed
thrown in /app/src/lib/DB.php on line 187