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. read more…
Josselin Joly
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. read more…
[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. read more…
[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=#. read more…
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. read more…
[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. read more…
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 . read more…
[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,. read more…
Translate »