Добавление данных osm2psql, не работает...

SPb_maps
Интересующийся
Сообщения: 25
Зарегистрирован: 26 фев 2016, 23:55
Репутация: 0

Re: Добавление данных osm2psql, не работает...

Сообщение SPb_maps » 02 мар 2016, 22:08

Спойлер
osm@osm-server:~/Downloads$ sudo -u osm osm2pgsql -r pbf -sa -d gis_test -C 40000 --number-processes 32 --cache-strategy dense /home/osm/Downloads/italy-latest.osm.pbf
osm2pgsql SVN version 0.81.0 (64bit id space)

Using projection SRS 900913 (Spherical Mercator)
Setting up table: planet_osm_point
NOTICE: table "planet_osm_point_tmp" does not exist, skipping
Setting up table: planet_osm_line
NOTICE: table "planet_osm_line_tmp" does not exist, skipping
Setting up table: planet_osm_polygon
NOTICE: table "planet_osm_polygon_tmp" does not exist, skipping
Setting up table: planet_osm_roads
NOTICE: table "planet_osm_roads_tmp" does not exist, skipping
Allocating memory for dense node cache
Allocating dense node cache in one big chunk
Node-cache: cache=40000MB, maxblocks=5120001*8192, allocation method=10
Mid: pgsql, scale=100 cache=40000
Setting up table: planet_osm_nodes
Setting up table: planet_osm_ways
Setting up table: planet_osm_rels

Reading in file: /home/osm/Downloads/italy-latest.osm.pbf
Processing: Node(125312k 86.4k/s) Way(13623k 21.90k/s) Relation(198920 739.48/s) parse time: 2342s

Node stats: total(125312731), max(4035381835) in 1451s
Way stats: total(13623250), max(401073119) in 622s
Relation stats: total(198924), max(6019061) in 269s
Committing transaction for planet_osm_point
Committing transaction for planet_osm_line
Committing transaction for planet_osm_polygon
Committing transaction for planet_osm_roads
COPY_END for COPY planet_osm_rels FROM STDIN;
failed: ERROR: duplicate key value violates unique constraint "planet_osm_rels_pkey"
DETAIL: Key (id)=(20773) already exists.
CONTEXT: COPY planet_osm_rels, line 96: "20773 0 0 {2577920,2577917,2577915,2577919,2577916,2578318} {"r2578318","Sicily","r2577916","Italy",..."

Error occurred, cleaning up
Спойлер
osm@osm-server:~$ sudo -u osm osm2pgsql -r pbf -s -d gis_test2 -C 40000 --number-processes 32 --cache-strategy dense /home/osm/Downloads/italy-latest.osm.pbf
osm2pgsql SVN version 0.81.0 (64bit id space)

Using projection SRS 900913 (Spherical Mercator)
Setting up table: planet_osm_point
NOTICE: table "planet_osm_point" does not exist, skipping
NOTICE: table "planet_osm_point_tmp" does not exist, skipping
Setting up table: planet_osm_line
NOTICE: table "planet_osm_line" does not exist, skipping
NOTICE: table "planet_osm_line_tmp" does not exist, skipping
Setting up table: planet_osm_polygon
NOTICE: table "planet_osm_polygon" does not exist, skipping
NOTICE: table "planet_osm_polygon_tmp" does not exist, skipping
Setting up table: planet_osm_roads
NOTICE: table "planet_osm_roads" does not exist, skipping
NOTICE: table "planet_osm_roads_tmp" does not exist, skipping
Allocating memory for dense node cache
Allocating dense node cache in one big chunk
Node-cache: cache=40000MB, maxblocks=5120001*8192, allocation method=10
Mid: pgsql, scale=100 cache=40000
Setting up table: planet_osm_nodes
NOTICE: table "planet_osm_nodes" does not exist, skipping
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "planet_osm_nodes_pkey" for table "planet_osm_nodes"
Setting up table: planet_osm_ways
NOTICE: table "planet_osm_ways" does not exist, skipping
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "planet_osm_ways_pkey" for table "planet_osm_ways"
Setting up table: planet_osm_rels
NOTICE: table "planet_osm_rels" does not exist, skipping
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "planet_osm_rels_pkey" for table "planet_osm_rels"

