Infrastructure at your Service

All Posts By

Furkan Suv

Furkan Suv

Starting with PostgreSQL

By | Database management, Postgres | No Comments

In this Post you will learn how I met PostgreSQL and started to learn. If you are planning PostgreSQL as your database but don’t know where to start, this blog may help you. My background I have used MySQL database like an external hard drive, just to save and store the data from an application. Several times I installed on CentOS/Ubuntu from the repository. Mostly I used preinstalled MySQL databases from webhosting providers. On the…

Read More
Furkan Suv

Build API backend server with NodeJS and PostgreSQL

By | Postgres | No Comments

Introduction In this Blog I will describe how to create an API Backend with NodeJS using PostgreSQL as Database. We will create API for public events with CRUD options. CRUD means: create, read, update and delete. Firstly, we will create our PostgreSQL Tables and history tables. And then we will continue with NodeJS. If you don’t have PostgreSQL installed yet, please follow these steps in our Blog. As alternative you can also follow the steps…

Read More
Furkan Suv

SELinux for beginners

By | Operation systems, Security | No Comments

Do you know the following situation: You are following a step by step tutorial on the web and on your environment does not work as expected because of SELinux. Your looking on search engines command how you can disable the SELinux… Does that sound familiar? On this Blog I will explain what SELinux are, where and how to use is. Let’s start! What is SELinux and why should I not disable it? SE stands for…

Read More
Furkan Suv

Configure PostgreSQL to allow remote connection

By | Database Administration & Monitoring | No Comments

By default, PostgreSQL will only allow localhost connection. If you want allow remote connections, you need to configure it. Configuring postgresql.conf First we need to find out where our conf file is located. You have two options: If you are new to Postgres, you would like to use the classic ‘find’ command: find / -name “postgresql.conf” And the Pro users would be use: psql -c “show config_file” postgres config_file After you find the location of…

Read More
Furkan Suv

How to prepare for the SLES 15 Admin certification.

By | Operation systems | No Comments

My Background Since I started at dbi services sa (before 3 Weeks), I was working and preparing for the SUSE Linux Enterprise 15 certification. I had worked with other Linux distributions like CentOS, Ubuntu and Debian on my old employer. With my basic Linux knowledge I was able to administrate Apache and nginx with virtual hosts, SSL Encryption with Let’s Encrypt, installing and configuring MySQL Database, opening/closing ports for services with firewall-cmd, network configuration and…

Read More