PostgreSQL

Hello, I will tell you about restore and restore delta on pgbackrest. The normal restore command returns to the data path you specified. Restore –delta, on the other hand, restores …

Hello, I will create postgres_fdw and explain data transfer.   First of all, we create EXTENSION, the name of which we determine ourselves. CREATE EXTENSION test;   We are creating …

Hello, I will explain postgreSQL installation on docker we find the postgreSQL packages with the following command docker search postgresql After we list the postgres packages, we select the version …

Hello, I will explain pgmaster postgresql version update on docker 1-similar file is uploaded to /tmp directory of the related server with scp and ftp postgresql-12.x.xx.image.tar.gz 2-Bash shell login on …

Hello friends, today I will tell you how to install haproxy and keepalived. yum install haproxy keepalived -y The parameter file in the service must be confirmed cat /usr/lib/systemd/system/haproxy.service [Unit] …

Hello, today I will explain the installation of high availability patroni. 1-PostgreSQL software installation 2-Patroni software installation 3-etcd software installation, etcd conf. 4-patroni conf. 5-pgbackrest setup and conf. 6-haproxy and …

Hello today i will tell you how to install PgBackRest Before reading this article, make sure you have set your ssh settings. This post was written for PostgreSQL 11 and …

Hello friends today Pgbackrest restore time target cat /etc/pgbackrest.conf pgbackrest info pgbackrest archive-get –stanza=test After doing the pre-run checks, we should get the –stanza name from pgbackrest.conf. In addition, before …

Hello there , change PostgreSql database encoding Rename database with old encoding alter database test RENAME to test_old; Create database with new encoding CREATE DATABASE test ENCODING=’UTF-8′ LC_COLLATE = ‘tr_TR.UTF-8′ …

Hello, I will explain how to install postgresql 12 on Centos 7. And how to create postgresql database is explained below. —————-postgresql single instace installations————————- repo package #yum install centos-release-scl-rh …