Reading in file: /home/osm/Downloads/italy-latest.osm.pbf
Processing: Node(125312k 135.2k/s) Way(13623k 27.36k/s) Relation(198920 342.97/s) parse time: 2005s

Node stats: total(125312731), max(4035381835) in 927s
Way stats: total(13623250), max(401073119) in 498s
Relation stats: total(198924), max(6019061) in 580s
Committing transaction for planet_osm_point
Committing transaction for planet_osm_line
Committing transaction for planet_osm_polygon
Committing transaction for planet_osm_roads

Going over pending ways...
9740136 ways are pending

Using 32 helper-processes
processing way (0k) at 0.00k/s (done 0 of 32)Connection to database failed: FATAL: sorry, too many clients already

Error occurred, cleaning up
Connection to database failed: FATAL: sorry, too many clients already

Error occurred, cleaning up
Connection to database failed: FATAL: sorry, too many clients already

Error occurred, cleaning up
Connection to database failed: FATAL: sorry, too many clients already

Error occurred, cleaning up
Connection to database failed: FATAL: sorry, too many clients already

Error occurred, cleaning up
Connection to database failed: FATAL: sorry, too many clients already

Error occurred, cleaning up
Connection to database failed: FATAL: sorry, too many clients already

Error occurred, cleaning up
Connection to database failed: FATAL: sorry, too many clients already

Error occurred, cleaning up
Connection to database failed: FATAL: sorry, too many clients already

Error occurred, cleaning up
Connection to database failed: FATAL: sorry, too many clients already

Error occurred, cleaning up
processing way (0k) at 0.00k/s (done 0 of 32)COPY planet_osm_polygon (osm_id,"access","addr:housename","addr:housenumber","addr:interpolation","admin_level","aerialway","aeroway","amenity","area","barrier","bicycle","brand","bridge","boundary","building","construction","covered","culvert","cutting","denomination","disused","embankment","foot","generator:source","harbour","highway","historic","horse","intermittent","junction","landuse","layer","leisure","lock","man_made","military","motorcar","name","natural","oneway","operator","population","power","power_source","place","railway","ref","religion","route","service","shop","sport","surface","toll","tourism","tower:type","tracktype","tunnel","water","waterway","wetland","width","wood","z_order","way_area",way) FROM STDIN failed: server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.

Error occurred, cleaning up
Connection to database failed: FATAL: sorry, too many clients already

Error occurred, cleaning up
osm@osm-server:~$ Connection to database failed: FATAL: sorry, too many clients already

Error occurred, cleaning up
Process 8 finished processing 304379 ways in 1795 sec
Process 10 finished processing 304379 ways in 1796 sec
Process 9 finished processing 304379 ways in 1796 sec
Process 14 finished processing 304379 ways in 1796 sec
Process 12 finished processing 304379 ways in 1797 sec
Process 5 finished processing 304380 ways in 1797 sec
Process 7 finished processing 304380 ways in 1797 sec
Process 15 finished processing 304379 ways in 1797 sec
Process 17 finished processing 304379 ways in 1798 sec
Process 18 finished processing 304379 ways in 1798 sec
Process 6 finished processing 304380 ways in 1800 sec
Process 19 finished processing 304379 ways in 1800 sec
Process 16 finished processing 304379 ways in 1801 sec
Process 13 finished processing 304379 ways in 1801 sec
Process 11 finished processing 304379 ways in 1801 sec
Process 3 finished processing 304380 ways in 1801 sec
Process 4 finished processing 304380 ways in 1801 sec
Process 1 finished processing 304380 ways in 1803 sec
Process 2 finished processing 304380 ways in 1803 sec
Спойлер
osm@osm-server:~$ sudo -u osm osm2pgsql -r pbf -s -d gis_test2 -C 40000 --number-processes 32 --cache-strategy dense /home/osm/Downloads/estonia-latest.osm.pbf
osm2pgsql SVN version 0.81.0 (64bit id space)

