POSTGRES_IS_RUNNING=$(export PGPASSWORD=${PG_PWD}; psql –host=${MACH_DEST} –port=${PORT} –user=${PG_USER} –dbname=postgres –quiet –tuples-only –no-psqlrc –command « SELECT 1; » 2>/dev/null)INSTANCE_STATUS=$(export PGPASSWORD=${PG_PWD}; psql –host=${MACH_DEST} –port=${PORT} –user=${PG_USER} –dbname=postgres –quiet –tuples-only –no-psqlrc –command= »SELECT CASE pg_is_in_recovery() WHEN true THEN ‘IN. read more…

$PGHOME/bin/vacuumdb –port=$PORT –username=$PG_USER –analyze-only –verbose –jobs=$NB_JOBS $PG_DATABASE » 2>&1

deploy_HA.txt

2 links : JSONB PostgreSQL: How To Store & Index JSON Data (scalegrid.io) PostgreSQL JSON Tutorial (postgresqltutorial.com)

pgbadger -j 4 –outfile $HOME/rapport_complet.html -f stderr -p ‘%t:%r:%u@%d:[%p]:’ /pglog/postgresql-2021-09-10_000000.log

USERNAME :: postgres://<instance>/<role>/user PASSWORD ::postgres://<instance>/<role>/password URL :: jdbc:postgresql://<instance>.<domain>:<port>/<dbname>

    source : https://www.migops.com/blog/2021/07/01/ora2pg-now-supports-oracle_fdw-to-increase-the-data-migration-speed/

WITH RECURSIVE partition_info(relid, relname, relsize, relispartition, relkind)AS (SELECT oid AS relid, relname, pg_relation_size(oid) AS relsize, relispartition, relkind      FROM pg_catalog.pg_class     WHERE relkind = ‘p’ AND relname = ‘mof_ple_part’ — Pour une. read more…

Convert a Standalone to a Patroni Cluster Déployer le cluster PATRONI dans un nouvel environnement

show default_tablespace ;alter system set default_tablespace=’tbs_msg_data’ ;select pg_reload_conf();show default_tablespace show temp_tablespaces ;alter system set temp_tablespaces=’temp’ ;select pg_reload_conf();show temp_tablespaces