Prerequisites<\/h2>\n\n- Ubuntu 18.04<\/li>\n
- Root privileges<\/li>\n<\/ul>\n
What we will do?<\/h2>\n\n- Install PostgreSQL and phpPgAdmin<\/li>\n
- Configure Postgres User<\/li>\n
- Configure Apache2<\/li>\n
- Configure phpPgAdmin<\/li>\n
- Testing<\/li>\n<\/ol>\n
Step 1 – Install PostgreSQL, phpPgAdmin and All Dependencies<\/h2>\n
Before installing any packages on the Ubuntu system, update all available repositories.<\/p>\n
sudo apt update<\/p>\n
And now we’re ready for installing PostgreSQL, phpPgAdmin, and Apache2 packages.<\/p>\n
PostgreSQL and PhpPgAdmin are available in the Ubuntu repository. So you just need to install them with the apt command.<\/p>\n
sudo apt -y install postgresql postgresql-contrib phppgadmin<\/p>\n
The above command will automatically install all packages needed by PostgreSQL and phpPgAdmin, like Apache2, PHP etc.<\/p>\n
Step 2 – Configure Postgres User<\/h2>\n
PostgreSQL uses role for user authentication and authorization, it just like Unix-Style permissions. By default, PostgreSQL creates a new user called “postgres” for basic authentication. To use PostgreSQL, you need to login to the “postgres” account, you can do that by typing:<\/p>\n
su – postgres<\/p>\n
Now you can access the PostgreSQL prompt with the command:<\/p>\n
psql<\/p>\n
And then change the password for postgres role by typing:<\/p>\n
\\password postgres
TYPE THE POSTGRES PASSWORD<\/p>\n
Then enter \\q to leave the psql command line.<\/p>\n
\\q<\/p>\n
Run the command “exit” to leave the postgres user and become root again.<\/p>\n
exit<\/p>\n
![\"Set](\"https:\/\/afaghhosting.net\/blog\/wp-content\/uploads\/2018\/06\/how-to-install-postgresql-and-phppgadmin-on-ubuntu-18-04.png\" "\\"\\"")
<\/a><\/p>\nStep 3 – Configure Apache Web Server<\/h2>\n
You need to configure Apache virtual host configuration for phpPgAdmin.<\/p>\n
Goto the ‘\/etc\/apache2\/conf-available’ directory and edit the configuration file ‘phppgadmin.conf’ with\u00a0vim<\/a> by typing:<\/p>\ncd \/etc\/apache2\/conf-available\/
vim phppgadmin.conf<\/p>\n
Comment out the line ‘#Require local’ by adding a # in front of the line and add below the line allow from all so that you can access from your browser.<\/p>\n
Require all granted<\/pre>\nSave and exit.<\/p>\n
![\"Configure](\"https:\/\/afaghhosting.net\/blog\/wp-content\/uploads\/2018\/06\/how-to-install-postgresql-and-phppgadmin-on-ubuntu-18-04-1.png\" "\\"\\"")
<\/a><\/p>\nStep 4 – Configure phpPgAdmin<\/h2>\n
Go to the ‘\/etc\/phppgadmin’ directory and edit the configuration file ‘config.inc.php’ by typing :<\/p>\n
cd \/etc\/phppgadmin\/
vim config.inc.php<\/p>\n
Find the line ‘$conf[‘extra_login_security’] = true;’ and change the value to ‘false’ so you can login to phpPgAdmin with user postgres.<\/p>\n
$conf['extra_login_security'] = false;<\/pre>\nSave and exit.<\/p>\n
![\"Configure](\"https:\/\/afaghhosting.net\/blog\/wp-content\/uploads\/2018\/06\/how-to-install-postgresql-and-phppgadmin-on-ubuntu-18-04-2.png\" "\\"\\"")
<\/a><\/p>\nNow restart the PostgreSQL and Apache2 services.<\/p>\n
systemctl restart posqtgresql
systemctl restart apache2<\/p>\n
Step 5 – Testing Postgres<\/h2>\n
By default, PostgreSQL is running on port ‘5432’, and the Apache2 running on the default HTTP port ’80’.<\/p>\n
Check using netstat command.<\/p>\n
netstat -plntu<\/p>\n
![\"Check](\"https:\/\/afaghhosting.net\/blog\/wp-content\/uploads\/2018\/06\/how-to-install-postgresql-and-phppgadmin-on-ubuntu-18-04-3.png\" "\\"\\"")
<\/a><\/p>\nNow access phpPgAdmin with your browser http:\/\/yourip\/phppgadmin\/.<\/p>\n
![\"Login](\"https:\/\/afaghhosting.net\/blog\/wp-content\/uploads\/2018\/06\/how-to-install-postgresql-and-phppgadmin-on-ubuntu-18-04-4.png\" "\\"\\"")
<\/a><\/p>\nand then try login to with user ‘postgres’ and your password.<\/p>\n
![\"Login](\"https:\/\/afaghhosting.net\/blog\/wp-content\/uploads\/2018\/06\/how-to-install-postgresql-and-phppgadmin-on-ubuntu-18-04-5.png\" "\\"\\"")
<\/a><\/p>\nAfter logging in, you will get this phpPgAdmin dashboard interface:<\/p>\n
![\"phpPgAdmin](\"https:\/\/afaghhosting.net\/blog\/wp-content\/uploads\/2018\/06\/how-to-install-postgresql-and-phppgadmin-on-ubuntu-18-04-6.png\" "\\"\\"")
<\/a><\/p>\nThe installation of PostgreSQL database with phpPgAdmin on ubuntu 18.04 has been completed successfully.<\/p>\n
Conclusion<\/h2>\n
PostgreSQL is an advanced object-relational database management system (ORDBMS). It is Open Source and has a large and active Community. PostgreSQL provides the psql command line program as primary front-end, which can be used to enter SQL queries directly or execute them from a file. phpPgAdmin is a web-based administration tool for PostgreSQL written in PHP that makes the administration of Postgres databases easier.<\/p>\n
\nShare this page:<\/b><\/p>\n
\n![\"\"](\"https:\/\/afaghhosting.net\/blog\/wp-content\/uploads\/2018\/06\/how-to-install-postgresql-and-phppgadmin-on-ubuntu-18-04-7.png\" "\\"\\"")
<\/a>
\n![\"\"](\"https:\/\/afaghhosting.net\/blog\/wp-content\/uploads\/2018\/06\/how-to-install-postgresql-and-phppgadmin-on-ubuntu-18-04-8.png\" "\\"\\"")
<\/a>
\n![\"\"](\"https:\/\/afaghhosting.net\/blog\/wp-content\/uploads\/2018\/06\/how-to-install-postgresql-and-phppgadmin-on-ubuntu-18-04-9.png\" "\\"\\"")
<\/a>
\n![\"\"](\"https:\/\/afaghhosting.net\/blog\/wp-content\/uploads\/2018\/06\/how-to-install-postgresql-and-phppgadmin-on-ubuntu-18-04-10.png\" "\\"\\"")
<\/a>\n<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"PostgreSQL or Postgres is a powerful high-performance object-relational database management system (ORDBMS) released under a flexible BSD-style license. PostgreSQL is well suited for large databases and has many advanced features. PostgreSQL is available for many operating systems including Linux, FreeBSD, Solaris, and Microsoft Windows. PhpPgAdmin is a PHP-based web application for managing PostgreSQL databases. With […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[36],"tags":[],"class_list":["post-4939","post","type-post","status-publish","format-standard","hentry","category-36"],"_links":{"self":[{"href":"https:\/\/afaghhosting.net\/blog\/wp-json\/wp\/v2\/posts\/4939","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/afaghhosting.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/afaghhosting.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/afaghhosting.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/afaghhosting.net\/blog\/wp-json\/wp\/v2\/comments?post=4939"}],"version-history":[{"count":0,"href":"https:\/\/afaghhosting.net\/blog\/wp-json\/wp\/v2\/posts\/4939\/revisions"}],"wp:attachment":[{"href":"https:\/\/afaghhosting.net\/blog\/wp-json\/wp\/v2\/media?parent=4939"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/afaghhosting.net\/blog\/wp-json\/wp\/v2\/categories?post=4939"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/afaghhosting.net\/blog\/wp-json\/wp\/v2\/tags?post=4939"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
What we will do?<\/h2>\n\n- Install PostgreSQL and phpPgAdmin<\/li>\n
- Configure Postgres User<\/li>\n
- Configure Apache2<\/li>\n
- Configure phpPgAdmin<\/li>\n
- Testing<\/li>\n<\/ol>\n
Step 1 – Install PostgreSQL, phpPgAdmin and All Dependencies<\/h2>\n
Before installing any packages on the Ubuntu system, update all available repositories.<\/p>\n
sudo apt update<\/p>\n
And now we’re ready for installing PostgreSQL, phpPgAdmin, and Apache2 packages.<\/p>\n
PostgreSQL and PhpPgAdmin are available in the Ubuntu repository. So you just need to install them with the apt command.<\/p>\n
sudo apt -y install postgresql postgresql-contrib phppgadmin<\/p>\n
The above command will automatically install all packages needed by PostgreSQL and phpPgAdmin, like Apache2, PHP etc.<\/p>\n
Step 2 – Configure Postgres User<\/h2>\n
PostgreSQL uses role for user authentication and authorization, it just like Unix-Style permissions. By default, PostgreSQL creates a new user called “postgres” for basic authentication. To use PostgreSQL, you need to login to the “postgres” account, you can do that by typing:<\/p>\n
su – postgres<\/p>\n
Now you can access the PostgreSQL prompt with the command:<\/p>\n
psql<\/p>\n
And then change the password for postgres role by typing:<\/p>\n
\\password postgres
TYPE THE POSTGRES PASSWORD<\/p>\n
Then enter \\q to leave the psql command line.<\/p>\n
\\q<\/p>\n
Run the command “exit” to leave the postgres user and become root again.<\/p>\n
exit<\/p>\n
<\/a><\/p>\nStep 3 – Configure Apache Web Server<\/h2>\n
You need to configure Apache virtual host configuration for phpPgAdmin.<\/p>\n
Goto the ‘\/etc\/apache2\/conf-available’ directory and edit the configuration file ‘phppgadmin.conf’ with\u00a0vim<\/a> by typing:<\/p>\ncd \/etc\/apache2\/conf-available\/
vim phppgadmin.conf<\/p>\n
Comment out the line ‘#Require local’ by adding a # in front of the line and add below the line allow from all so that you can access from your browser.<\/p>\n
Require all granted<\/pre>\nSave and exit.<\/p>\n
<\/a><\/p>\nStep 4 – Configure phpPgAdmin<\/h2>\n
Go to the ‘\/etc\/phppgadmin’ directory and edit the configuration file ‘config.inc.php’ by typing :<\/p>\n
cd \/etc\/phppgadmin\/
vim config.inc.php<\/p>\n
Find the line ‘$conf[‘extra_login_security’] = true;’ and change the value to ‘false’ so you can login to phpPgAdmin with user postgres.<\/p>\n
$conf['extra_login_security'] = false;<\/pre>\nSave and exit.<\/p>\n
<\/a><\/p>\nNow restart the PostgreSQL and Apache2 services.<\/p>\n
systemctl restart posqtgresql
systemctl restart apache2<\/p>\n
Step 5 – Testing Postgres<\/h2>\n
By default, PostgreSQL is running on port ‘5432’, and the Apache2 running on the default HTTP port ’80’.<\/p>\n
Check using netstat command.<\/p>\n
netstat -plntu<\/p>\n
<\/a><\/p>\nNow access phpPgAdmin with your browser http:\/\/yourip\/phppgadmin\/.<\/p>\n
<\/a><\/p>\nand then try login to with user ‘postgres’ and your password.<\/p>\n
<\/a><\/p>\nAfter logging in, you will get this phpPgAdmin dashboard interface:<\/p>\n
<\/a><\/p>\nThe installation of PostgreSQL database with phpPgAdmin on ubuntu 18.04 has been completed successfully.<\/p>\n
Conclusion<\/h2>\n
PostgreSQL is an advanced object-relational database management system (ORDBMS). It is Open Source and has a large and active Community. PostgreSQL provides the psql command line program as primary front-end, which can be used to enter SQL queries directly or execute them from a file. phpPgAdmin is a web-based administration tool for PostgreSQL written in PHP that makes the administration of Postgres databases easier.<\/p>\n
\nShare this page:<\/b><\/p>\n
\n<\/a>
\n<\/a>
\n<\/a>
\n<\/a>\n<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"PostgreSQL or Postgres is a powerful high-performance object-relational database management system (ORDBMS) released under a flexible BSD-style license. PostgreSQL is well suited for large databases and has many advanced features. PostgreSQL is available for many operating systems including Linux, FreeBSD, Solaris, and Microsoft Windows. PhpPgAdmin is a PHP-based web application for managing PostgreSQL databases. With […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[36],"tags":[],"class_list":["post-4939","post","type-post","status-publish","format-standard","hentry","category-36"],"_links":{"self":[{"href":"https:\/\/afaghhosting.net\/blog\/wp-json\/wp\/v2\/posts\/4939","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/afaghhosting.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/afaghhosting.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/afaghhosting.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/afaghhosting.net\/blog\/wp-json\/wp\/v2\/comments?post=4939"}],"version-history":[{"count":0,"href":"https:\/\/afaghhosting.net\/blog\/wp-json\/wp\/v2\/posts\/4939\/revisions"}],"wp:attachment":[{"href":"https:\/\/afaghhosting.net\/blog\/wp-json\/wp\/v2\/media?parent=4939"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/afaghhosting.net\/blog\/wp-json\/wp\/v2\/categories?post=4939"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/afaghhosting.net\/blog\/wp-json\/wp\/v2\/tags?post=4939"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
Step 1 – Install PostgreSQL, phpPgAdmin and All Dependencies<\/h2>\n
Before installing any packages on the Ubuntu system, update all available repositories.<\/p>\n
sudo apt update<\/p>\n
And now we’re ready for installing PostgreSQL, phpPgAdmin, and Apache2 packages.<\/p>\n
PostgreSQL and PhpPgAdmin are available in the Ubuntu repository. So you just need to install them with the apt command.<\/p>\n
sudo apt -y install postgresql postgresql-contrib phppgadmin<\/p>\n
The above command will automatically install all packages needed by PostgreSQL and phpPgAdmin, like Apache2, PHP etc.<\/p>\n
Step 2 – Configure Postgres User<\/h2>\n
PostgreSQL uses role for user authentication and authorization, it just like Unix-Style permissions. By default, PostgreSQL creates a new user called “postgres” for basic authentication. To use PostgreSQL, you need to login to the “postgres” account, you can do that by typing:<\/p>\n
su – postgres<\/p>\n
Now you can access the PostgreSQL prompt with the command:<\/p>\n
psql<\/p>\n
And then change the password for postgres role by typing:<\/p>\n
\\password postgres
TYPE THE POSTGRES PASSWORD<\/p>\n
Then enter \\q to leave the psql command line.<\/p>\n
\\q<\/p>\n
Run the command “exit” to leave the postgres user and become root again.<\/p>\n
exit<\/p>\n
You need to configure Apache virtual host configuration for phpPgAdmin.<\/p>\n Goto the ‘\/etc\/apache2\/conf-available’ directory and edit the configuration file ‘phppgadmin.conf’ with\u00a0vim<\/a> by typing:<\/p>\n cd \/etc\/apache2\/conf-available\/ Comment out the line ‘#Require local’ by adding a # in front of the line and add below the line allow from all so that you can access from your browser.<\/p>\n Save and exit.<\/p>\n Go to the ‘\/etc\/phppgadmin’ directory and edit the configuration file ‘config.inc.php’ by typing :<\/p>\n cd \/etc\/phppgadmin\/ Find the line ‘$conf[‘extra_login_security’] = true;’ and change the value to ‘false’ so you can login to phpPgAdmin with user postgres.<\/p>\n Save and exit.<\/p>\n Now restart the PostgreSQL and Apache2 services.<\/p>\n systemctl restart posqtgresql By default, PostgreSQL is running on port ‘5432’, and the Apache2 running on the default HTTP port ’80’.<\/p>\n Check using netstat command.<\/p>\n netstat -plntu<\/p>\n Now access phpPgAdmin with your browser http:\/\/yourip\/phppgadmin\/.<\/p>\n and then try login to with user ‘postgres’ and your password.<\/p>\n After logging in, you will get this phpPgAdmin dashboard interface:<\/p>\n The installation of PostgreSQL database with phpPgAdmin on ubuntu 18.04 has been completed successfully.<\/p>\n PostgreSQL is an advanced object-relational database management system (ORDBMS). It is Open Source and has a large and active Community. PostgreSQL provides the psql command line program as primary front-end, which can be used to enter SQL queries directly or execute them from a file. phpPgAdmin is a web-based administration tool for PostgreSQL written in PHP that makes the administration of Postgres databases easier.<\/p>\n Share this page:<\/b><\/p>\n \n PostgreSQL or Postgres is a powerful high-performance object-relational database management system (ORDBMS) released under a flexible BSD-style license. PostgreSQL is well suited for large databases and has many advanced features. PostgreSQL is available for many operating systems including Linux, FreeBSD, Solaris, and Microsoft Windows. PhpPgAdmin is a PHP-based web application for managing PostgreSQL databases. With […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[36],"tags":[],"class_list":["post-4939","post","type-post","status-publish","format-standard","hentry","category-36"],"_links":{"self":[{"href":"https:\/\/afaghhosting.net\/blog\/wp-json\/wp\/v2\/posts\/4939","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/afaghhosting.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/afaghhosting.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/afaghhosting.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/afaghhosting.net\/blog\/wp-json\/wp\/v2\/comments?post=4939"}],"version-history":[{"count":0,"href":"https:\/\/afaghhosting.net\/blog\/wp-json\/wp\/v2\/posts\/4939\/revisions"}],"wp:attachment":[{"href":"https:\/\/afaghhosting.net\/blog\/wp-json\/wp\/v2\/media?parent=4939"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/afaghhosting.net\/blog\/wp-json\/wp\/v2\/categories?post=4939"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/afaghhosting.net\/blog\/wp-json\/wp\/v2\/tags?post=4939"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}<\/a><\/p>\nStep 3 – Configure Apache Web Server<\/h2>\n
vim phppgadmin.conf<\/p>\nRequire all granted<\/pre>\n
<\/a><\/p>\nStep 4 – Configure phpPgAdmin<\/h2>\n
vim config.inc.php<\/p>\n$conf['extra_login_security'] = false;<\/pre>\n
<\/a><\/p>\n
systemctl restart apache2<\/p>\nStep 5 – Testing Postgres<\/h2>\n
<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\nConclusion<\/h2>\n
<\/a>
\n<\/a>
\n<\/a>
\n<\/a>\n<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"