No Image

How to Check Postgres Replication

June 11, 2018 0

Run the following command in Master Node: select application_name, state, sync_priority, sync_state from pg_stat_replication; You should see the below: application_name | state | sync_priority | […]

No Image

Create bonded IPv4 and IPv6 network interface, CENTOS

April 19, 2018 0

Assuming we have 2 network cards eno1 and eno2. The configuration should look like the below: vi /etc/sysconfig/network-scripts/ifcfg-eno1 HWADDR=xx:xx:xx:xx:x1 TYPE=Ethernet BOOTPROTO=dhcp DEFROUTE=yes PEERDNS=yes PEERROUTES=yes IPV4_FAILURE_FATAL=no […]

No Image

Postgres SQL, Conditions using CASE

April 9, 2018 0

The SQL CASE expression is a generic conditional expression, similar to if/else statements in other programming languages: CASE WHEN condition THEN result [WHEN …] [ELSE […]

No Image

Tape Library Backup With Linux

April 3, 2018 0

1. Install tape library physically to the server 2. Perform lsscsi command to check device spec on system. [user@server]# lsscsi -g [0:2:0:0] disk LSI MR9260DE-8i […]

No Image

Setup OpenVPN Client

April 3, 2018 0

a. Download the 3 files from your server using SFTP or SCP. • ca.crt • client.crt • client.key b. Down load openvpn client. Webpages: https://openvpn.net/index.php/open-source/downloads.html […]

No Image

Add OpenVPN Users

April 3, 2018 0

1 – Go to the easy-rsa directory and edit the vars file. # cd /etc/openvpn/easy-rsa/2.*/ 2 – Run clean-all to ensure that we have a […]