Auteur/autrice : Josselin Joly
-
Deploy new postgreSQL instance dMZR
Deploy new postgreSQL instance dMZR #!/bin/sh#set -excd $ORA2PG_HOME/hvaultwhile truedoif [ « $# » -eq « 0 » ] thenclearecho » « echo » Welcome to the program of a new deployment in <cloudDBname> – dMZR »echo […]
-
Modifier l’encodage PostgreSQL en UTF8
How to change PostgreSQL database encoding to UTF8 (shubhamdipt.com)
-
PostgreSQL bonnes pratiques
Restriction du schéma « public »Définir des nouveaux tablespaces pour les données et indexes et temp et changer le nom du tablespace par défaut (data et temp) Exporter les […]
-
[HVAULT] Roles postgreSQL
Script de création des roles HVAULT dans ibm cloud pour postgreSQL (dMZR); #!/bin/sh#-ex#set -xwhile truedoclear if [[ « $VAULT_ADDR » == <adresse de prod>]] then […]
-
[PostgreSQL] Ora2pg Install
yum install oracle-instantclient12.2-basic-12.2.0.1.0-1.x86_64.rpmyum install oracle-instantclient12.2-devel-12.2.0.1.0-1.x86_64.rpmyum install oracle-instantclient12.2-jdbc-12.2.0.1.0-1.x86_64.rpmyum install oracle-instantclient12.2-sqlplus-12.2.0.1.0-1.x86_64.rpmyum -y install perl-DBIyum install gccyum install glibc-develyum install perl-ExtUtils-MakeMaker -yyum install perl-open.noarch -y export ORACLE_HOME=/usr/lib/oracle/12.2/client64export LD_LIBRARY_PATH=/usr/lib/oracle/12.2/client64/libtar -xvzf ora2pg-23.0.tar.gzcd ora2pg-23.0/perl Makefile.PLmake && […]
-
[Oracle]Top shell script pour monitoring BDD
Top DBA Shell Scripts for Monitoring the Database – BMC Software | Blogs
-
[PostgreSQL] restore de blobs
SELECT lo_unlink(oid) FROM pg_largeobject_metadata;WARNING: out of shared memoryERROR: out of shared memoryHINT: You might need to increase max_locks_per_transaction.
-
[Systeme] Create a logical volume for ora2pg
Create a logical volume of 450 Go volume group : vg_appslogical volume : lv_ora2pgmigFS : /dev/mapper/vg_apps-lv_ora2pgmigMounted on : /apps/ora2pg/migrationlvcreate -L 450G -n lv_ora2pgmig vg_apps mkfs.ext4 /dev/mapper/vg_apps-lv_ora2pgmigmkdir -p /apps/ora2pg/migrationmount /dev/mapper/vg_apps-lv_ora2pgmig /apps/ora2pg/migration