Using projection SRS 900913 (Spherical Mercator)
Setting up table: planet_osm_point
NOTICE: table "planet_osm_point" does not exist, skipping
NOTICE: table "planet_osm_point_tmp" does not exist, skipping
Setting up table: planet_osm_line
NOTICE: table "planet_osm_line" does not exist, skipping
NOTICE: table "planet_osm_line_tmp" does not exist, skipping
Setting up table: planet_osm_polygon
NOTICE: table "planet_osm_polygon" does not exist, skipping
NOTICE: table "planet_osm_polygon_tmp" does not exist, skipping
Setting up table: planet_osm_roads
NOTICE: table "planet_osm_roads" does not exist, skipping
NOTICE: table "planet_osm_roads_tmp" does not exist, skipping
Allocating memory for dense node cache
Allocating dense node cache in one big chunk
Node-cache: cache=40000MB, maxblocks=5120001*8192, allocation method=10
Mid: pgsql, scale=100 cache=40000
Setting up table: planet_osm_nodes
NOTICE: table "planet_osm_nodes" does not exist, skipping
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "planet_osm_nodes_pkey" for table "planet_osm_nodes"
Setting up table: planet_osm_ways
NOTICE: table "planet_osm_ways" does not exist, skipping
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "planet_osm_ways_pkey" for table "planet_osm_ways"
Setting up table: planet_osm_rels
NOTICE: table "planet_osm_rels" does not exist, skipping
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "planet_osm_rels_pkey" for table "planet_osm_rels"

Reading in file: /home/osm/Downloads/estonia-latest.osm.pbf
Processing: Node(8174k 160.3k/s) Way(927k 28.11k/s) Relation(12030 152.28/s) parse time: 163s

Node stats: total(8174001), max(4023588356) in 51s
Way stats: total(927736), max(399632014) in 33s
Relation stats: total(12039), max(5999405) in 79s
Committing transaction for planet_osm_point
Committing transaction for planet_osm_line
Committing transaction for planet_osm_polygon
Committing transaction for planet_osm_roads

Going over pending ways...
759327 ways are pending

Using 32 helper-processes
processing way (0k) at 0.00k/s (done 0 of 32)Connection to database failed: FATAL: sorry, too many clients already

Connection to database failed: FATAL: sorry, too many clients already

Error occurred, cleaning up
Error occurred, cleaning up
Connection to database failed: FATAL: sorry, too many clients already

Error occurred, cleaning up
Connection to database failed: FATAL: sorry, too many clients already

Error occurred, cleaning up
processing way (0k) at 0.00k/s (done 0 of 32)Connection to database failed: FATAL: sorry, too many clients already

Error occurred, cleaning up
Connection to database failed: FATAL: sorry, too many clients already

Error occurred, cleaning up
processing way (0k) at 0.01k/s (done 0 of 32)Connection to database failed: FATAL: sorry, too many clients already

Error occurred, cleaning up
processing way (0k) at 0.01k/s (done 0 of 32)Connection to database failed: FATAL: sorry, too many clients already

Error occurred, cleaning up
processing way (0k) at 0.01k/s (done 0 of 32)Connection to database failed: FATAL: sorry, too many clients already

Error occurred, cleaning up
Connection to database failed: FATAL: sorry, too many clients already

processing way (0k) at 0.01k/s (done 0 of 32)Error occurred, cleaning up
processing way (0k) at 0.01k/s (done 0 of 32)Connection to database failed: FATAL: sorry, too many clients already

