{"id":121,"date":"2020-02-25T02:52:00","date_gmt":"2020-02-25T02:52:00","guid":{"rendered":"https:\/\/molecularsciences.org\/content\/?p=121"},"modified":"2024-02-06T08:22:50","modified_gmt":"2024-02-06T13:22:50","slug":"installing-phppgadmin-on-ubuntu","status":"publish","type":"post","link":"https:\/\/molecularsciences.org\/content\/installing-phppgadmin-on-ubuntu\/","title":{"rendered":"Installing phpPgAdmin on Ubuntu"},"content":{"rendered":"\n<p>phpPgAdmin is a web-based administration tool for PostgreSQL written in PHP. It is a very nifty tool with a very convenient GUI interface. If you have used phpMyAdmin for MySQL, this phpMyAdmin for PostgreSQL.<\/p>\n\n\n\n<p>To install phpPgAdmin on Ubuntu, to the following:<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>sudo apt-get install phppgadmin<\/li><li>open your browser and type http:\/\/localhost\/phppgadmin<\/li><li>Login and start using phpPgAdmin<\/li><\/ol>\n\n\n\n<p>If you see the error:&nbsp;<strong>Login disallowed for security reasons<\/strong>, do the following: 1. Configure your pg_hba.conf to configure client authentication. See&nbsp;<a target=\"_blank\" href=\"http:\/\/wiki.postgresql.org\/wiki\/Client_Authentication\" rel=\"noreferrer noopener\">postgre wiki<\/a>&nbsp;2. If this doesn&#8217;t work, set&nbsp;<strong>extra_login_security<\/strong>&nbsp;in \/etc\/phppgadmin\/config.inc.php file to false.<\/p>\n\n\n\n<p><strong>Note: be sure to backup the config files before you edit them<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>phpPgAdmin is a web-based administration tool for PostgreSQL written in PHP. It is a very nifty tool with a very convenient GUI interface. If you have used phpMyAdmin for MySQL, this phpMyAdmin for PostgreSQL. To install phpPgAdmin on Ubuntu, to the following: sudo apt-get install phppgadmin open your browser and type http:\/\/localhost\/phppgadmin Login and start [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[23],"tags":[82,24,59],"class_list":["post-121","post","type-post","status-publish","format-standard","hentry","category-php","tag-installation-guide","tag-php","tag-postgresql"],"_links":{"self":[{"href":"https:\/\/molecularsciences.org\/content\/wp-json\/wp\/v2\/posts\/121","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/molecularsciences.org\/content\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/molecularsciences.org\/content\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/molecularsciences.org\/content\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/molecularsciences.org\/content\/wp-json\/wp\/v2\/comments?post=121"}],"version-history":[{"count":1,"href":"https:\/\/molecularsciences.org\/content\/wp-json\/wp\/v2\/posts\/121\/revisions"}],"predecessor-version":[{"id":122,"href":"https:\/\/molecularsciences.org\/content\/wp-json\/wp\/v2\/posts\/121\/revisions\/122"}],"wp:attachment":[{"href":"https:\/\/molecularsciences.org\/content\/wp-json\/wp\/v2\/media?parent=121"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/molecularsciences.org\/content\/wp-json\/wp\/v2\/categories?post=121"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/molecularsciences.org\/content\/wp-json\/wp\/v2\/tags?post=121"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}