When writing this article, the default version of postgresql present by default in the repository is postgresql 10 which means that if you want another version like 9 or 11, you will need to follow the steps of this postresql wiki page recommended by the official website.īy default, postgresql creates a basic user postgres and database administrator with the same name and uses many authentications methods of which the most used are peer and md5. the default version of php that it will install is php 7.2 Postgresql is present in the default repositories of Ubuntu 18.04 and for PhpPgAdmin, it works with apache and php which means that if it's not already installed, it will download and install automatically. In this article, we will see how you can install PostgreSql and PhpPgAdmin on Ubuntu 18.04 to handle your database through the web interface. This can save you some times in your work. If offers many features like the possibility to backup and restore your databases. It's a web interface helping you to manage your PostgreSql database in an easy way. To solve this issue, there is another open source tool called PhpPgAdmin which can help you to graphically manage your databases. Most of the Linux professional open source tools work with command line such as postgresql which can give you quite difficulties to manage all your databases if you are a novice in the area.
It can use and extend the SQL language to handle workloads from small to large applications. It's a free and open source relational database management system which is mostly in production environment. There are many object-relational database system and one which is famous and powerful among them is PostgreSql.
You can need to manage a database in other to store some information regarding your operations. By Alain Francois, Alibaba Cloud Community Blog author
0 kommentar(er)
