Benson Yerima

DATABASE PROBLEMS AND SOLUTIONS, LEARNING DOCS AND VIDEOS

  • twitter
  • facebook
  • google+
  • Home
  • About
  • HOW-TO
  • NEWS
  • Contact

Category - HOW-TO

  • HOW-TO

Custom Postgres Installation

by bensonyerima

Installing postgres in a non- default directory is something which lots of poeple/comapanies want to acomplish. In this demo, i will showing four different ways which you could achive this in your environment. Which ever way...

Continue reading

  • HOW-TO

BARMAN EXPLANATION AND CONFIGURATION WITH POSTGRES

by bensonyerima

Barman (Backup and Recovery Manager) is an open-source administration tool for disaster recovery of PostgreSQL servers written in Python. It allows your organisation to perform remote backups of multiple servers in business...

Continue reading

  • HOW-TO

Kerberos Authentication Setup With Postgres On Linux

by bensonyerima

According to myth, Kerberos (you might know him as Cerberus) guards the Gates to the Underworld. He’s a big 3 headed dog with a snake for a tail and a really bad temper. In the modern world, MIT Computer Scientists used the...

Continue reading

  • HOW-TO

LDAP/TLS, Pgbouncer With PAM Authentication

by bensonyerima

This blog is kind of a continuation of the configuration i did earlier with LDAP/TLS. I have come across configuration requirements which require pgbouncer to use PAM authentication with LDAP. Now by default, pgbouncer does...

Continue reading

  • HOW-TO

Setup and Monitoring SQL Server AG with IDERA

by bensonyerima

This Bog is just to give a follow-up on the previous demo I did on the installation of sql server always On. This just shows us how to monitor the previous environment which i setup using IDERA. you can read more about it...

Continue reading

  • HOW-TO

Always On availability groups- Step by Step video demo

by bensonyerima

The Always On availability groups feature is a high-availability and disaster-recovery solution that provides an enterprise-level alternative to database mirroring. Introduced in SQL Server 2012 (11.x), Always On availability...

Continue reading

  • HOW-TO

LDAP/TLS Configuration in Linux With PostgreSQL

by bensonyerima

By default, LDAP communications between client and server applications are not encrypted. This means that it is possible to use a network monitoring device or software and view the communications between LDAP client and server...

Continue reading

  • HOW-TO

EFM AND PGPOOL INTEGRATION FOR HA

by bensonyerima

Obtaining high availability in any infrastructure setup is very important. Thanks to the pgpool and EDB EFM team who make this possible. I will not go deep into explaining what is EFM or pgpool. What i intended to archived...

Continue reading

  • HOW-TO

CREATING DATABASE LINK FROM ORACLE TO POSTGRES

by bensonyerima

Sometimes there are needs to fetch data from other different RDBMS. Working with postgres, its easy to establish a database connection to oracle but the other round can involved a lot of steps to create a database from the...

Continue reading

  • HOW-TO

MIGRATION FROM MYSQL TO EDB POSTGRES USING MTK

by bensonyerima

MySQL is an open-source relational database management system. MySQL Database Service is a fully managed database service to deploy cloud-native applications using the world’s most popular open source database. In...

Continue reading

1 2 Next

Recent Posts

  • Configuring Openldap for authentication in postgres on ubuntu
  • Configuring Windows Active Directory LDAP For Authentication With Postgres On Linux.
  • Configuring pg_auto_failover
  • PGBOUNCER SERVER/CLIENT TLS CONFIGURATION
  • Installation, setup and HA on mongo dB

Recent Comments

  • DT68 on CONFIGURING SSL AUTHENTIFICATION
  • OLanefrots on Custom Postgres Installation
  • Girne eğlence mekanları on MIGRATION FROM MYSQL TO EDB POSTGRES USING MTK
  • FobertNub on Custom Postgres Installation
  • open a binance account on PGCOMPACTTABLE DEMO

BLOG DOCUMENTS

I have had some request to also provide a link to download the actual documents in this blog.

Below is a link to my share drive to access some of the documents in this blog.

Please if you need any doc, please contact me for a password to access the share drive.

info@bensonyerima.com

Copyright © 2025. Created by Meks. Powered by WordPress.
  • Home
  • About
  • HOW-TO
  • NEWS
  • Contact
  • Home
  • About
  • HOW-TO
  • NEWS
  • Contact
  • twitter
  • facebook
  • google+