Error occurred, cleaning up
processing way (39k) at 11.01k/s (done 0 of 32)planet_osm_roads - bad result during COPY, data LINESTRING (2667654.6299999998882413 8126713.5800000000745058, 2667630.7400000002235174 8126745.7699999995529652, 2667607.1699999999254942 8126770.6399999996647239, 2667587.4399999999441206 8126788.1500000003725290, 2667563.5600000000558794 8126805.0400000000372529, 2667525.9900000002235174 8126826.7099999999627471, 2667473.1200000001117587 8126851.5400000000372529, 2667420.2900000000372529 8126870.3200000002980232, 2667385.8900000001303852 8126881.7999999998137355, 2667365.2200000002048910 8126886.8899999996647239, 2667336.5699999998323619 8126890.6799999997019768, 2667317.1600000001490116 8126891.9500000001862645, 2667285.9599999999627471 8126896.0899999998509884, 2667249.6699999999254942 8126907.5300000002607703, 2667196.8300000000745058 8126920.8799999998882413, 2667151.9399999999441206 8126928.1900000004097819, 2667122.9799999999813735 8126931.3700000001117587, 2667089.8799999998882413 8126931.3700000001117587, 2667058.6899999999441206 8126928.1500000003725290, 2667025.5699999998323619 8126921.7400000002235174, 2667002.6699999999254942 8126913.4500000001862645, 2666955.2599999997764826 8126898.1100000003352761, 2666885.8900000001303852 8126870.9599999999627471, 2666866.1600000001490116 8126865.8600000003352761, 2666832.1099999998696148 8126859.4599999999627471, 2666767.8199999998323619 8126851.1100000003352761, 2666745.8599999998696148 8126850.1500000003725290, 2666729.3100000000558794 8126850.1299999998882413, 2666680.2799999997951090 8126851.3700000001117587, 2666626.4900000002235174 8126855.4900000002235174, 2666570.4799999999813735 8126858.3200000002980232, 2666532.9199999999254942 8126858.2800000002607703, 2666495.6800000001676381 8126856.3499999996274710, 2666463.5299999997951090 8126853.1299999998882413, 2666434.5800000000745058 8126848.0199999995529652, 2666405.6099999998696148 8126839.7000000001862645, 2666371.2599999997764826 8126827.2500000000000000, 2666335.9399999999441206 8126818.9199999999254942, 2666311.1099999998696148 8126815.7300000004470348, 2666273.8700000001117587 8126812.5099999997764826, 2666240.4599999999627471 8126811.5400000000372529, 2666201.3100000000558794 8126816.6100000003352761, 2666175.2000000001862645 8126820.7300000004470348, 2666148.4799999999813735 8126822.6200000001117587, 2666117.2799999997951090 8126822.5899999998509884, 2666031.3300000000745058 8126820.6200000001117587, 2665916.7599999997764826 8126810.9599999999627471, 2665854.7099999999627471 8126807.7400000002235174, 2665796.4599999999627471 8126808.9699999997392297, 2665721.0099999997764826 8126818.1500000003725290, 2665687.6000000000931323 8126826.4100000001490116, 2665650.3300000000745058 8126838.8200000002980232, 2665619.1400000001303852 8126848.3499999996274710, 2665591.1200000001117587 8126859.4800000004470348, 2665570.4300000001676381 8126871.9100000001490116, 2665548.7799999997951090 8126886.5599999995902181, 2665525.8399999998509884 8126901.2199999997392297, 2665501.9700000002048910 8126917.7699999995529652, 2665483.4900000002235174 8126927.9599999999627471, 2665459.6000000000931323 8126937.5099999997764826, 2665431.5899999998509884 8126941.6299999998882413, 2665412.8199999998323619 8126943.5400000000372529, 2665327.8399999998509884 8126948.2400000002235174, 2665280.7200000002048910 8126948.2000000001862645, 2665230.7599999997764826 8126946.8899999996647239, 2665182.3799999998882413 8126943.6500000003725290, 2665117.1200000001117587 8126937.5300000002607703, 2665079.2599999997764826 8126929.8499999996274710, 2665039.7900000000372529 8126919.2900000000372529, 2665001.9399999999441206 8126905.5599999995902181, 2664968.5299999997951090 8126891.7999999998137355, 2664944.3399999998509884 8126881.2599999997764826, 2664926.2200000002048910 8126871.9900000002235174, 2664898.8599999998696148 8126859.8499999996274710, 2664874.6800000001676381 8126850.5800000000745058, 2664847.2999999998137355 8126844.5000000000000000, 2664811.0299999997951090 8126844.4800000004470348, 2664744.5000000000000000 8126852.0599999995902181, 2664703.4399999999441206 8126858.0700000002980232, 2664638.1699999999254942 8126880.9800000004470348, 2664588.1699999999254942 8126900.7099999999627471, 2664548.6899999999441206 8126917.2500000000000000, 2664510.7999999998137355 8126935.3799999998882413, 2664483.3999999999068677 8126950.6600000001490116, 2664394.8599999998696148 8127010.8600000003352761, 2664369.0800000000745058 8127028.9900000002235174, 2664343.2599999997764826 8127045.5599999995902181, 2664321.9300000001676381 8127054.7599999997764826, 2664291.6899999999441206 8127070.0400000000372529, 2664265.8799999998882413 8127076.0700000002980232, 2664236.9199999999254942 8127077.3399999998509884, 2664209.8799999998882413 8127077.3200000002980232, 2664150.6800000001676381 8127068.2999999998137355, 2664126.4900000002235174 8127062.2300000004470348, 2664093.0899999998509884 8127052.9599999999627471, 2664065.7200000002048910 8127039.2000000001862645, 2664052.3599999998696148 8127030.2800000002607703, 2664041.5499999998137355 8127019.4199999999254942, 2664026.6099999998696148 8127008.8799999998882413, 2664015.7900000000372529 8127004.4000000003725290, 2663965.1899999999441206 8126995.1100000003352761, 2663924.1299999998882413 8126989.0099999997764826, 2663880.2200000002048910 8126984.4800000004470348, 2663852.8399999998509884 8126982.8700000001117587, 2663827.0600000000558794 8126979.9800000004470348, 2663795.2400000002235174 8126981.2000000001862645, 2663763.3999999999068677 8126985.9599999999627471, 2663745.2700000000186265 8126990.4100000001490116, 2663727.1200000001117587 8126998.0499999998137355, 2663699.7099999999627471 8127011.7199999997392297, 2663666.6099999998696148 8127026.6699999999254942, 2663639.2200000002048910 8127040.3600000003352761, 2663604.1899999999441206 8127054.0099999997764826, 2663577.1200000001117587 8127063.2400000002235174, 2663545.2799999997951090 8127070.5400000000372529, 2663455.8399999998509884 8127090.2099999999627471, 2663417.9399999999441206 8127099.4199999999254942, 2663324.6600000001490116 8127123.5599999995902181, 2663230.7400000002235174 8127150.8600000003352761, 2663206.2099999999627471 8127155.2999999998137355, 2663175.9700000002048910 8127159.7400000002235174, 2663109.4399999999441206 8127162.8600000003352761, 2663076.0099999997764826 8127167.2800000002607703, 2663036.5499999998137355 8127171.7000000001862645, 2663007.8900000001303852 8127177.7300000004470348, 2662971.2700000000186265 8127186.9299999997019768, 2662956.6299999998882413 8127192.0199999995529652, 2662875.7599999997764826 8127209.7699999995529652, 2662808.2700000000186265 8127212.5800000000745058, 2662766.5600000000558794 8127227.1699999999254942, 2662713.6899999999441206 8127262.5199999995529652, 2662671.0000000000000000 8127292.1100000003352761, 2662635.0099999997764826 8127313.1200000001117587, 2662609.5400000000372529 8127318.1900000004097819, 2662564.9799999999813735 8127318.1200000001117587, 2662492.0899999998509884 8127314.2199999997392297, 2662386.0899999998509884 8127306.7500000000000000, 2662235.5600000000558794 8127292.5400000000372529, 2662129.2400000002235174 8127297.1799999997019768, 2661950.6400000001303852 8127319.5800000000745058, 2661910.5200000000186265 8127329.4299999997019768, 2661861.4599999999627471 8127354.2400000002235174, 2661799.9700000002048910 8127410.9199999999254942, 2661715.8300000000745058 8127486.3899999996647239, 2661613.1899999999441206 8127608.3600000003352761, 2661562.4799999999813735 8127670.1699999999254942, 2661495.8599999998696148 8127741.8300000000745058, 2661463.6099999998696148 8127805.5700000002980232, 2661443.1600000001490116 8127861.9900000002235174, 2661366.5600000000558794 8128014.6299999998882413, 2661319.8999999999068677 8128145.6399999996647239, 2661284.7900000000372529 8128209.0599999995902181, 2661265.6600000001490116 8128235.8300000000745058, 2661256.8900000001303852 8128248.0000000000000000)
Error occurred, cleaning up
Process 14 finished processing 23729 ways in 33 sec
Process 20 finished processing 23729 ways in 33 sec
Process 22 finished processing 23729 ways in 33 sec
Process 13 finished processing 23729 ways in 33 sec
Process 7 finished processing 23729 ways in 33 sec
Process 11 finished processing 23729 ways in 33 sec
Process 16 finished processing 23729 ways in 33 sec
Process 4 finished processing 23729 ways in 33 sec
Process 24 finished processing 23729 ways in 33 sec
Process 1 finished processing 23729 ways in 33 sec
Process 5 finished processing 23729 ways in 33 sec
Process 27 finished processing 23729 ways in 33 sec
Process 26 finished processing 23729 ways in 33 sec
Process 3 finished processing 23729 ways in 33 sec
Process 2 finished processing 23729 ways in 33 sec
Process 15 finished processing 23729 ways in 33 sec
Process 6 finished processing 23729 ways in 33 sec
Process 18 finished processing 23729 ways in 33 sec
Process 8 finished processing 23729 ways in 33 sec
Process 17 finished processing 23729 ways in 33 sec

