$PGHOME/bin/vacuumdb –port=$PORT –username=$PG_USER –analyze-only –verbose –jobs=$NB_JOBS $PG_DATABASE » 2>&1
Josselin Joly
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. read more…
DEPLOY HA postgres
deploy_HA.txt
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 » >. read more…
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. read more…
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/
Translate »