Archive for the ‘PostgreSQL Database’ Category

Patroni Version 2.1.1 – eine Software um ein HA Cluster mit PostgreSQL 13 zu betreiben

Freitag, Oktober 1st, 2021

Patroni – is a high availability solution for PostgreSQL developed by Zalando to manage hundreds of databases in the cloud as well as in traditional data centers. It implements automatic failover and works together with Etcd Zookeeper or Consul to store and retrieve PostgreSQL cluster information in a consistent way and ensure there is only one leader at a time avoiding split-brains

Zabbix 5.4 – PostgreSQL Database Monitoring

Mittwoch, September 1st, 2021

Database PostgreSQL 14 beta – verbessert die parallele Verarbeitung

Samstag, Mai 22nd, 2021

PostgreSQL – how replication works

Dienstag, Januar 26th, 2021

   PostgreSQL – how replication works

PostgreSQL 13.1, 12.5, 11.10, 10.15, 9.6.20 and 9.5.24 – update as soon as possible

Dienstag, November 24th, 2020

Database PostgreSQL 13 – released

Freitag, November 6th, 2020

  Database PostgreSQL 13 – includes significant improvements to its indexing and lookup system that benefit large databases including space savings and performance gains for indexes faster response times for queries that use aggregates or partitions better query planning when using enhanced statistics and more

TimescaleDB – performant time-series data management and analytics with PostgreSQL

Dienstag, Oktober 20th, 2020

Database PostgreSQL Write Ahead Log (WAL) – is the record of changes/activities on the Primary side and can be considered as a journal/ledger of the changes happening in the database

Freitag, September 4th, 2020

Zabbix 5.0 LTS – download and install on OS Raspbian with PostgreSQL and NGINX

Donnerstag, September 3rd, 2020

# wget
# dpkg -i zabbix-release_5.0-1+buster_all.deb
# apt update
# apt install zabbix-server-pgsql zabbix-frontend-php php7.3-pgsql zabbix-nginx-conf zabbix-agent


# apt install postgresql postgresql-contrib
# sudo -u postgres createuser –pwprompt zabbix
# sudo -u postgres createdb -O zabbix zabbix
# zcat /usr/share/doc/zabbix-server-pgsql*/create.sql.gz | sudo -u zabbix psql zabbix
Edit file /etc/zabbix/zabbix_server.conf
Edit file /etc/zabbix/nginx.conf, uncomment and set ‚listen‘ and ’server_name‘ directives.
listen 80;
server_name rpi-iot-jsho-zabbix-01;
Edit file /etc/zabbix/php-fpm.conf, uncomment and set the right timezone for you.
php_value[date.timezone] = Europe/Berlin
# systemctl restart zabbix-server zabbix-agent nginx php7.3-fpm
# systemctl enable zabbix-server zabbix-agent nginx php7.3-fpm

Database PostgreSQL – Installation mit den Community Packages

Mittwoch, September 2nd, 2020

  Database PostgreSQL – wie installiert man sinnvoll PostgreSQL aus den Community Packages und zwar so dass Upgrades auf neue Versionen keine unlösbare Aufgabe werden

Docker Official Image ‚PostgreSQL‘ – an object-relational database system provides reliability and data integrity

Mittwoch, August 26th, 2020

  Docker Official Image ‚PostgreSQL‘ – often simply „Postgres“ is an object-relational database management system (ORDBMS) with an emphasis on extensibility and standards-compliance. As a database server, its primary function is to store data, securely and supporting best practices, and retrieve it later, as requested by other software applications, be it those on the same computer or those running on another computer across a network

Database PostgreSQL – the world’s most advanced Open Source Relational Database

Dienstag, Juli 28th, 2020

Database PostgreSQL – comes with many features aimed to help developers build applications, administrators to protect data integrity and build fault-tolerant environments, and help you manage your data no matter how big or small the dataset