Paramétrer votre architecture Postgres avec PgTune si t’as pas de tune pour payer un expert!!   Vous voulez tune votre SGBDR Postgres ! Normal.

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 […]

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

    Issues ora2pg

https://wiki.evolix.org/HowtoPostgreSQL

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

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;

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 […]

backup.txt

(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 […]