createuser: error: creation of new role failed: ERROR: role "renderer" already exists

[06opoTeHb]

Hi. I tried run this project from start and always received the same error. Any suggestions why this can be? Thanks in advance. Log: docker-openstreetmap$ sudo docker system prune -a docker-openstreetmap$ sudo ./import.sh Creating docker volumes osm-data osm-tiles valhalla-data nominatim-data Importing data for tile server Unable to find image 'overv/openstreetmap-tile-server:latest' locally latest: Pulling from overv/openstreetmap-tile-server 2ab09b027e7f: Pull complete bde11ea69849: Pull complete 40e160805737: Pull complete f41c5ad11c98: Pull complete 97f4186ff19a: Pull complete 9655f23e0670: Pull complete 0eedff74b024: Pull complete 16b05075cf30: Pull complete b5ce7d269856: Pull complete 3f30db876d55: Pull complete 2f71bb5e820d: Pull complete b2caf47dca6f: Pull complete f98b089d4989: Pull complete e1c78a130923: Pull complete 4ffe18c9d9aa: Pull complete d387c64d8ca1: Pull complete a546b1960c43: Pull complete 8c42b7cf71bc: Pull complete 77ad13bf8c69: Pull complete 720ebe1774fb: Pull complete 3b353e6d6687: Pull complete 97ccc8f4d48f: Pull complete 3f579f6b6d85: Pull complete ccd55a53aeca: Pull complete Digest: sha256:59e9eefcefd961f30a3473287d4be56b737b645b9a1f7ad2d55f983b79e8c81d Status: Downloaded newer image for overv/openstreetmap-tile-server:latest ++ ls -A /data/style/

• '[' '!' '' ']'
• mv /home/renderer/src/openstreetmap-carto-backup/CARTOGRAPHY.md /home/renderer/src/openstreetmap-carto-backup/CHANGELOG.md /home/renderer/src/openstreetmap-carto-backup/CODE_OF_CONDUCT.md /home/renderer/src/openstreetmap-carto-backup/CONTRIBUTING.md /home/renderer/src/openstreetmap-carto-backup/DOCKER.md /home/renderer/src/openstreetmap-carto-backup/Dockerfile /home/renderer/src/openstreetmap-carto-backup/Dockerfile.db /home/renderer/src/openstreetmap-carto-backup/Dockerfile.import /home/renderer/src/openstreetmap-carto-backup/INSTALL.md /home/renderer/src/openstreetmap-carto-backup/LICENSE.txt /home/renderer/src/openstreetmap-carto-backup/README.md /home/renderer/src/openstreetmap-carto-backup/RELEASES.md /home/renderer/src/openstreetmap-carto-backup/USECASES.md /home/renderer/src/openstreetmap-carto-backup/docker-compose.yml /home/renderer/src/openstreetmap-carto-backup/external-data.yml /home/renderer/src/openstreetmap-carto-backup/indexes.sql /home/renderer/src/openstreetmap-carto-backup/indexes.yml /home/renderer/src/openstreetmap-carto-backup/openstreetmap-carto.lua /home/renderer/src/openstreetmap-carto-backup/openstreetmap-carto.style /home/renderer/src/openstreetmap-carto-backup/patterns /home/renderer/src/openstreetmap-carto-backup/preview.png /home/renderer/src/openstreetmap-carto-backup/project.mml /home/renderer/src/openstreetmap-carto-backup/road-colors.yaml /home/renderer/src/openstreetmap-carto-backup/scripts /home/renderer/src/openstreetmap-carto-backup/style /home/renderer/src/openstreetmap-carto-backup/symbols /data/style/
• '[' '!' -f /data/style/mapnik.xml ']'
• cd /data/style/
• carto project.mml
• '[' import == import ']'
• mkdir -p /data/database/postgres/
• chown renderer: /data/database/
• chown -R postgres: /var/lib/postgresql /data/database/postgres/
• '[' '!' -f /data/database/postgres/PG_VERSION ']'
• createPostgresConfig
• cp /etc/postgresql/15/main/postgresql.custom.conf.tmpl /etc/postgresql/15/main/conf.d/postgresql.custom.conf
• sudo -u postgres echo 'autovacuum = on'
• cat /etc/postgresql/15/main/conf.d/postgresql.custom.conf

  Suggested minimal settings from

  https://ircama.github.io/osm-carto-tutorials/tile-server-ubuntu/

shared_buffers = 128MB min_wal_size = 1GB

max_wal_size = 2GB # Overridden below

maintenance_work_mem = 256MB

Suggested settings from

https://github.com/openstreetmap/chef/blob/master/roles/tile.rb#L38-L45

max_connections = 250 temp_buffers = 32MB work_mem = 128MB wal_buffers = 1024kB wal_writer_delay = 500ms commit_delay = 10000

checkpoint_segments = 60 # unrecognized in psql 10.7.1

max_wal_size = 2880MB random_page_cost = 1.1 track_activity_query_size = 16384 autovacuum_vacuum_scale_factor = 0.05 autovacuum_analyze_scale_factor = 0.02

listen_addresses = '*' autovacuum = on

• service postgresql start
  • Starting PostgreSQL 15 database server ...done.
• sudo -u postgres createuser renderer createuser: error: creation of new role failed: ERROR: role "renderer" already exists

[wcedmisten]

Hello! Is your PBF file copied under ./osm-pbf and named region.osm.pbf? This issue seems to suggest the error occurs when the pbf can't be found: https://github.com/Overv/openstreetmap-tile-server/issues/12

Are there any other logs that might have warnings/errors in them?

[06opoTeHb]

Thanks a lot for so fast reply. Yes. PBF file copied under ./osm-pbf and named region.osm.pbf Maybe any suggestions?
user@home:/media/user/2TB/docker-openstreetmap$ cd ./osm-pbf user@home:/media/user/2TB/docker-openstreetmap/osm-pbf$ ls -la total 71958816 drwxrwxrwx 1 user user 0 May 2 06:30 . drwxrwxrwx 1 user user 4096 May 2 05:25 .. -rwxrwxrwx 1 user user 73685819550 May 2 03:18 region.osm.pbf

[wcedmisten]

Maybe try docker system prune --volumes also? docker system prune -a only removes images

[06opoTeHb]

Thanks a lot for new recommendation, but unfortunately result the same. Maybe you know where I can find this line? sudo -u postgres createuser renderer

[wcedmisten]

I believe that line is coming from this Dockerfile: https://github.com/Overv/openstreetmap-tile-server

You might want to try following the instructions in that repo with your pbf file and see if you get the same error.