#!/bin/sh
DOMAIN="<nom_du_domaine>"
DATABASE="postgres"
USERNAME="<userpostgres>"
ECO=<nom_ecosystem>
SERVER=<instance_de_l_ecosystem>
clear
echo "Entrer le nom de l ecosystem (ex:$ECO)"
read $ECO
echo "Entrer le nom de l instance (ex:$SERVER)"
read $SERVER
echo "-- Infos sur l instance :"
echo " "
echo "vault read -ns=$VAULT_NAMESPACE/$ECO database/postgres/$SERVER/config/$SERVER "
echo " "
echo "-- Liste des rôle dynamiques : "
echo " "
echo "vault list -ns=$VAULT_NAMESPACE/$ECO database/postgres/$SERVER/roles "
echo " "
vault list -ns=$VAULT_NAMESPACE/$ECO database/postgres/$SERVER/roles
echo " "
echo "-- Liste des rôle statiques : "
echo " "
echo "vault list -ns=$VAULT_NAMESPACE/$ECO database/postgres/$SERVER/static-roles "
echo " "
vault list -ns=$VAULT_NAMESPACE/$ECO database/postgres/$SERVER/static-roles
echo "-- Informations sur un compte spécifique (dont les SQL de creation et révocation) : "
echo " "
echo "Entrez le nom du role:"
read ROLE
echo "vault read -ns=$VAULT_NAMESPACE/$ECO database/postgres/$SERVER/roles/$ROLE"
echo " "
echo "-- Récupérer les creds d un utilisateur dynamique: "
echo " "
echo "vault read -ns=$VAULT_NAMESPACE/$ECO database/postgres/$SERVER/creds/$ROLE"
echo " "
echo "-- Récupérer les creds d un utilisateur statique: "
echo " "
echo "vault read -ns=$VAULT_NAMESPACE/$ECO database/postgres/$SERVER/static-creds/$ROLE"
echo " "
echo "-- Créer les creds d un utilisateur: "
echo " "
echo "vault write -ns=$VAULT_NAMESPACE/$ECO database/postgres/$SERVER/roles/${ROLE} db_name=${SERVER} creation_statements=@create_dyna_role_OWN.sql revocation_statements=@drop_dyna_role_OWN.sql default_ttl=${ROTATION} max_ttl=${ROTATION} "
echo " "
echo "-- Révoquer un compte avant son TTL : "
echo " "
echo "lease_id database/postgres/$SERVER/creds/OWN_IBMCLOUDDB_SCHEMA1/qdqsdqsdqsdsdqsdqsd.mxxxx"
echo " "
echo "vault lease revoke -ns=$VAULT_NAMESPACE/$ECO database/postgres/$SERVER/creds/$ROLE/qdqsdqsdqsdsdqsdqsd.mxxx "
echo " "
Professionnel - Page 3
-
[Cloud db] liste des commandes vault
-
Applying an incremental backup to a physical standby
https://jarneil.wordpress.com/2008/06/03/applying-an-incremental-backup-to-a-physical-standby/
-
How do you re-duplicate a broken physical standby database?
-
[MSSQL]Kill session
-
MAJ Sequence
sqlplus -s user_admin/<mdp>@BDDREC << EOF > upd_seq.sql
SELECT 'SELECT setval('''||sequence_name||''','||last_number||', true);'
FROM user_sequences;
exit;
EOF
psql --single-transaction -h $2 -U postgres -d $1 -f ./upd_seq.sql -
[Postgres] set un environnement
deux fichiers :
_pg_include
setdb.bash
à adapter selon l'installation du moteur postgres
-
Commenter fichier unix
sudo sed -i -e '/LATIN1/ s/^#/--/' /pgdata/migration/*dev*/*.sql -
[Cloud IBM PSQL] Role creation with HVAULT
Roles creation using hvault :
- dynamic roles
The roles are created with this command :
vault write -ns="$VAULT_NAMESPACE/$ECOSYSTEM" database/postgres/${SERVER}/roles/${ROLE}
db_name=${SERVER}
creation_statements=@${ORA2PG_HOME}/dynamic_role/${TYPE}/create_dyna_role_${TYPE}_${ASSET}.sql
revocation_statements=@${ORA2PG_HOME}/dynamic_role/${TYPE}/drop_dyna_role_${TYPE}_${ASSET}.sql
default_ttl=${ROTATION}
max_ttl=${ROTATION} -
Avoid UUID Version 4 Primary Keys (for Postgres)
-
Pourquoi OEM "cherche" le SPFILE dans ASM
Pourquoi OEM "cherche" le SPFILE dans ASM :