Category: Linux

15 Oct by Faruk Erdem

How To Install PostgreSQL On centos/redhat

After selecting the operating system from the link below, you can copy the link starting with yum install. Then you should connect the centos/redhat with ssh and paste this selected code for installation. https://www.postgresql.org/download/linux/redhat/   Example code: [crayon-5bf18c7d206eb340915405/]   After running the above script, you will have installed the repo named /etc/yum.repos.d pgdp-10-centos. After the […]
13 Oct by dbtut

How To Connect To Oracle On Linux and Solution Of The Error:” error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory”

In this article, I will share the necessary steps to connect to Oracle through the linux operating system and the solutions to the problems we face.   First, we connect to the linux server with ssh as root.   Then, with the help of the following command, we ask where sqlplus is.   [crayon-5bf18c7d20a2f267019850/]   […]
4 Oct by Faruk Erdem

Running an Operating System Command while Connected to Postgres

You are processing in psql, but you need to look at something on the operating system side, so you must exit from the psql and connect to Psql again. But with the command “\!”, you can run the operating system command without exiting psql. The use is as follows. [crayon-5bf18c7d2103e804436609/]    
1 Oct by Mikael HOUNDEGNON

How to Catch Ctrl-C in Shell Script

To trap Ctrl-C in a shell script, we will need to use the trap shell builtin command. When a user sends a Ctrl-C interrupt signal, the signal SIGINT (Signal number 2) is sent. Let’s see how we can trap this signal in a shell script #!/bin/sh # this function is called when Ctrl-C is sent […]
31 Aug by Rey Wang Tags:

EMC flash drive as Temp database device

Here is an unusual data warehouse (columnar, not row based) server; I have several very large fact tables, some of them are over 800GB size. Total DB size is way over 25TB, and we run very bizarre over 20 table joins, outer join/self join. Mainly for financial risk reporting; the reporting tools are SAP business […]