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 . read more…
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.
select sch.nspname as schemaname, tab.relname as tablename, col.attname as columnname, col.attnum as columnnumber, col.atttypid, typ.typname as columntypefrom pg_attribute coljoin pg_type. read more…
PostgreSQL around the world PostgreSQL 16 is out. https://www.postgresql.org/docs/16/release-16.html Digging into PostgreSQL iceberg https://avestura.dev/blog/explaining-the-postgres-meme PostgreSQL partitioning https://www.timescale.com/blog/when-to-consider-postgres-partitioning/ Who does PostgreSQL https://momjian.us/main/blogs/pgblog/2023.html#September_11_2023
There is some new about PostgreSQL world. Some useful tricks and tips about PostgreSQL, like how to get unused index list (but so many more like displaying fun smiley. read more…
Catégorie : Postgresql
[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 . read more…
[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.
[PostgreSQL]tables sans oid en big serial
select sch.nspname as schemaname, tab.relname as tablename, col.attname as columnname, col.attnum as columnnumber, col.atttypid, typ.typname as columntypefrom pg_attribute coljoin pg_type. read more…
[PostgreSQL] Find all the table and index size
SELECT TableName ,pg_size_pretty(pg_table_size(TableName)) AS TableSize ,pg_size_pretty(pg_indexes_size(TableName)) AS IndexSize ,pg_size_pretty(pg_total_relation_size(TableName)) AS TotalSize FROM ( SELECT (‘ »‘ || table_schema || ‘ ». »‘ || table_name || ‘ »‘) AS TableName FROM information_schema.tables ) AS Tables. read more…
[PostgreSQL] Streaming Replication Monitoring Script
Script de création d’une fonction « streaming_slave_check » pour la réplication en postgreSQL.
[PostgreSQL] repmgr tuto
Tutoriel d’installation pour repgmr
[PostgreSQL] Anonymisation des données
Procédure d’anonymisation des données
PostgreSQL Un tour d’horizon !
PostgreSQL around the world PostgreSQL 16 is out. https://www.postgresql.org/docs/16/release-16.html Digging into PostgreSQL iceberg https://avestura.dev/blog/explaining-the-postgres-meme PostgreSQL partitioning https://www.timescale.com/blog/when-to-consider-postgres-partitioning/ Who does PostgreSQL https://momjian.us/main/blogs/pgblog/2023.html#September_11_2023
[Postgres] NEWS
There is some new about PostgreSQL world. Some useful tricks and tips about PostgreSQL, like how to get unused index list (but so many more like displaying fun smiley. read more…
POSTGRES Backup / restore
Petites bases : #backup -C : ajouter le create database. pg_dump -d $DB > $DB.sql#restorepsql < $DB.sql Grosses bases : #backupon exporte la structure : pg_dump -s $DB> $DBstruct.sql. read more…