Auteur/autrice : admin
-
Assessment ora2pg
Assessment ora2pg : ora2pg -t SHOW_REPORT -c ./config/ora2pg.conf –dump_as_html –cost_unit_value 5 –estimate_cost > ./reports/report.htmlora2pg -t SHOW_TABLE -c ./config/ora2pg.conf > ./reports/tables.txtora2pg -t SHOW_COLUMN -c ./config/ora2pg.conf > ./reports/columns.txt Compare source VS target ora2pg […]
-
Tuning ora2pg
On peut gagner du temps : 1-Si on purge 2-Si on exclut les tables vides 3-Si on calcule les stats 4-Si on ajoute de la mémoire chez Oracle 5-Si on […]
-
[PostgreSQL] Privilèges
Privs useful to any new user created. create user « <user> » password ‘<PWD>’;GRANT USAGE ON SCHEMA <SCHEMA> TO <user>;GRANT SELECT,UPDATE,INSERT,DELETE ON ALL TABLES IN SCHEMA <SCHEMA> TO <user>;GRANT USAGE ON ALL […]
-
[Postgres] How to Enable / Disable Archive Mode
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=# […]
-
L’extension oracle_fdw
#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 […]
-
[ora2pg] Assessment
To be able to say “Yeah, we migrate to PostgreSQL”, we have to be confident by studying the technical aspects of it. For that, we assess the feasibility of the […]
-
On tire la chasse et on nettoie ?
PostgreSQL – vacuumdb – vacuumdb — ramasse les ordures et analyse une base de données PostgreSQL Synopsi – Français (runebook.dev)
-
Calcul stats PostgreSQL
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 […]
-
[PostgreSQL] pgBackRest sauvegarder la standby
Backup From a Standby | pgBackRest (pmatseykanets.github.io)
-
[PostgreSQL] Vérifier le statut de la réplication
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, […]