Full Convert – is performant and easy to use database converter
Archive for the ‘PostgreSQL Database’ Category
Spectral Core ‚Full Convert‘ – the easiest way to copy your data to another database
Dienstag, Juli 4th, 2023Patroni Version 2.1.1 – eine Software um ein HA Cluster mit PostgreSQL 13 zu betreiben
Freitag, Oktober 1st, 2021Patroni – 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, 2021Database 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, 2020Database 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, 2020Database 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, 2020Database 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