1. Sample host
[root@server-teguht teguht]# cat hostdomain.txt
www.example.com
example.com
a.example.com
aaa.example.com
aaaa.example.com
example.com
info.example.com
cname.example.com
examplealias.example.com
[root@server-teguht teguht]#
Friday, September 13, 2019
Saturday, September 7, 2019
.::: Study Kasus Praktis belajar Query create & insert table Postgress SQL (Create Data Warehouse) include via CLI & GUI :::.
1. Create database using query or GUI
CREATE DATABASE tgh
OWNER = postgres
ENCODING = 'UTF8'
LC_COLLATE = 'English_United States.1252'
LY_TYPE = 'English_United States.1252'
TABLE_SPACE = pg_default
CONNECT LIMIT = -1 ;
GRANT CREATE, CONNECT ON DATABASE tgh TO postgres;
GRANT TEMPORARY ON DATABASE tgh TO postgres WITH GRANT OPTION;
GRANT TEMPORARY, CONNECT ON DATABASE tgh TO PUBLIC ;