Leeladharan Achar - alias - leelu ~ blogging...hola mi amigos.. The Blog

Leeladharan Achar - leelu Blog. Hola mi amigos!

CentOS7 Updating OpenSSH To OpenSSH7.5p1

Below are instructions on upgrading openssh6 to openssh7.5p1 on centOS7

Login to RemoteMachine

ssh to the remote machine, where we need to update. Login as root.

Now open another terminal and connect to same remote machine and login as root.

This is to make sure while upgrading if by mistake you get logged out/quit u have another session.

Steps To ...

More ...

Installing PHP 7 with nginx on mac OS X

Install Commandline Tools

xcode-select --install

Install Homebrew

ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)"

Check Installation

brew doctor

Install brew services

brew tap homebrew/services

Install bash completion (Optional)

brew install bash-completion

Update Brew and Packages if allready installed

brew update && brew upgrade

Setup Environment

sudo nano ~/.bash_profile

Add following lines

 ## # Homebrew ## export PATH="/usr/local/bin:$PATH" export PATH="/usr/local/sbin:$PATH" ## # ... 

                        
More ...

Drop a PostgreSQL database if there are active connections to it

When you are trying to drop a PostgreSQL DB say "target_db" and you find error as below

 postgres=# DROP DATABASE target_db; ERROR: database "target_db" is being accessed by other users DETAIL: There is 1 other session using the database. postgres=# 

If you get above error then there 1 active connection opened to target_db, so it cannot delete the ...

More ...

PostgreSQL Cross Database Queries using DbLink

In this post I am going to show you that how we perform cross database query in PostgreSQL.

Like MSSQLServer, MySQL database, you can select data from one database to another database. What we are doing is we simply select data using database_name.schema.table. In PostgreSQL you cannot perform the cross database query like other database technology.

In this post I ...

More ...