Hi!, I have a longer time without write a post ... ups xD.
Today I write a little post explain you: How I installed PostGis plugin, create geometry table, and insert data.
Fast Specs in my server: Centos 7 minimal install, Postgres 11.
Fast Specs in my Macbook: PgAdmin 4, QGis.
# yum install postgis2_11
important!!! : the latest number its your Postgres Version in your server.
I use PgAdmin because my team its a non-programmer or technical users, maybe I write a post explain this.
2.2 : Run the script on "Enabling PostGIS" section: https://postgis.net/install/
CREATE TABLE TABLEOFPOINTS ( id serial, Place character varying COLLATE pg_catalog."default" NOT NULL, dir character varying COLLATE pg_catalog."default", geog geography(Point,4326) NOT NULL, CONSTRAINT TABLEOFPINTS_pkey PRIMARY KEY (id) )
Okay, Now you have a simple points table; NOT POLYGONAL.
4.1: Enable experimental and deprecated plugins
Plugins->Manage and install plugins->Settings
4.2 Search and Install OpenLayers
4.3 Add OpenLayers plugin to project
First make sure you have chosen the layer "TABLEOFPOINTS"
1- Click on Pencil icon (Toggle edit).
2- Click on "Add Point feature", and add your points.
3- Complete your data info and click on "Save Layer edit" icon
Ok, if I'am a good teacher you can create spatial database of point, basic use of Qgis and connect at your first Geo Table; finally add points at your database.
The next week, I need use the Geo table to show points using NodeJS and VUE. I hope, this post has been useful for you and also listen to any suggestions for use in node and vue