# Migrate-Nominatim-Database-to-Ubuntu-18.04

**Repository Path**: liuchengxian8409/Migrate-Nominatim-Database-to-Ubuntu-18.04

## Basic Information

- **Project Name**: Migrate-Nominatim-Database-to-Ubuntu-18.04
- **Description**: 在 Ubuntu 18.04 操作系统安装 Nominatim 教程
- **Primary Language**: Unknown
- **License**: MIT
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 2
- **Forks**: 0
- **Created**: 2022-09-21
- **Last Updated**: 2023-06-20

## Categories & Tags

**Categories**: Uncategorized

**Tags**: Instruction

## README

# __Migrating Nominatim Database to _`Ubuntu 18.04`___

## __1. Installing the Required Softwares__

```
sudo apt update -y --fix-missing
sudo apt upgrade -y

sudo apt install -y build-essential cmake g++ libboost-dev libboost-system-dev \
                        libboost-filesystem-dev libexpat1-dev zlib1g-dev libxml2-dev\
                        libbz2-dev libpq-dev libproj-dev \
                        postgresql-server-dev-10 postgresql-10-postgis-2.4 \
                        postgresql-contrib-10 \
                        apache2 php php-pgsql libapache2-mod-php php-pear php-db \
                        php-intl git

sudo apt install -y python3-setuptools python3-dev python3-pip \
                        python3-psycopg2 python3-tidylib phpunit php-cgi

pip3 install --user behave nose
sudo pear install PHP_CodeSniffer
```

## __2. System Configuration__

### __2.1 Creating Dedicated User Accounts__

```
sudo useradd -d /srv/nominatim -s /bin/bash -m nominatim

export USERNAME=nominatim
export USERHOME=/srv/nominatim

sudo chmod a+x $USERHOME
```

### __2.2 Setting up PostgreSQL__

#### Start the postgresql service

```
sudo systemctl start postgresql
```

#### Edit postgresql configuration to allow remote access, including _`postgresql.conf`_ and _`pg_hba.conf`_

__`postgresql.conf:`__ /etc/postgresql/10/main/postgresql.conf

```
#listen_addresses = 'localhost'
listen_addresses = '*'

#shared_buffers = 128MB
shared_buffers = 2048MB

#work_mem = 4MB
work_mem = 128MB

#maintenance_work_mem = 64MB
maintenance_work_mem = 1024MB

#temp_buffers = 8M
temp_buffers = 512MB

#fsync = on
fsync = off

#synchronous_commit = on
synchronous_commit = off
```

__`pg_hba.conf:`__ /etc/postgresql/10/main/pg_hba.conf

```
# TYPE  DATABASE        USER            ADDRESS                 METHOD
host	all		all		0.0.0.0/0		md5
```

#### Set user _`"postgres"`_ password

```
sudo passwd postgres
```

#### Create postgresql user and database

```
sudo -s -u postgres
psql

CREATE USER nominatim WITH PASSWORD 'nominatim';
CREATE DATABASE nominatim;
GRANT ALL PRIVILEGES ON DATABASE nominatim to nominatim;
ALTER USER nominatim WITH SUPERUSER CREATEROLE CREATEDB REPLICATION BYPASSRLS;

CREATE USER root WITH PASSWORD 'root';
GRANT ALL PRIVILEGES ON DATABASE nominatim to root;
ALTER USER root WITH SUPERUSER CREATEROLE CREATEDB REPLICATION BYPASSRLS;

CREATE USER "www-data" WITH PASSWORD 'www-data';
GRANT ALL PRIVILEGES ON DATABASE nominatim to "www-data";
ALTER USER "www-data" WITH SUPERUSER CREATEROLE CREATEDB REPLICATION BYPASSRLS;
\q

su ubuntu
```

#### Add postgresql extensions, including hstore, postgis

```
sudo -s -u nominatim
psql

CREATE EXTENSION hstore;
CREATE EXTENSION postgis;
\q
```

#### Restart the postgresql service

```
su ubuntu
sudo systemctl restart postgresql
```

### __2.3 Installing Nominatim__

```
cd $USERHOME
wget --no-check-certificate https://nominatim.org/release/Nominatim-3.2.0.tar.bz2
tar xf Nominatim-3.2.0.tar.bz2
cd Nominatim-3.2.0

mkdir build
cd build
cmake ..
make

sudo cp -r Nominatim-3.2.0 /srv/nominatim/
```

## __3. Restore _`Nominatim Database Backup File`___

### __3.1 Download _[pgAdmin](https://www.pgadmin.org/download/)_ client__

### __3.2 Remote access postgreSQL Database by pgAdmin client__

### __3.3 Select _`nominatim`_ database and restore `Backup File`__