To store any details about your activities, you may need to handle a database in another. There are several object-relational database systems, and one of them is PostgreSql, which is popular and powerful. It is a method of relational database management that is free and open source, often in a development environment. In order to manage workloads from small to large applications, it can use and expand the SQL language. Most of the specialist open source Linux tools operate from a command line like postgresql, which can make it very challenging for you to handle all the databases if you are a beginner in the field.
To solve this issue, there is another open source tool called PhpPgAdmin which can help you to graphically manage your databases. It's a web interface helping you to manage your PostgreSql database in an easy way. If offers many features like the possibility to backup and restore your databases. This can save you some times in your work.
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.
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. the default version of php that it will install is php 7.2
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.
By 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 peer authentication is used for database administrators and is only supported for local connections because it tries to obtain the client's operating system user name from the kernel to use it as the allowed database user name while the md5 authentication works the same but is used across the connection. That one can be particularly helpful on local connections when you have a multi-users machine.
Postrgresql also use sthe system of role to handle efficiently the permissions for the database access which can be a group of DB users, or simply a DB user, etc. The roles allow to assign privileges to database objects they own, enabling access and actions to those objects and have the ability to grant membership to another role.
GeoNode is a web-based application and platform for developing geospatial information systems (GIS) and for deploying spatial data infrastructures (SDI). It is designed to be extended and modified, and can be integrated into existing platforms. It is Developed with Django framework and contains Twitter Bootstrap and jQuery client implementation.
For you to successfully complete this tutorial. you will need to have:
In this tutorial we are going to learn how to deploy a geonode project on an Alibaba Cloud Ubuntu 16.04 Elastic Compute Service (ECS) instance.
Alibaba Cloud Elastic Compute Service (ECS) provides fast memory and the latest Intel CPUs to help you to power your cloud applications and achieve faster results with low latency.
Deploy ECS instances with just a few clicks from the easy-to-use console and scale capacity up or down based on real-time demands.
This topic describes how to create and manage an ECS instance by using the ECS console, CLI commands, or SDKs. This topic also describes how to select an instance type based on scenarios and applications.
The lifecycle of an ECS instance begins when the instance is created and ends when the instance is released. This topic describes the states that an ECS instance may go through during its lifecycle.
Alibaba Clouder - January 18, 2021
digoal - March 25, 2020
Alibaba Clouder - February 11, 2020
Alibaba Clouder - February 24, 2020
Alibaba Clouder - January 9, 2020
Sajid Qureshi - August 8, 2018
More Posts by Alibaba Clouder