Wednesday, August 30, 2023

.::: Upgrade PostgreSQL from 14 to 15 on CentOS 7 :::.

›
1. chek version before upgrade SELECT version(); select pg_read_file('/etc/hostname') as hostname, version();   2. backup all su - p...
Tuesday, August 29, 2023

.::: Check Database Size and Table Size in PostgreSQL , EDB, YugeByte :::.

›
 1. Check size db Postgresql SELECT pg_database.datname, pg_database_size(pg_database.datname) AS DBSizeB, pg_database_size(pg_database.datn...

.::: How to Check MySQL MariaDB Database Size, Total All Size Database And Table Size, Uptime Time, Create Time Tablem size Index :::.

›
    1. type table SELECT @@hostname as ServerName,     table_schema,     table_name,     table_type,     row_format,     table_rows FROM    ...
Friday, August 25, 2023

::: Backup & Restore MariaDB MySQL using bat Script in windows :::.

›
1. run script fullbackup Full_backup_mariadb.bat 2. run script transaksi log back_log_mariadb_windows.bat 3. result    
Tuesday, August 22, 2023

.:::How to Check Disk Type SSD in Linux & Windows :::.

›
A. Check Disk Type in Windows you can also use the Command Prompt to check whether you have an SSD or an HDD in Windows 11. Here's how y...
Wednesday, August 16, 2023

.::: Query Script Backup Full & Transaction Log WAL Shipping PostgreSQL, EDB :::.

›
  1. run script full backup sh full_backup_edb.sh -bash-4.2$ cd /var/lib/pgsql/14/edb/ -bash-4.2$ ls full  full_backup_edb.sh  wal_backup_ed...
Thursday, August 10, 2023

.::: Shell Script to Get CPU Memory Usage (%), Swap (%) & Local Check, all_check GTID Mirroring,IP & Hostname,uptime MariaDB in Unix, Linux & Solaris 10 from Local & Remote :::.

›
A. From Local    1. create script to create cpu memory [root@teguhth ~]# cat check_cpu_mem_usage.sh #!/bin/bash # Get CPU and Memory usage u...
Tuesday, August 8, 2023

.::: Microsoft Script Bat : Create Store Procedure Simple Calculator :::.

›
  1. create Simple_Calculator.sh @echo off echo Simple Calculator set /p "num1=Enter first number: " set /p "num2=Enter secon...

.::: Linux Unix Shell Script : Create Store Procedure Simple Calculator :::.

›
 1. create Simple_Calculator.sh [root@teguhth data]# cat Simple_Calculator.sh #!/bin/bash echo "Simple Calculator" echo "Ente...

.::: PostgreSQL EDB : Create Store Procedure Simple Calculator :::.

›
  1. Create simple calculator CREATE OR REPLACE FUNCTION Sp_SimpleCalculator(     num1 NUMERIC,     num2 NUMERIC,     operator CHAR(1) ) RET...
Monday, August 7, 2023

.::: MariaDB MySQL : Create Store Procedure Simple Calculator :::.

›
  1. Create store procedure DELIMITER // CREATE PROCEDURE Sp_SimpleCalculator(     IN num1 DECIMAL(10, 2),     IN num2 DECIMAL(10, 2),     I...

.::: Create Script Backup Database Full, Differential & Log Using T-SQL & Run using CMD SQL Server :::.

›
1. Create Script Backup Full > sp_backup_full CREATE procedure [dbo].[sp_backup_full] as begin DECLARE @BackupPath NVARCHAR(255); DECLARE...

.::: MSSQL: Create Store Procedure Simple Calculator :::.

›
1. Create store procedure Sp_Simple_Calculator CREATE PROCEDURE Sp_Simple_Calculator     @Num1 decimal,     @Num2 decimal AS BEGIN     SELEC...