Auteur/autrice : admin
-
Detecting inline, inline-compressed and TOAST storage
Detecting inline, inline-compressed and TOAST storage +–+————–+——————+———-+———–+————-+ |id|full_name |uncompressed_bytes|compressed|out_of_line|bytes_on_disk| +–+————–+——————+———-+———–+————-+ |1 |joe toast |4004 |false |true |4000 | |2 |joe compressed|3000 |true |false |44 | |3 |joe inline |10 |false […]
-
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.