https://orahow.com/enable-disable-archive-mode-in-postgres/ Steps to Enable WAL Archiving in Postgres STEP 1: Verify archive mode is enabled or not using below command. postgres=# show archive_mode; archive_mode ————– off (1 row) postgres=# […]

#se connecter au serveur targetpsql -U <muyser>CREATE EXTENSION oracle_fdw;dewCREATE SERVER orasrv FOREIGN DATA WRAPPER oracle_fdw (dbserver ‘<servername>:<port>/<SID>’);des+GRANT USAGE ON FOREIGN SERVER orasrv TO <muyser>;CREATE USER MAPPING FOR <muyser> SERVER orasrv […]

PostgreSQL – vacuumdb – vacuumdb — ramasse les ordures et analyse une base de données PostgreSQL Synopsi – Français (runebook.dev)

for tablename in $(psql -U postgres -h $2 -d $1 -t -c « select table_name as _table from information_schema.tables t where t.table_schema=’sche_admin’ order by _table asc »); do   echo $tablename   […]

Backup From a Standby | pgBackRest (pmatseykanets.github.io)

On master: select * from pg_stat_replication; On replica (streaming replication in my case): select * from pg_stat_wal_receiver; On your master, pg_stat_replication provides data about ongoing replication: select client_addr, state, sent_location, write_location, […]

Detecting inline, inline-compressed and TOAST storage +–+————–+——————+———-+———–+————-+ |id|full_name |uncompressed_bytes|compressed|out_of_line|bytes_on_disk| +–+————–+——————+———-+———–+————-+ |1 |joe toast |4004 |false |true |4000 | |2 |joe compressed|3000 |true |false |44 | |3 |joe inline |10 |false […]

How to change PostgreSQL database encoding to UTF8 (shubhamdipt.com)  

Restriction du schéma « public »Définir des nouveaux tablespaces pour les données et indexes et temp et changer le nom du tablespace par défaut (data et temp)   Exporter les […]