X-Git-Url: https://git.openstreetmap.org./rails.git/blobdiff_plain/c0278a01da05d8af7c4aec9eeab37a47f1d3110f..6663e23d43b93c442c48bdcd9ae890ecd375957b:/INSTALL.md?ds=inline diff --git a/INSTALL.md b/INSTALL.md index b14a2d32b..6815bab1f 100644 --- a/INSTALL.md +++ b/INSTALL.md @@ -188,22 +188,6 @@ To create the three databases - for development, testing and production - run: bundle exec rake db:create ``` -### PostgreSQL Btree-gist Extension - -We need to load the `btree-gist` extension, which is needed for showing changesets on the history tab. - -``` -psql -d openstreetmap -c "CREATE EXTENSION btree_gist" -``` - -### PostgreSQL Functions - -We need to install some special functions into the PostgreSQL database: - -``` -psql -d openstreetmap -f db/functions/functions.sql -``` - ### Database structure To create all the tables, indexes and constraints, run: @@ -240,44 +224,6 @@ Note that the OSM map tiles you see aren't created from your local database - th After installing this software, you may need to carry out some [configuration steps](CONFIGURE.md), depending on your tasks. -# Installing compiled shared library database functions (optional) - -There are special database functions required by a (little-used) API call, the migrations and diff replication. The former two are provided as *either* pure SQL functions or a compiled shared library. The SQL versions are installed as part of the recommended install procedure above and the shared library versions are recommended only if you are running a production server and need the diff replication functionality. - -If you aren't sure which you need, stick with the SQL versions. - -Before installing the functions, it's necessary to install the PostgreSQL server development packages. On Ubuntu this means: - -``` -sudo apt-get install postgresql-server-dev-all -``` - -On Fedora: - -``` -sudo dnf install postgresql-devel -``` - -The library then needs compiling. - -``` -cd db/functions -make libpgosm.so -cd ../.. -``` - -If you previously installed the SQL versions of these functions, we'll need to delete those before adding the new ones: - -``` -psql -d openstreetmap -c "DROP FUNCTION IF EXISTS tile_for_point" -``` - -Then we create the functions within each database. We're using `pwd` to substitute in the current working directory, since PostgreSQL needs the full path. - -``` -psql -d openstreetmap -c "CREATE FUNCTION tile_for_point(int4, int4) RETURNS int8 AS '`pwd`/db/functions/libpgosm', 'tile_for_point' LANGUAGE C STRICT" -``` - # Ruby development install and versions (optional) For simplicity, this document explains how to install all the website dependencies as "system" dependencies. While this is simpler, and usually faster, you might want more control over the process or the ability to install multiple different versions of software alongside eachother. For many developers, [`rbenv`](https://github.com/rbenv/rbenv) is the easiest way to manage multiple different Ruby versions on the same computer - with the added advantage that the installs are all in your home directory, so you don't need administrator permissions.