[Postgres] set un environnement

deux fichiers :

_pg_include  

setdb.bash            

 

à adapter selon l'installation du moteur postgres

 

[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)

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

Migration de sqlserver vers postgresql

Un bon guide à suivreHow to Convert SQL Server to PostgreSQL – Complete Migration Guide.PDF

https://dbconvert.com/blog/sql-server-to-postgresql-migration-guide/

EDB feedback

Article intéressant sur le 0 downtime des cartes mastercard.

[Cloud IBM PSQL] Role creation with HVAULT (static dba)

script : prepare_dba_static_role.sh

 

[PSQL] Autovacuum PostgreSQL on AZURE

Comment configurer l'autovacuum de manière agressive afin qu'il soit plus performant sur postgresql flexible server dans Azure ?

[PSQL] Que contient les fichiers wal

Un bon tuto à faire !

What’s Inside a WAL File

[PSQL] 5 biggest tables

SELECT relname AS "relation", pg_size_pretty ( pg_total_relation_size (C .oid) ) AS "total_size" FROM pg_class C LEFT JOIN pg_namespace N ON (N.oid = C .relnamespace) WHERE nspname NOT IN ( 'pg_catalog', 'information_schema' ) AND C .relkind <> 'i' AND nspname !~ '^pg_toast' ORDER BY pg_total_relation_size (C .oid) DESC LIMIT 5;

[ISSUE]PostgreSQL: Permission denied for large object

PostgreSQL: Permission denied for large object