{"id":1977,"date":"2017-10-03T07:23:21","date_gmt":"2017-10-03T03:53:21","guid":{"rendered":"http:\/\/webide.ir\/blog\/?p=1977"},"modified":"2017-10-02T09:23:58","modified_gmt":"2017-10-02T05:53:58","slug":"%da%86%da%af%d9%88%d9%86%d9%87-phppgadmin-%d8%b1%d8%a7-%d8%a8%d8%b1-%d8%b1%d9%88%db%8c-%d8%af%d8%a8%db%8c%d8%a7%d9%86-9%d8%8c-%d8%a7%d9%88%d8%a8%d9%88%d9%86%d8%aa%d9%88-16-04-%d8%8c-%d9%84%db%8c%d9%86","status":"publish","type":"post","link":"https:\/\/webide.ir\/blog\/%da%86%da%af%d9%88%d9%86%d9%87-phppgadmin-%d8%b1%d8%a7-%d8%a8%d8%b1-%d8%b1%d9%88%db%8c-%d8%af%d8%a8%db%8c%d8%a7%d9%86-9%d8%8c-%d8%a7%d9%88%d8%a8%d9%88%d9%86%d8%aa%d9%88-16-04-%d8%8c-%d9%84%db%8c%d9%86","title":{"rendered":"\u0686\u06af\u0648\u0646\u0647 PhpPgAdmin \u0631\u0627 \u0628\u0631 \u0631\u0648\u06cc \u062f\u0628\u06cc\u0627\u0646 9\u060c \u0627\u0648\u0628\u0648\u0646\u062a\u0648 16.04 \u060c \u0644\u06cc\u0646\u0648\u06a9\u0633 \u0645\u06cc\u0646\u062a 18 \u0646\u0635\u0628 \u06a9\u0646\u06cc\u0645\u061f"},"content":{"rendered":"<p>\u0647\u0645\u0627\u0646\u0637\u0648\u0631 \u06a9\u0647 \u0645\u06cc \u062f\u0627\u0646\u06cc\u062f PhpPgAdmin \u06cc\u06a9 \u0627\u0628\u0632\u0627\u0631 \u0645\u062f\u06cc\u0631\u06cc\u062a\u06cc \u0645\u0628\u062a\u0646\u06cc \u0628\u0631 \u0648\u0628 \u0628\u0631\u0627\u06cc \u0645\u062f\u06cc\u0631\u06cc\u062a \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 PostgreSQL \u0627\u0633\u062a \u06a9\u0647 \u0634\u0628\u0627\u0647\u062a \u0632\u06cc\u0627\u062f\u06cc \u0628\u0647 phpMyAdmin \u062f\u0627\u0631\u062f.\u00a0 \u0627\u06af\u0631 \u0642\u0628\u0644\u0627 \u0628\u0627 phpMyAdmin \u06a9\u0627\u0631 \u06a9\u0631\u062f\u0647\u00a0 \u0628\u0627\u0634\u06cc\u062f \u062f\u0631\u06a9 \u0639\u0645\u0644\u06a9\u0631\u062f phpPgAdmin \u0646\u06cc\u0632 \u0628\u0631\u0627\u06cc\u062a\u0627\u0646 \u0633\u0627\u062f\u0647 \u0648 \u0622\u0633\u0627\u0646 \u062e\u0648\u0627\u0647\u062f \u0628\u0648\u062f. \u062f\u0631 \u0627\u06cc\u0646 \u0645\u0642\u0627\u0644\u0647 \u0642\u0635\u062f \u062f\u0627\u0631\u06cc\u0645 \u0628\u0647 \u0646\u0635\u0628 \u0627\u06cc\u0646 \u0627\u0628\u0632\u0627\u0631 \u0645\u062f\u06cc\u0631\u06cc\u062a\u06cc \u0628\u067e\u0631\u062f\u0627\u0632\u06cc\u0645. \u067e\u0633 \u0647\u0645\u0631\u0627\u0647 \u0648\u0628 \u0627\u06cc\u062f\u0647 \u0628\u0627\u0634\u06cc\u062f.<\/p>\n<p><!--more--><\/p>\n<p>\u0646\u0635\u0628 PostgreSQL:<\/p>\n<p>\u0642\u0628\u0644 \u0627\u0632 \u0647\u0631 \u06a9\u0627\u0631\u06cc \u0628\u0627\u06cc\u062f \u0628\u0628\u06cc\u0646\u06cc\u0645 \u0633\u0631\u0648\u06cc\u0633 \u00a0PostgreSQL \u0628\u0631 \u0631\u0648\u06cc \u0633\u0631\u0648\u0631 \u06a9\u0627\u0631 \u0645\u06cc \u06a9\u0646\u062f \u06cc\u0627 \u062e\u06cc\u0631. \u0628\u0631\u0627\u06cc \u0627\u06cc\u0646\u06a9\u0627\u0631 \u062f\u0633\u062a\u0648\u0631 \u0632\u06cc\u0631 \u0631\u0627 \u0627\u062c\u0631\u0627 \u06a9\u0646\u06cc\u062f:<\/p>\n<p>&nbsp;<\/p>\n<p style=\"text-align: left;\">sudo systemctl status postgresql<\/p>\n<p><strong>\u062e\u0631\u0648\u062c\u06cc \u0627\u06cc\u0646 \u062f\u0633\u062a\u0648\u0631:<\/strong><\/p>\n<p style=\"text-align: left;\">postgresql.service &#8211; PostgreSQL RDBMS<\/p>\n<p style=\"text-align: left;\">\u00a0\u00a0 Loaded: loaded (\/lib\/systemd\/system\/postgresql.service; enabled; vendor preset: enabled)<\/p>\n<p style=\"text-align: left;\">\u00a0\u00a0 Active: active (exited) since Thu 2017-09-21 11:15:41 CDT; 2 days ago<\/p>\n<p style=\"text-align: left;\">\u00a0Main PID: 829 (code=exited, status=0\/SUCCESS)<\/p>\n<p style=\"text-align: left;\">\u00a0\u00a0\u00a0 Tasks: 0 (limit: 4915)<\/p>\n<p style=\"text-align: left;\">\u00a0\u00a0 CGroup: \/system.slice\/postgresql.service<\/p>\n<p>&nbsp;<\/p>\n<p style=\"text-align: left;\">Sep 21 11:15:41 mydebian systemd[1]: Starting PostgreSQL RDBMS&#8230;<\/p>\n<p style=\"text-align: left;\">Sep 21 11:15:41 mydebian systemd[1]: Started PostgreSQL RDBMS.<\/p>\n<p>\u0646\u0635\u0628 phpPgAdmin:<\/p>\n<p>\u0627\u06cc\u0646 \u0627\u0628\u0632\u0627\u0631 \u062f\u0631 \u0645\u062e\u0632\u0646 \u0627\u0635\u0644\u06cc \u062f\u0631 \u062f\u0633\u062a\u0631\u0633 \u0627\u0641\u0631\u0627\u062f \u0642\u0631\u0627\u0631 \u062f\u0627\u0631\u062f. \u0628\u0646\u0627\u0628\u0631\u0627\u06cc\u0646 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u0628\u0647 \u06a9\u0645\u06a9 \u062f\u0633\u062a\u0648\u0631 \u0632\u06cc\u0631 \u0622\u0646 \u0631\u0627 \u0646\u0635\u0628 \u06a9\u0646\u06cc\u062f:<\/p>\n<p style=\"text-align: left;\">sudo apt-get install -y\u00a0 phppgadmin apache2<\/p>\n<p>\u067e\u06cc\u06a9\u0631\u0628\u0646\u062f\u06cc PostgreSQL:<\/p>\n<p>\u0627\u06cc\u0646 \u06af\u0632\u06cc\u0646\u0647 \u062a\u0646\u0647\u0627 \u062f\u0631 loopback adapter(127.0.0.1) listen \u0645\u06cc \u06a9\u0646\u062f. \u0628\u0631\u062e\u06cc \u0627\u0632 \u0627\u0648\u0642\u0627\u062a\u060c \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u0646\u06cc\u0627\u0632 \u0628\u0647 \u0645\u062a\u0635\u0644 \u06a9\u0631\u062f\u0646 \u0627\u067e\u0644\u06cc\u06a9\u06cc\u0634\u0646 \u0628\u0647 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0628\u0627\u0634\u062f. \u00a0\u062f\u0631 \u0686\u0646\u06cc\u0646 \u0634\u0631\u0627\u06cc\u0637\u06cc \u0646\u06cc\u0627\u0632 \u062f\u0627\u0631\u06cc\u0645 PostgreSQL \u0631\u0627 \u0628\u0647 \u06af\u0648\u0646\u0647 \u0627\u06cc \u067e\u06cc\u06a9\u0631\u0628\u0646\u062f\u06cc \u06a9\u0646\u06cc\u0645 \u06a9\u0647 \u0628\u0631 \u0631\u0648\u06cc \u062a\u0645\u0627\u0645\u06cc \u0622\u062f\u0627\u067e\u062a\u0648\u0631\u0647\u0627 \u06af\u0648\u0634 \u06a9\u0646\u062f:<\/p>\n<p style=\"text-align: left;\">nano \/etc\/postgresql\/9.6\/main\/postgresql.conf<\/p>\n<p>\u062e\u0637 \u0632\u06cc\u0631 \u0631\u0627 \u067e\u06cc\u062f\u0627 \u06a9\u0646\u06cc\u062f:<\/p>\n<p style=\"text-align: left;\">#listen_addresses = &#8216;localhost&#8217;<\/p>\n<p>\u00a0\u0648 \u0628\u0647 \u062e\u0637 \u0632\u06cc\u0631 \u062a\u063a\u06cc\u06cc\u0631 \u062f\u0647\u06cc\u062f. 192.168.1.5 \u0631\u0627 \u0628\u0647 \u0622\u06cc \u067e\u06cc \u0622\u062f\u0631\u0633 \u062e\u0648\u062f \u062a\u063a\u06cc\u06cc\u0631 \u062f\u0647\u06cc\u062f:<\/p>\n<p style=\"text-align: left;\">listen_addresses = &#8216;192.168.1.5&#8217;<\/p>\n<p>&nbsp;<\/p>\n<p>\u0628\u0647 \u0637\u0648\u0631 \u067e\u06cc\u0634 \u0641\u0631\u0636 PostgreSQL \u062a\u0646\u0647\u0627 \u062a\u0627\u06cc\u06cc\u062f \u0647\u0648\u06cc\u062a \u0631\u0627 \u0627\u0632 \u0644\u0648\u06a9\u0627\u0644 \u0647\u0627\u0633\u062a \u0642\u0628\u0648\u0644 \u0645\u06cc \u06a9\u0646\u062f. \u0627\u06af\u0631 \u0645\u06cc \u062e\u0648\u0627\u0647\u06cc\u062f \u0627\u06cc\u0646 \u06af\u0632\u06cc\u0646\u0647 \u0631\u0627 \u0627\u0632 \u062f\u0633\u062a\u06af\u0627\u0647 \u062e\u0627\u0631\u062c\u06cc \u0645\u062a\u0635\u0644 \u06a9\u0646\u06cc\u062f \u0628\u0627\u06cc\u062f \u0641\u0627\u06cc\u0644 pg_hba.conf \u0631\u0627 \u0648\u06cc\u0631\u0627\u06cc\u0634 \u0646\u0645\u0627\u06cc\u06cc\u062f:<\/p>\n<p>sudo nano \/etc\/postgresql\/9.6\/main\/pg_hba.conf<\/p>\n<p>\u0645\u0642\u0627\u062f\u06cc\u0631 \u0631\u0627 \u0628\u0631 \u0627\u0633\u0627\u0633 \u0646\u06cc\u0627\u0632 \u062e\u0648\u062f \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f \u0648 \u0645\u0637\u0645\u0626\u0646 \u0634\u0648\u06cc\u062f \u067e\u0633\u0648\u0631\u062f md5 \u0631\u0627 \u0645\u06cc \u067e\u0630\u06cc\u0631\u062f:<\/p>\n<p style=\"text-align: left;\"># IPv4 local connections:<\/p>\n<p style=\"text-align: left;\">host\u00a0\u00a0\u00a0 all\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0all\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 127.0.0.1\/32\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 md5<\/p>\n<p style=\"text-align: left;\">host\u00a0\u00a0\u00a0 all\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 all\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 192.168.1.0\/24\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 md5<\/p>\n<p>\u067e\u06cc\u06a9\u0631\u0628\u0646\u062f\u06cc \u0622\u067e\u0627\u0686\u06cc:<\/p>\n<p>\u0628\u0647 \u062e\u0627\u0637\u0631 \u0645\u062d\u062f\u0648\u062f\u06cc\u062a \u0647\u0627\u06cc \u0645\u0648\u062c\u0648\u062f\u060c phpPgAdmin \u062a\u0646\u0647\u0627 \u0628\u0631 \u0631\u0648\u06cc \u0644\u0648\u06a9\u0627\u0644 \u0647\u0627\u0633\u062a \u062f\u0631 \u062f\u0633\u062a\u0631\u0633 \u0627\u0633\u062a. \u0627\u06af\u0631 \u0645\u06cc \u062e\u0648\u0627\u0647\u06cc\u062f \u0622\u0646 \u0631\u0627 \u0627\u0632 \u0637\u0631\u06cc\u0642 \u062f\u0633\u062a\u06af\u0627\u0647 \u062e\u0627\u0631\u062c\u06cc \u0645\u0648\u0631\u062f \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0642\u0631\u0627\u0631 \u062f\u0647\u06cc\u062f \u0628\u0627\u06cc\u062f \u0641\u0627\u06cc\u0644 \u067e\u06cc\u06a9\u0631\u0628\u0646\u062f\u06cc \u0622\u067e\u0627\u0686\u06cc \u0631\u0627 \u062f\u0631 \u0622\u0646 \u0648\u06cc\u0631\u0627\u06cc\u0634 \u06a9\u0646\u06cc\u062f:<\/p>\n<p style=\"text-align: left;\">sudo nano \/etc\/apache2\/conf-enabled\/phppgadmin.conf<\/p>\n<p>\u0641\u0627\u06cc\u0644 config \u067e\u06cc\u0634 \u0641\u0631\u0636 \u0638\u0627\u0647\u0631\u06cc \u0634\u0628\u06cc\u0647 \u06a9\u062f \u0632\u06cc\u0631 \u062e\u0648\u0627\u0647\u062f \u062f\u0627\u0634\u062a:<\/p>\n<p style=\"text-align: left;\">Alias \/phppgadmin \/usr\/share\/phppgadmin<\/p>\n<p style=\"text-align: left;\">&lt;Directory \/usr\/share\/phppgadmin&gt;<\/p>\n<p style=\"text-align: left;\">&lt;IfModule mod_dir.c&gt;<\/p>\n<p style=\"text-align: left;\">DirectoryIndex index.php<\/p>\n<p style=\"text-align: left;\">&lt;\/IfModule&gt;<\/p>\n<p style=\"text-align: left;\">AllowOverride None<\/p>\n<p style=\"text-align: left;\"># Only allow connections from localhost:<\/p>\n<p style=\"text-align: left;\">Require local<\/p>\n<p style=\"text-align: left;\">&lt;IfModule mod_php.c&gt;<\/p>\n<p style=\"text-align: left;\">\u00a0php_flag magic_quotes_gpc Off<\/p>\n<p style=\"text-align: left;\">\u00a0php_flag track_vars On<\/p>\n<p style=\"text-align: left;\">\u00a0#php_value include_path .<\/p>\n<p style=\"text-align: left;\">&lt;\/IfModule&gt;<\/p>\n<p style=\"text-align: left;\">&lt;IfModule !mod_php.c&gt;<\/p>\n<p style=\"text-align: left;\">\u00a0&lt;IfModule mod_actions.c&gt;<\/p>\n<p style=\"text-align: left;\">\u00a0&lt;IfModule mod_cgi.c&gt;<\/p>\n<p style=\"text-align: left;\">\u00a0AddType application\/x-httpd-php .php<\/p>\n<p style=\"text-align: left;\">\u00a0Action application\/x-httpd-php \/cgi-bin\/php<\/p>\n<p style=\"text-align: left;\">\u00a0&lt;\/IfModule&gt;<\/p>\n<p style=\"text-align: left;\">\u00a0&lt;IfModule mod_cgid.c&gt;<\/p>\n<p style=\"text-align: left;\">\u00a0AddType application\/x-httpd-php .php<\/p>\n<p style=\"text-align: left;\">\u00a0Action application\/x-httpd-php \/cgi-bin\/php<\/p>\n<p style=\"text-align: left;\">\u00a0&lt;\/IfModule&gt;<\/p>\n<p style=\"text-align: left;\">\u00a0&lt;\/IfModule&gt;<\/p>\n<p style=\"text-align: left;\">&lt;\/IfModule&gt;<\/p>\n<p style=\"text-align: left;\">&lt;\/Directory&gt;<\/p>\n<p>\u0628\u0639\u062f \u0627\u0632 \u062a\u063a\u06cc\u06cc\u0631\u060c \u0627\u06cc\u0646 \u06a9\u062f \u0634\u0628\u06cc\u0647\u00a0 \u06a9\u062f \u0632\u06cc\u0631 \u062e\u0648\u0627\u0647\u062f \u0628\u0648\u062f:<\/p>\n<p style=\"text-align: left;\">Alias \/phppgadmin \/usr\/share\/phppgadmin<\/p>\n<p style=\"text-align: left;\">&lt;Directory \/usr\/share\/phppgadmin&gt;<\/p>\n<p style=\"text-align: left;\">&lt;IfModule mod_dir.c&gt;<\/p>\n<p style=\"text-align: left;\">DirectoryIndex index.php<\/p>\n<p style=\"text-align: left;\">&lt;\/IfModule&gt;<\/p>\n<p style=\"text-align: left;\">AllowOverride None<\/p>\n<p style=\"text-align: left;\"># Only allow connections from localhost:<\/p>\n<p style=\"text-align: left;\"># Require local<\/p>\n<p style=\"text-align: left;\">Require all granted<\/p>\n<p style=\"text-align: left;\">&lt;IfModule mod_php.c&gt;<\/p>\n<p style=\"text-align: left;\">\u00a0php_flag magic_quotes_gpc Off<\/p>\n<p style=\"text-align: left;\">\u00a0php_flag track_vars On<\/p>\n<p style=\"text-align: left;\">\u00a0#php_value include_path .<\/p>\n<p style=\"text-align: left;\">&lt;\/IfModule&gt;<\/p>\n<p style=\"text-align: left;\">&lt;IfModule !mod_php.c&gt;<\/p>\n<p style=\"text-align: left;\">\u00a0&lt;IfModule mod_actions.c&gt;<\/p>\n<p style=\"text-align: left;\">\u00a0&lt;IfModule mod_cgi.c&gt;<\/p>\n<p style=\"text-align: left;\">\u00a0AddType application\/x-httpd-php .php<\/p>\n<p style=\"text-align: left;\">\u00a0Action application\/x-httpd-php \/cgi-bin\/php<\/p>\n<p style=\"text-align: left;\">\u00a0&lt;\/IfModule&gt;<\/p>\n<p style=\"text-align: left;\">\u00a0&lt;IfModule mod_cgid.c&gt;<\/p>\n<p style=\"text-align: left;\">\u00a0AddType application\/x-httpd-php .php<\/p>\n<p style=\"text-align: left;\">\u00a0Action application\/x-httpd-php \/cgi-bin\/php<\/p>\n<p style=\"text-align: left;\">\u00a0&lt;\/IfModule&gt;<\/p>\n<p style=\"text-align: left;\">\u00a0&lt;\/IfModule&gt;<\/p>\n<p style=\"text-align: left;\">&lt;\/IfModule&gt;<\/p>\n<p style=\"text-align: left;\">&lt;\/Directory<\/p>\n<p>\u062d\u0627\u0644\u0627 \u0633\u0631\u0648\u06cc\u0633 \u0631\u0627 \u0631\u06cc\u0633\u062a\u0627\u0631\u062a \u06a9\u0646\u06cc\u062f.<\/p>\n<p style=\"text-align: left;\">sudo systemctl restart postgresql<\/p>\n<p style=\"text-align: left;\">sudo systemctl restart apache2<\/p>\n<p style=\"text-align: left;\">\u062f\u0633\u062a\u0631\u0633\u06cc \u0628\u0647 phpPgAdmin:<\/p>\n<p>\u00a0\u062d\u0627\u0644\u0627 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u0632 \u0637\u0631\u06cc\u0642 \u0645\u0631\u0648\u0631\u06af\u0631 \u062e\u0648\u062f \u0628\u0647 \u0627\u06cc\u0646 \u06af\u0632\u06cc\u0646\u0647 \u062f\u0633\u062a\u0631\u0633\u06cc \u067e\u06cc\u062f\u0627 \u06a9\u0646\u06cc\u062f:<\/p>\n<p style=\"text-align: left;\">http:\/\/your-ip-address\/phppgadmin<\/p>\n<p><strong>\u06cc\u0627:<\/strong><\/p>\n<p style=\"text-align: left;\">http:\/\/localhost\/phppgamin<\/p>\n<p><strong>\u00a0<\/strong><\/p>\n<p>\u0627\u06af\u0631 \u0645\u06cc \u062e\u0648\u0627\u0647\u06cc\u062f PostgreSQL instance \u0647\u0627\u06cc \u0645\u062a\u0639\u062f\u062f\u06cc \u0631\u0627 \u0627\u0632 \u0637\u0631\u06cc\u0642 \u06cc\u06a9 \u06a9\u0646\u0633\u0648\u0644 \u0648\u0627\u062d\u062f \u0645\u062f\u06cc\u0631\u06cc\u062a \u06a9\u0646\u06cc\u062f \u0628\u0627\u06cc\u062f \u0645\u0631\u0627\u062d\u0644 \u0632\u06cc\u0631 \u0631\u0627 \u0645\u062f\u0646\u0638\u0631 \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u062f. \u062f\u0631 \u063a\u06cc\u0631 \u0627\u06cc\u0646\u0635\u0648\u0631\u062a \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u0632 \u0627\u06cc\u0646 \u0645\u0631\u062d\u0644\u0647 \u0639\u0628\u0648\u0631 \u06a9\u0646\u06cc\u062f.<\/p>\n<p>\u0641\u0627\u06cc\u0644 <strong>\/etc\/phppgadmin\/config.inc.php<\/strong>\u00a0 \u0631\u0627 \u0648\u06cc\u0631\u0627\u06cc\u0634 \u06a9\u0646\u06cc\u062f:<\/p>\n<p style=\"text-align: left;\">sudo nano \/etc\/phppgadmin\/config.inc.php<\/p>\n<p>&nbsp;<\/p>\n<p>\u062d\u0627\u0644\u0627 PostgreSQL instances \u062e\u0648\u062f \u0631\u0627 \u0627\u06cc\u0646\u062c\u0627 \u0627\u0636\u0627\u0641\u0647 \u06a9\u0646\u06cc\u062f:<\/p>\n<p>&nbsp;<\/p>\n<p style=\"text-align: left;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\/\/ Display name for the server on the login screen<\/p>\n<p style=\"text-align: left;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 $conf[&#8216;servers&#8217;][0][&#8216;desc&#8217;] = &#8216;PostgreSQL &#8211; Debian&#8217;;<\/p>\n<p style=\"text-align: left;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 $conf[&#8216;servers&#8217;][1][&#8216;desc&#8217;] = &#8216;PostgreSQL &#8211; Ubuntu&#8217;;<\/p>\n<p style=\"text-align: left;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/\/ Hostname or IP address for server.\u00a0 Use &#8221; for UNIX domain socket.<\/p>\n<p style=\"text-align: left;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/\/ use &#8216;localhost&#8217; for TCP\/IP connection on this computer<\/p>\n<p style=\"text-align: left;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 $conf[&#8216;servers&#8217;][0][&#8216;host&#8217;] = &#8216;localhost&#8217;;<\/p>\n<p style=\"text-align: left;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 $conf[&#8216;servers&#8217;][1][&#8216;host&#8217;] = &#8216;192.168.1.6&#8217;;<\/p>\n<p style=\"text-align: left;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/\/ Database port on server (5432 is the PostgreSQL default)<\/p>\n<p style=\"text-align: left;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 $conf[&#8216;servers&#8217;][0][&#8216;port&#8217;] = 5432;<\/p>\n<p style=\"text-align: left;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 $conf[&#8216;servers&#8217;][1][&#8216;port&#8217;] = 5432;<\/p>\n<p style=\"text-align: left;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/\/ Database SSL mode<\/p>\n<p style=\"text-align: left;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/\/ Possible options: disable, allow, prefer, require<\/p>\n<p style=\"text-align: left;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/\/ To require SSL on older servers use option: legacy<\/p>\n<p style=\"text-align: left;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/\/ To ignore the SSL mode, use option: unspecified<\/p>\n<p style=\"text-align: left;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 $conf[&#8216;servers&#8217;][0][&#8216;sslmode&#8217;] = &#8216;allow&#8217;;<\/p>\n<p style=\"text-align: left;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 $conf[&#8216;servers&#8217;][1][&#8216;sslmode&#8217;] = &#8216;allow&#8217;;<\/p>\n<p>&nbsp;<\/p>\n<p><strong>\u00a0<\/strong><\/p>\n<p>\u0628\u0647 \u062e\u0627\u0637\u0631 \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u062f \u06a9\u0647 phpPgAdmin \u0628\u0647 \u0627\u0641\u0631\u0627\u062f\u06cc \u06a9\u0647 \u0646\u0627\u0645 \u06a9\u0627\u0631\u0628\u0631\u06cc \u06cc\u0627 \u067e\u0633\u0648\u0631\u062f \u062e\u0627\u0635\u06cc \u0646\u062f\u0627\u0631\u0646\u062f \u0627\u062c\u0627\u0632\u0647 \u0644\u0627\u06af\u06cc\u0646 \u0646\u0645\u06cc \u062f\u0647\u062f. \u0628\u0631\u0627\u06cc override \u06a9\u0631\u062f\u0646 \u0627\u06cc\u0646 \u06af\u0632\u06cc\u0646\u0647 \u0627\u0645\u0646\u06cc\u062a\u06cc\u060c \u0622\u0646 \u0631\u0627 \u0628\u0647 \u0635\u0648\u0631\u062a \u0632\u06cc\u0631 \u062a\u063a\u06cc\u06cc\u0631 \u062f\u0647\u06cc\u062f:<\/p>\n<p style=\"text-align: left;\">$conf[&#8216;extra_login_security&#8217;] = false;<\/p>\n\n\n<div class=\"kk-star-ratings kksr-auto kksr-align-right kksr-valign-bottom\"\n    data-payload='{&quot;align&quot;:&quot;right&quot;,&quot;id&quot;:&quot;1977&quot;,&quot;slug&quot;:&quot;default&quot;,&quot;valign&quot;:&quot;bottom&quot;,&quot;ignore&quot;:&quot;&quot;,&quot;reference&quot;:&quot;auto&quot;,&quot;class&quot;:&quot;&quot;,&quot;count&quot;:&quot;0&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;0&quot;,&quot;starsonly&quot;:&quot;&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;5&quot;,&quot;greet&quot;:&quot;Rate this post&quot;,&quot;legend&quot;:&quot;0\\\/5 - (0 \u0627\u0645\u062a\u06cc\u0627\u0632)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;\u0686\u06af\u0648\u0646\u0647 PhpPgAdmin \u0631\u0627 \u0628\u0631 \u0631\u0648\u06cc \u062f\u0628\u06cc\u0627\u0646 9\u060c \u0627\u0648\u0628\u0648\u0646\u062a\u0648 16.04 \u060c \u0644\u06cc\u0646\u0648\u06a9\u0633 \u0645\u06cc\u0646\u062a 18 \u0646\u0635\u0628 \u06a9\u0646\u06cc\u0645\u061f&quot;,&quot;width&quot;:&quot;0&quot;,&quot;_legend&quot;:&quot;{score}\\\/{best} - ({count} {votes})&quot;,&quot;font_factor&quot;:&quot;1.25&quot;}'>\n            \n<div class=\"kksr-stars\">\n    \n<div class=\"kksr-stars-inactive\">\n            <div class=\"kksr-star\" data-star=\"1\" style=\"padding-left: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"2\" style=\"padding-left: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"3\" style=\"padding-left: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"4\" style=\"padding-left: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"5\" style=\"padding-left: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n    \n<div class=\"kksr-stars-active\" style=\"width: 0px;\">\n            <div class=\"kksr-star\" style=\"padding-left: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-left: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-left: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-left: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-left: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n<\/div>\n                \n\n<div class=\"kksr-legend\" style=\"font-size: 19.2px;\">\n            <span class=\"kksr-muted\">Rate this post<\/span>\n    <\/div>\n    <\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u0647\u0645\u0627\u0646\u0637\u0648\u0631 \u06a9\u0647 \u0645\u06cc \u062f\u0627\u0646\u06cc\u062f PhpPgAdmin \u06cc\u06a9 \u0627\u0628\u0632\u0627\u0631 \u0645\u062f\u06cc\u0631\u06cc\u062a\u06cc \u0645\u0628\u062a\u0646\u06cc \u0628\u0631 \u0648\u0628 \u0628\u0631\u0627\u06cc \u0645\u062f\u06cc\u0631\u06cc\u062a \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 PostgreSQL \u0627\u0633\u062a \u06a9\u0647 \u0634\u0628\u0627\u0647\u062a \u0632\u06cc\u0627\u062f\u06cc \u0628\u0647 phpMyAdmin \u062f\u0627\u0631\u062f.\u00a0 \u0627\u06af\u0631 \u0642\u0628\u0644\u0627 \u0628\u0627 phpMyAdmin \u06a9\u0627\u0631 \u06a9\u0631\u062f\u0647\u00a0 \u0628\u0627\u0634\u06cc\u062f \u062f\u0631\u06a9 \u0639\u0645\u0644\u06a9\u0631\u062f phpPgAdmin \u0646\u06cc\u0632 \u0628\u0631\u0627\u06cc\u062a\u0627\u0646 \u0633\u0627\u062f\u0647 \u0648 \u0622\u0633\u0627\u0646 \u062e\u0648\u0627\u0647\u062f \u0628\u0648\u062f. \u062f\u0631 \u0627\u06cc\u0646 \u0645\u0642\u0627\u0644\u0647 \u0642\u0635\u062f \u062f\u0627\u0631\u06cc\u0645 \u0628\u0647 \u0646\u0635\u0628 \u0627\u06cc\u0646 \u0627\u0628\u0632\u0627\u0631 \u0645\u062f\u06cc\u0631\u06cc\u062a\u06cc \u0628\u067e\u0631\u062f\u0627\u0632\u06cc\u0645. \u067e\u0633 \u0647\u0645\u0631\u0627\u0647 \u0648\u0628 \u0627\u06cc\u062f\u0647 &hellip;<\/p>\n","protected":false},"author":8,"featured_media":1978,"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":""},"categories":[1371,1372,1370,3],"tags":[1572,1574,373,1575,372,375,1573],"class_list":["post-1977","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ubuntu","category-debian","category-linux","category-web-articles","tag-phppgadmin","tag-postgresql","tag-373","tag--phppgadmin-----9--16-04--","tag-372","tag-375","tag--phppgadmin"],"views":"823","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/parry3-vT","jetpack_featured_media_url":"https:\/\/webide.ir\/blog\/wp-content\/uploads\/2017\/10\/postgresql-logo1.png","_links":{"self":[{"href":"https:\/\/webide.ir\/blog\/wp-json\/wp\/v2\/posts\/1977","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/webide.ir\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/webide.ir\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/webide.ir\/blog\/wp-json\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/webide.ir\/blog\/wp-json\/wp\/v2\/comments?post=1977"}],"version-history":[{"count":0,"href":"https:\/\/webide.ir\/blog\/wp-json\/wp\/v2\/posts\/1977\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/webide.ir\/blog\/wp-json\/wp\/v2\/media\/1978"}],"wp:attachment":[{"href":"https:\/\/webide.ir\/blog\/wp-json\/wp\/v2\/media?parent=1977"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/webide.ir\/blog\/wp-json\/wp\/v2\/categories?post=1977"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/webide.ir\/blog\/wp-json\/wp\/v2\/tags?post=1977"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}