{"id":1681,"date":"2015-07-09T15:12:56","date_gmt":"2015-07-09T12:12:56","guid":{"rendered":"http:\/\/journal.gendar.ru\/?p=1681"},"modified":"2015-07-09T15:12:56","modified_gmt":"2015-07-09T12:12:56","slug":"1c-suse","status":"publish","type":"post","link":"https:\/\/journal.gendar.ru\/?p=1681","title":{"rendered":"1c suse"},"content":{"rendered":"<p><!--more--><\/p>\n<div>\u0418\u0442\u0430\u043a \u0441\u043d\u0430\u0447\u0430\u043b\u0430 \u0441\u0442\u0430\u043c\u0438\u043c \u043f\u043e\u0441\u0442\u0433\u0440\u0435\u0441 1\u0441\u043e\u0432\u0441\u043a\u0438\u0439, \u0431\u0435\u0440\u0435\u043c \u0443\u0436\u0435 \u0441\u043a\u043e\u043c\u043f\u0438\u043b\u0435\u043d\u044b\u0439 \u043f\u043e\u0434 1\u0441 \u043d\u0435 \u0441\u0441\u0430\u0439\u0442\u0430 1\u0441\u043a\u0438 \u0430 \u043e\u0442\u0441\u044e\u0434\u0430 <a href=\"https:\/\/build.opensuse.org\/project\/show?project=home%3Aghostlyrat%3A1c_PostgreSQL\" target=\"_blank\">https:\/\/build.opensuse.org\/<wbr \/>project\/show?project=home%<wbr \/>3Aghostlyrat%3A1c_PostgreSQL<\/a><\/div>\n<div>\u0442\u0430\u043a\u0436\u0435 \u043d\u0430\u043c \u043f\u043e\u043d\u0430\u0434\u043e\u0431\u0438\u0442\u044c\u0441\u044f libossp-uuid16-1.6.2-18.1.3.<wbr \/>x86_64 \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u0441\u043f\u043e\u043a\u043e\u0439\u043d\u043e \u0433\u0443\u0433\u043b\u0438\u0442\u044c\u0441\u044f \u0434\u043b\u044f suse \u0441\u043e\u043e\u0442\u0432\u0435\u0442\u0441\u0442\u0432\u0443\u044e\u0449\u0435\u0439 \u0432\u0435\u0440\u0441\u0438\u0438<\/div>\n<div>\u00a0\u0441\u0442\u0430\u0432\u0438\u043c \u0432 \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0435\u043c \u043f\u043e\u0440\u044f\u0434\u043a\u0435 (rpm -ivh)\u00a0 (\u043c\u043e\u0436\u0435\u0442 \u0438 \u0431\u0435\u0437 \u044d\u0442\u043e\u0433\u043e \u043f\u0440\u043e\u043a\u0430\u043d\u0430\u0442\u044c, \u043d\u043e \u0445\u0437)<br \/>\npostgresql92-libs-9.2.1-1.1C.<wbr \/>x86_64.rpm<br \/>\npostgresql92-9.2.1-1.1C.x86_<wbr \/>64.rpm<br \/>\npostgresql92-server-9.2.1-1.<wbr \/>1C.x86_64.rpm<br \/>\npostgresql92-contrib-9.2.1-1.<wbr \/>1C.x86_64.rpm<\/div>\n<p>\u043f\u043e\u0441\u0442\u0430\u0432\u0438\u043b\u0438 \u043c\u043e\u043b\u043e\u0434\u0446\u044b, \u0432\u0440\u0435\u043c\u0435\u043d\u043e \u0437\u0430\u0431\u044b\u043b\u0438 \u043f\u0440\u043e \u043f\u043e\u0441\u0442\u0433\u0440\u0435\u0441\u0441, \u043d\u0430\u0447\u0438\u043d\u0430\u0435\u043c \u0433\u0435\u043c\u043e\u0440\u0438\u0442\u044c\u0441\u044f \u0441 1\u0441<\/p>\n<p>\u0434\u0430\u043b\u0435\u0435 \u0441\u0442\u0430\u0432\u0438\u043c \u0441\u0435\u0440\u0432\u0435\u0440 1\u0441, \u0435\u0433\u043e \u0431\u0435\u0440\u0435\u043c \u0441 \u0441\u0430\u0439\u0442\u0430 1\u0441<\/p>\n<p>\u043d\u0430\u043c \u043d\u0443\u0436\u043d\u044b \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0438\u0435 \u0444\u0430\u0439\u043b\u044b &#8212;<br \/>\n1C_Enterprise83-common.x86_64 0:8.3.3-658.rpm<br \/>\n1C_Enterprise83-common-nls.<wbr \/>x86_64 0:8.3.3-658.rpm<br \/>\n1C_Enterprise83-server.x86_64 0:8.3.3-658.rpm<br \/>\n1C_Enterprise83-server-nls.<wbr \/>x86_64 0:8.3.3-658.rpm<\/p>\n<p>\u0441\u0442\u0430\u0432\u044f\u0442\u044c\u0441\u044f \u0432 \u0442\u0430\u043a\u043e\u043c \u043f\u043e\u0440\u044f\u0434\u043a\u0435 (\u0438\u043b\u0438 \u0431\u0430\u043b\u043a\u043e\u043c, \u043d\u043e \u044f \u0434\u0435\u043b\u0430\u043b \u043a\u0430\u043a \u0432 \u0436\u0435\u043b\u0442\u043e\u0439 \u043a\u043d\u0438\u0436\u0435\u0447\u043a\u0435 \u043d\u0430\u043f\u0438\u0441\u0430\u043b\u0438;) )<\/p>\n<div>\u0434\u0430\u043b\u0435\u0435 \u0438\u0434\u0435\u043c \u0432 \/var\/lib\/pgsql\/data \u043e\u0442\u043a\u0440\u044b\u0432\u0430\u0435\u043c \u0444\u0430\u0439\u043b\u0438\u043a pg_hba.conf<\/div>\n<div>\n<p>\u043c\u0435\u043d\u044f\u0435\u043c \u0441\u0442\u0440\u043e\u0447\u043a\u0438 \u043d\u0430<\/p>\n<p>local all postgres ident (\u0438\u043b\u0438 trust \u0435\u0441\u043b\u0438 \u0441 ident-\u043e\u043c \u043d\u0435 \u0441\u0440\u0430\u0431\u043e\u0442\u0430\u0435\u0442<br \/>\nhost all postgres <a href=\"http:\/\/127.0.0.1\/32\" target=\"_blank\">127.0.0.1\/32<\/a> trust<\/p>\n<\/div>\n<div>\u043e\u0441\u0442\u0430\u043b\u044c\u043d\u044b\u0435 \u043c\u043e\u0436\u043d\u043e \u043f\u043e\u043a\u0430 \u0437\u0430\u043a\u043e\u043c\u0435\u043d\u0442\u0438\u0442\u044c.<\/div>\n<p>\u0434\u0430\u043b\u0435\u0435 \u0437\u0430\u043f\u0443\u0441\u043a\u0430\u0435\u043c \u043f\u043e\u0441\u0442\u0433\u0440\u0435\u0441 \u043a\u043e\u043c\u0430\u043d\u0434\u043e\u0439 LANG=ru.RU.utf-8 \/<span class=\"il\">etc<\/span>\/init.d\/postgresql start \u0447\u0442\u043e \u0431\u044b \u0441\u0440\u0430\u0437\u0443 \u0437\u0430\u0434\u0430\u0442\u044c \u0435\u043c\u0443 \u0440\u0443\u0441\u043a\u0438\u0439 \u0438 \u044e\u0442\u0444 8 (\u0435\u0441\u043b\u0438 \u043d\u0430\u0434\u043e \u0441\u0442\u0430\u0432\u0438\u043c \u0432 \u0441\u043e\u043e\u0442\u0432\u0435\u0442\u0441\u0432\u0443\u044e\u0449\u0438\u0439 \u0438\u043d\u0438\u0442)<\/p>\n<p>\u0437\u0430\u043f\u0443\u0441\u043a\u0430\u0435\u043c 1\u0441 \u0441\u0435\u0440\u0432\u0435\u0440, \u043e\u043d \u043c\u043e\u0436\u0435\u0442 \u043d\u0430\u043f\u0438\u0441\u0430\u0442\u044c \u0447\u0442\u043e \u0444\u0435\u0439\u043b, \u043d\u043e \u043d\u0430 \u0441\u0430\u043c\u043e\u043c \u0434\u0435\u043b\u0435 \u043c\u043e\u0436\u0435\u0442 \u0437\u0430\u043f\u0443\u0441\u0442\u0438\u0442\u044c\u0441\u044f, \u043d\u0430 \u0441\u0430\u043c\u043e\u043c \u0434\u0435\u043b\u0435 \u043d\u0443\u0436\u0435\u043d \u0442\u043e\u043b\u044c\u043a\u043e ragent, \u043d\u0430 \u0432\u0441\u0435 \u043e\u0441\u0442\u0430\u043b\u044c\u043d\u043e\u0435 \u043c\u043e\u0436\u043d\u043e \u043f\u043e\u043b\u043e\u0436\u0438\u0442\u044c \u0431\u043e\u043b\u0442.<\/p>\n<p>\u0417\u0430\u0445\u043e\u0434\u0438\u043c \u0432 \u043f\u043e\u0441\u0442\u0433\u0440\u0435\u0441 \u043d\u0430\u043f\u0440\u0438\u043c\u0435\u0440 (sudo -u postgres psql -p 5432 -h localhost) \u0438 \u043c\u0435\u043d\u044f\u0435\u043c \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044e postgres \u043a\u043e\u043c\u0430\u043d\u0434\u043e\u0439 &#8212;<\/p>\n<p>ALTER USER postgres WITH PASSWORD &#8216;1234&#8217;;<\/p>\n<p>\u0432\u044b\u0445\u043e\u0434\u0438\u043c \u043e\u0442\u0442\u0443\u0434\u0430 (\\q).<\/p>\n<p><!--more--><\/p>\n<p>\u0438\u0434\u0435\u043c \u0441\u043d\u043e\u0432\u0430 \u0432 \u0432 \/var\/lib\/pgsql\/data \u043e\u0442\u043a\u0440\u044b\u0432\u0430\u0435\u043c \u0444\u0430\u0439\u043b\u0438\u043a pg_hba.conf \u0438 \u0434\u043e\u0431\u0430\u0432\u043b\u044f\u0435\u043c \u0442\u0430\u043c host all all <a href=\"http:\/\/192.168.1.0\/24\" target=\"_blank\">192.168.1.0\/24<\/a> md5 \u043a\u0430\u043a \u043f\u043e\u0441\u043b\u0435\u0434\u043d\u0438\u044e \u0441\u0442\u0440\u043e\u0447\u043a\u0443 \u043f\u043e\u0442\u043e\u043c \u0440\u0435\u0441\u0442\u0430\u0440\u0442\u0443\u0435\u043c \u043f\u043e\u0441\u0442\u0433\u0440\u0435\u0441 \u0438 \u0443\u0436\u0435 \u043c\u043e\u0436\u0435\u043c \u043f\u044b\u0442\u0430\u0442\u044c\u0441\u044f \u043a\u043e\u043d\u0435\u043a\u0442\u0438\u0442\u044c\u0441\u044f \u043a \u0441\u0435\u0440\u0432\u0430\u043a\u0443 \u0447\u0435\u0440\u0435\u0437 \u043a\u043e\u043d\u0441\u043e\u043b\u044c \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f \u0441\u0435\u0440\u0432\u0430\u043c\u0438 1\u0441 (\u043a\u043e\u0442\u043e\u0440\u0430\u044f \u0442\u043e\u0436\u0435 \u0441 \u0438\u0445 \u0441\u0430\u0439\u0442\u0430 \u0441\u043a\u0430\u0447\u0438\u0432\u0430\u0435\u0442\u044c\u0441\u044f) .<\/p>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[9],"tags":[],"class_list":["post-1681","post","type-post","status-publish","format-standard","hentry","category-zamechaniya"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p8ebaf-r7","jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/journal.gendar.ru\/index.php?rest_route=\/wp\/v2\/posts\/1681","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/journal.gendar.ru\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/journal.gendar.ru\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/journal.gendar.ru\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/journal.gendar.ru\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1681"}],"version-history":[{"count":1,"href":"https:\/\/journal.gendar.ru\/index.php?rest_route=\/wp\/v2\/posts\/1681\/revisions"}],"predecessor-version":[{"id":1682,"href":"https:\/\/journal.gendar.ru\/index.php?rest_route=\/wp\/v2\/posts\/1681\/revisions\/1682"}],"wp:attachment":[{"href":"https:\/\/journal.gendar.ru\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1681"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/journal.gendar.ru\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1681"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/journal.gendar.ru\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1681"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}