Archive for the ‘PostgreSQL Database’ Category

PostgreSQL 13.1, 12.5, 11.10, 10.15, 9.6.20 and 9.5.24 – to 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 https://repo.zabbix.com/zabbix/5.0/raspbian/pool/main/z/zabbix-release/zabbix-release_5.0-1+buster_all.deb
# 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
DBPassword=<password>
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
http://rpi-iot-jsho-zabbix-01/setup.php

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