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 […]
-
[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 […]
-
[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 […]
-
[PostgreSQL] Streaming Replication Monitoring Script
Script de création d’une fonction « streaming_slave_check » pour la réplication en postgreSQL.
-
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 […]
-
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 […]