Error occurred, cleaning up и processing way (0k) at 0.01k/s (done 0 of 32)Connection to database failed: FATAL: sorry, too many clients already - преследуют меня и мне никак от них не избавится..

SPb_maps
Интересующийся
Сообщения: 25
Зарегистрирован: 26 фев 2016, 23:55
Репутация: 0

Re: Добавление данных osm2psql, не работает...

Сообщение SPb_maps » 03 мар 2016, 01:10

Попробовал не указывать количество процессоров(32) и вроде прошло без ошибок, добавляю второй файл карты :) с утра будет видно как загрузилось
а также я не делал legacy.sql - так и не понял его нужно выполнять до или после загрузки карты, сплошные эксперементы

SPb_maps
Интересующийся
Сообщения: 25
Зарегистрирован: 26 фев 2016, 23:55
Репутация: 0

Re: Добавление данных osm2psql, не работает...

Сообщение SPb_maps » 13 сен 2016, 14:58

Проблема не решается никак, карта успешно загружается в БД, но отображается не целиком, часть тайлов не грузится, приходит 404... I NEED HELP :roll:

d1g
Интересующийся
Сообщения: 21
Зарегистрирован: 10 май 2016, 19:42
Репутация: 3

Re: Добавление данных osm2psql, не работает...

Сообщение d1g » 18 сен 2016, 23:39

