addPostgis

create a complex extension

For example : create a postgis
if you install postgis at first, there are some information as viewed below:
Geos-config not found
gdal-config not found
Sudo apt install libgdal-dev
You should install proj and geos first

How To Add Extensions To PG on Ubuntu

How Extensibility Works

PostgreSQL is extensible because its operation is catalog-driven.

PostgreSQL stores much more information in its catalogs: not only information about tables and columns, but also information about data types, functions, access methods, and so on. These tables can be modified by the user, and since PostgreSQL bases its operation on these tables, this means that PostgreSQL can be extended by users.

The PostgreSQL server can moreover incorporate user-written code into itself through dynamic loading.

Elephant Shed

介绍

Elephant Shed 是一个基于网页版的postgreSQL前端管理软件。他捆绑了PostgreSQL的各项应用软件和组件。当前他能管理单点Debian/Ubuntu PostgreSQL服务起和应用。

installing pgAdmin4 and pg on Ubuntu

PgAdmin 4 Installation Steps

  1. Update the system
    Before starting the installation process, you have to update the system by executing the following command.
$sudo apt update   

pgadmin

Hexo Github

What is Hexo?

Welcome to Hexo! This is your very first post. Check documentation for more info. If you get any problems when using Hexo, you can find the answer in troubleshooting or you can ask me on GitHub.

Step

1.create new Repository in Github
2.Install Tools
3.Deploy Website
4.Use Hexo
5.Auto browersersync
6.Markdown Article

Your browser is out-of-date!

Update your browser to view this website correctly. Update my browser now

×