Easy setup Streaming Replication for Postgres 9.6 in Ubuntu

Recently I installed Postgresql 9.6 on two Ubuntu servers and configured streaming replication between them. Although there are many articles and guides covering this topic, I noticed that most of them are missing some important steps or they contained wrong information. After...

FATAL: the database system is starting up - Postgres Streaming Replication

I was setting up streaming replication between two Postgresql servers in active passive mode. After the setup was done, I tried to connect to the slave node to see if everything works fine and received the following error: FATAL:  the database system is starting up I...

Fix gpg: no valid OpenPGP data found error in Ubuntu

Today I was installing Postgres 9.6 in Ubuntu 14 server and while adding the key, I got this error. gpg: no valid OpenPGP data found error This is the command I entered: wget -q -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add - I tried several...

Fix tmux: error while loading shared libraries: libevent-2.0.so - upgrade to Ubuntu 18.04

I have been using Tmux for some time with Ubuntu 16.04 and it was all working so well until I upgraded my system to Ubuntu 18.04. When I tried to run tmux via the command, it interrupted with an error as shown below: tmux: error while loading shared libraries: libevent-2.0.so So...