SPb_maps писал(а):Я пробовал его увеличить, стоит 100 - как по умолчанию, немного меняю и postgresql уже не перезагуржается, погуглил - проблема частая, буду читать.. у меня мощный комп, я вроде все остальные настройки подтянул, стало быстрее, но именно с этой вышла заминка..
Прямо в конфиге там был жирный комментарий на тему памяти.
# Note: Increasing max_connections costs ~400 bytes of shared memory per
# connection slot, plus lock space (see max_locks_per_transaction). You might
# also need to raise shared_buffers to support more connections.
http://dba.stackexchange.com/questions/ ... 479#140479
https://www.postgresql.org/docs/current ... ource.html
https://wiki.postgresql.org/wiki/Tuning ... SQL_Server
http://pgtune.leopard.in.ua/ - обратите внимание что вам скажут когда вы выберете PostgreSQL 9.1

Играйтесь с настройками согласно докам, покажите потом до и после вот это:

Код: Выделить всё

SHOW all
Последний раз редактировалось d1g 19 сен 2016, 06:57, всего редактировалось 1 раз.

d1g
Интересующийся
Сообщения: 21
Зарегистрирован: 10 май 2016, 19:42
Репутация: 3

Re: Добавление данных osm2psql, не работает...

Сообщение d1g » 18 сен 2016, 23:56

Читаем https://github.com/openstreetmap/osm2pgsql#usage
When importing a large amount of data such as the complete planet, a typical command line would be

osm2pgsql -c -d gis --slim -C <cache size> \
--flat-nodes <flat nodes> planet-latest.osm.pbf

where

<cache size> is about 75% of memory in MiB, to a maximum of about 30000. Additional RAM will not be used.
<flat nodes> is a location where a 24GiB file can be saved.
https://github.com/openstreetmap/osm2pg ... erformance
--number-processes sets the number of processes to use. This should typically be set to the number of CPU threads, but gains in speed are minimal past 8 threads.

Ответить

Вернуться в «PostGIS/PostgreSQL»

Кто сейчас на конференции

Сейчас этот форум просматривают: нет зарегистрированных пользователей и 4 гостя