https://www.niwi.nz/2013/02/16/replication-status-in-postgresql/ select client_addr, state, sent_location, write_location, flush_location, replay_location from pg_stat_replication; This query can output can be like this: postgres=# select client_addr, state, sent_location,write_location, flush_location, replay_location, sync_priority from pg_stat_replication;
Catégorie : Postgresql
Pg tune et tune
Paramétrer votre architecture Postgres avec PgTune si t’as pas de tune pour payer un expert!! Vous voulez tune votre SGBDR Postgres ! Normal.
Postgresql nouveautés dans chaque version
Bonjour, On me demande de plus en plus d’effectuer des missions en postgres. La question la plus récurrente : Avez vous des expériences en Postgres. Les versions. read more…
Méthode de sauvegarde PostgreSQL – pgBackRest
https://pgstef.github.io/2018/01/04/introduction_to_pgbackrest.html https://fr.slideshare.net/slardiere/pgbackrest-pgdayfr http://laetitia-avrot.blogspot.com/2017/02/faire-une-sauvegarde-avec-pgbackrest.html http://laetitia-avrot.blogspot.com/2017/02/restaurer-avec-pgbackrest.html
Migration Oracle vers Postgres
Issues ora2pg
Quelques commandes bien pratiques
https://wiki.evolix.org/HowtoPostgreSQL
Les Virtual Private Database (VPD) sur PGSQL
Les Virtual Private Database (VPD) sur PGSQL sont disponbiles depuis la version 9.1. source : https://www.enterprisedb.com/blog/virtual-private-database-vpd-ppas-91
Show replication status in PostgreSQL
https://www.niwi.nz/2013/02/16/replication-status-in-postgresql/ select client_addr, state, sent_location, write_location, flush_location, replay_location from pg_stat_replication; This query can output can be like this: postgres=# select client_addr, state, sent_location,write_location, flush_location, replay_location, sync_priority from pg_stat_replication;
Disable Streaming Replication without restarting either master or slave
I understand the way things work currently, but would it not be moreconvenient to let the replication be stopped and started from SQL commandslike: On Master: select pg_pause_streaming_replication(slave_fqdn);select pg_resume_streaming_replication(slave_fqdn); On. read more…
[script] Backup
backup.txt
Lancement de pgAdmin4
(pgadmin4) titi@serveur:~/home-global/virtualenv/myVE/lib/python2.7/site-packages/pgadmin4/pgadmin4/lib/python2.7$ cd /home/titi/home-global/virtualenv/myVE/lib/python2.7/site-packages/pgadmin4/(pgadmin4) titi@serveur:~/home-global/virtualenv/myVE/lib/python2.7/site-packages/pgadmin4$ python pgAdmin4.pypgAdmin 4 – Application Initialisation====================================== The configuration database – ‘/home/titi/.pgadmin/pgadmin4.db’ does not exist.Entering initial setup mode…NOTE: Configuring authentication for SERVER mode. Enter the email. read more…