postgresql
-
On tire la chasse et on nettoie ?
-
Installer Postgresql
1-Télécharger Postgresql
2- Le dé-tarer, puis taper les commandes suivantes :
./configure
makesu
make install
adduser postgres
mkdir /usr/local/pgsql/data
chown postgres /usr/local/pgsql/data
su - 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 -
Réplication PostGresql
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
-
RPM Postgresql
- 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
- 2016-02-16: postgresql-jdbc-javadoc-9.4.1207-3.rhel7
- 2016-02-11: pg_bulkload95-3.1.9-1.rhel7
- 2016-02-11: pg_bulkload95-debuginfo-3.1.9-1.rhel7
- 2016-02-11: pam-pgsql95-0.7.3.2-1.rhel7
- 2016-02-11: pam-pgsql95-debuginfo-0.7.3.2-1.rhel7
- 2016-02-11: pguri95-1.20151224-1.rhel7
- 2016-02-11: pguri95-debuginfo-1.20151224-1.rhel7
- 2016-02-11: pgcenter-0.2.0-1.rhel7
- 2016-02-11: pgcenter-debuginfo-0.2.0-1.rhel7
- 2016-02-11: pg_track_settings95-1.0.0-2.rhel7
- 2016-02-11: tds_fdw95-1.0.7-1.rhel7
- 2016-02-11: tds_fdw95-debuginfo-1.0.7-1.rhel7
- 2016-02-11: powa_95-3.0.1-1.rhel7
- 2016-02-11: powa_95-web-3.0.1-1.rhel7
- 2016-02-11: plpgsql_check_95-1.0.4-1.rhel7