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

Leeladharan Achar - leelu Blog. Hola mi amigos!

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 ...

Installing and Enabling mod_geoip2 on Apache 2 (centOS 7)

To install mod_geoip2 extension for Apache2 please follow below steps

Make sure you have gcc installed

Execute below command to install all development tools (which includes gcc as well)

yum groupinstall 'Development Tools' 

Now let's install GeoIP development package

yum install geoip-devel 

If above package is not installed then you might get Error as below , when you ...

More ...