Deploy new postgreSQL instance dMZR
Deploy new postgreSQL instance dMZR
Expertise en SGBDR - Page 12
-
-
Modifier l'encodage PostgreSQL en UTF8
How to change PostgreSQL database encoding to UTF8 (shubhamdipt.com)
-
Running Health Checks Manually
-
Installation Oracle19c
-
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) -
[HVAULT] Roles postgreSQL
Script de création des roles HVAULT dans ibm cloud pour postgreSQL (dMZR);
-
[PostgreSQL] Ora2pg Install
yum install oracle-instantclient12.2-basic-12.2.0.1.0-1.x86_64.rpm
yum install oracle-instantclient12.2-devel-12.2.0.1.0-1.x86_64.rpm
yum install oracle-instantclient12.2-jdbc-12.2.0.1.0-1.x86_64.rpm
yum install oracle-instantclient12.2-sqlplus-12.2.0.1.0-1.x86_64.rpm
yum -y install perl-DBI
yum install gcc
yum install glibc-devel
yum install perl-ExtUtils-MakeMaker -y
yum install perl-open.noarch -y
export ORACLE_HOME=/usr/lib/oracle/12.2/client64
export LD_LIBRARY_PATH=/usr/lib/oracle/12.2/client64/lib
tar -xvzf ora2pg-23.0.tar.gz
cd ora2pg-23.0/
perl Makefile.PL
make && make install
tar -xvzf DBD-Oracle-1.83.tar.gz
cd DBD-Oracle-1.83
perl Makefile.PL
make && make install -
[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 memory
ERROR: out of shared memory
HINT: You might need to increase max_locks_per_transaction. -
[Systeme] Create a logical volume for ora2pg
Create a logical volume of 450 Go