Thursday, February 29, 2024

.::: Study Kasus Praktis belajar Query create & insert table/Collection MongoDB (Data Warehouse) dengan Primary Key :::.

›
1. correlation with other post http://teguhth.blogspot.com/2020/12/study-kasus-praktis-belajar-query.html 2. create collection with primaryk...
Wednesday, February 28, 2024

.::: Create User MongoDB role admin and readonly and authenticationRestrictions :::.

›
1. create user admin use admin db.createUser({ user: "admin",pwd: "admin", roles: [{ role: "readAnyDatabase", ...
Tuesday, February 27, 2024

.::: Create a dblink to a remote server MariaDB MySQL to PostgreSQL EDB and using metode SRCDEF :::.

›
1. install ODBC postgresql * configure http://teguhth.blogspot.com/2024/01/install-postgresql-odbc-driver-on-linux.html A. using dblink 1. c...
Monday, February 26, 2024

.::: Access MariaDB from PostgreSQL using dblink /FOREIGN DATA WRAPPER mysql_fdw :::.

›
1. install mysql_fdw wget https://download.postgresql.org/pub/repos/yum/15/redhat/rhel-7.9-x86_64/mysql_fdw_15-2.8.0-2.rhel7.x86_64.rpm yum ...

.::: Enable pgaudit & pgauditlogtofile in PostgreSQL EDB ::.

›
  1. Download pgaudit & pgauditlogtofile https://download.postgresql.org/pub/repos/yum/16/redhat/rhel-8.2-x86_64/ yum install -y https:/...
Friday, February 23, 2024

.::: How to Use backup & Restore Database MySQL MariaDB using MariaDB Backup :::.

›
  A. Backup with mariabackup 1. install mariabackup yum install -y MariaDB-backup -y 2. check data before testing select * from teguhth.bara...
Wednesday, February 21, 2024

.::: Create dblink using dblink_connect & dblink in PostgreSQL EDB :::.

›
1. check before setting select pg_read_file('/etc/hostname') as hostname, version(); psql -h 10.10.10.8 -U admin -p 5432 -d teguhth ...

.::: Create External Table PostgreSQL, EDB using Foreign Data Wrapper (postgres_fdw) like DBLink :::.

›
1. create new externaldb for sample create database externaldb; \c externaldb; teguhth=# create database externaldb; CREATE DATABASE teguhth...
Monday, February 19, 2024

.::: Script Backup Full All Database in PostgreSQL EDB :::.

›
corelation with http://teguhth.blogspot.com/2023/08/backup-and-restore-postgresql-edb.html    1. check data from table select * from teguhth...
Saturday, February 17, 2024

.::: Script to Restore Backup Full & all Transaction (Restore Incremental) in one Command for MariaDB MySQL :::.

›
1. check before restore 2. check directory backup & create dblist,txt ls > dblist.txt [root@teguhth teguhth]# ls > dblist.txt [roo...

.::: Restore Transaction Log Backup in MySQL MariaDB :::.

›
  corelation with http://teguhth.blogspot.com/2024/02/script-backup-full-differential.html and http://teguhth.blogspot.com/2023/09/set-up-in...

.::: Script Backup Full + Differential + Transaction Log in MariaDB MySQL & Scheduler just like SQL Server :::.

›
  1. create script backup full [ root@teguhth fix]# cat backup_full_script.sh echo "" Server=$(hostname) ip_address=$(ip a | awk ...
Sunday, February 11, 2024

.::: Create user limited to access only spesific table or specific view, store procedure,function in MSSQL SQL Server :::.

›
  1. create user & password USE [master] GO CREATE LOGIN [onlyone] WITH PASSWORD=N'admin', DEFAULT_DATABASE=[teguhth], CHECK_EXP...