[MSSQL]Kill session

kill_session_mssql.pdf

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}

Fonctionnalités cachés

https://www.phonandroid.com/windows-11-la-derniere-mise-a-jour-apporte-des-fonctionnalites-cachees-voici-comme-les-activer.html

Avoid UUID Version 4 Primary Keys (for Postgres)

Avoid UUID Version 4 Primary Keys (for Postgres) | Software Engineer, Author, High Performance PostgreSQL for Rails