Auteur/autrice : admin
-
Calcul de stats postgreSQL
$PGHOME/bin/vacuumdb –port=$PORT –username=$PG_USER –analyze-only –verbose –jobs=$NB_JOBS $PG_DATABASE » 2>&1
-
Ora2PG script creation project
#!/bin/sh#——————————————————————————-## Script to create an ora2pg project# Author : JJY##——————————————————————————-#set -vxclearecho » « echo » Welcome in the program to create a migration project. « echo » « echo » Write the working […]
-
About JSON in RDBMS
2 links : JSONB PostgreSQL: How To Store & Index JSON Data (scalegrid.io) PostgreSQL JSON Tutorial (postgresqltutorial.com)
-
Désactiver le mode visual sur VI
J’ai remarqué un truc bien chiant sur les nouvelles VM linux : le clic droit de la souris ne peut plus coller…! pour y remédier : echo « set compatible » > […]
-
PG_BADGER
pgbadger -j 4 –outfile $HOME/rapport_complet.html -f stderr -p ‘%t:%r:%u@%d:[%p]:’ /pglog/postgresql-2021-09-10_000000.log
-
Configuration application cloud postgres
USERNAME :: postgres://<instance>/<role>/user PASSWORD ::postgres://<instance>/<role>/password URL :: jdbc:postgresql://<instance>.<domain>:<port>/<dbname>
-
[ora2pg script] Data and metadata export (multiple schemas)
#!/bin/sh#——————————————————————————-## Created by joguess the Oracle database admin, version 2022##——————————————————————————-#data exportEXPORT_TYPE= »COPY »SCHEMA= »TITI TOTO TATA »namespace= ». »for etype in $(echo $EXPORT_TYPE | tr » » « n »)do for eschema in $(echo $SCHEMA […]
-
Service HAS
Faire repartir le service HAS. Nettoyage : /grid/oracle/product/19.0/bin/crsctl stop has -f Faire repartir : /grid/oracle/product/19.0/bin/crsctl start has
-
Ora2PG now supports oracle_fdw to increase the data migration speed
source : https://www.migops.com/blog/2021/07/01/ora2pg-now-supports-oracle_fdw-to-increase-the-data-migration-speed/