Community Blog PostgreSQL Tutorial that You'll Not Want to Miss

PostgreSQL Tutorial that You'll Not Want to Miss

In this article, we'll show you how you can set up PostgreSQL and PhpPgadmin and deploy a Geonode project on ECS instance.

How To Set up PostgreSQL and PhpPgadmin on Ubuntu 18.04

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.

Deploy Geonode Project with Geoserver, Tomcat8, and PostgreSQL on ECS

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:

  1. A valid Alibaba Cloud account. If you don't have one already, sign up to the Alibaba Cloud Free Trial.
  2. An ECS instance running Ubuntu 16.04. You can select your preferred region and configurations; this will not affect the outcome of the server setup.
  3. A root password for your server.
  4. Stable Internet connection

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.

Related Products

Elastic Compute Service

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.

Related Documentation

ECS Overview

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.

ECS instance lifecycle

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.

0 0 0
Share on

Alibaba Clouder

2,628 posts | 707 followers

You may also like