Josselin Joly

Voici la liste des binaires qui permettent d’administrer Postgresql:   [postgres@localhost bin]$ ls pg*pg_archivecleanup  pg_controldata  pg_isready      pg_restore      pg_upgradepg_basebackup      pg_ctl          pg_receivexlog  pg_rewind       pg_xlogdumppgbench            pg_dump         pg_recvlogical  pg_test_fsyncpg_config          pg_dumpall      pg_resetxlog    pg_test_timing    . read more…

1-Télécharger Postgresql 2- Le dé-tarer, puis taper les commandes suivantes : ./configuremake sumake installadduser postgresmkdir /usr/local/pgsql/datachown postgres /usr/local/pgsql/datasu – postgres/usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data/usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data >logfile 2>&1 &/usr/local/pgsql/bin/createdb test/usr/local/pgsql/bin/psql test

Pour vérifier la réplication sur postgresql il faut utiliser la commande :    bench#select pg_xlog_location_diff(pg_last_xlog_receive_location(),pg_last_xlog_replay_location());   source :  50ième minute 

2016-02-22: pgbouncer-1.7.1-1.rhel7 2016-02-22: pgbouncer-debuginfo-1.7.1-1.rhel7 2016-02-22: pgbadger-8.0-1.rhel7 2016-02-19: postgresql95-python-4.2-1PGDG.rhel7 2016-02-19: postgresql95-python-debuginfo-4.2-1PGDG.rhel7 2016-02-19: orafce95-3.2.1-1.rhel7 2016-02-19: orafce95-debuginfo-3.2.1-1.rhel7 2016-02-19: pgadmin3_95-1.22.1-1.rhel7 2016-02-19: pgadmin3_95-debuginfo-1.22.1-1.rhel7 2016-02-19: pgadmin3_95-docs-1.22.1-1.rhel7 2016-02-16: pg_repack95-1.3.3-1.rhel7 2016-02-16: pg_repack95-debuginfo-1.3.3-1.rhel7 2016-02-16: repmgr95-3.0.3-2.rhel7 2016-02-16: repmgr95-debuginfo-3.0.3-2.rhel7 2016-02-16: postgresql-jdbc-9.4.1207-3.rhel7. read more…