Friday, September 13, 2019

.::: Sript multiple dig domain (DNS) using Script :::.

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]#

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
WITH
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 ;

Popular Posts