Mar 15, 2021

Installing PostgreSQL on Windows using zip archive without the installer


Steps to download and install PostgreSQL as portable version (Zip File):


1. Download the PostgreSQL Zip File.
2. Unzip the file to preferred location

3. Open Cmd and goto the location

4. Then goto bin directory

5. First we need to initialize the database. Use the following command

        initdb.exe -D ../data --username=postgres --auth=trust

6. After that start the server using the following command

        pg_ctl -D ../data -l logfile start

7. login to database

        psql --username=postgres

8. Create a password for your user:

        ALTER USER postgres WITH PASSWORD 'YourSecurePasswordHere';

9. Install adminpack extension:

        CREATE EXTENSION adminpack;

After the next time pc restart the 6th step only required.


May 5, 2020

Block a Program from accessing Internet

Block a Program from accessing Internet

Step 1:

Open Power-Shell as Administrator

Step 2:

Copy & Paste the following code into the Power-shell. Replace the Program which you want to block internet.

Remove-NetFirewallRule -DisplayName "Block Adobe x86"
Remove-NetFirewallRule -DisplayName "Block Adobe"
New-NetFirewallRule -DisplayName "Block Adobe x86" -Direction Outbound -Program "C:\Program Files (x86)\Adobe" -Action Block
New-NetFirewallRule -DisplayName "Block Adobe" -Direction Outbound -Program "C:\Program Files\Adobe" -Action Block 

Replace the Adobe with your program name.

Reference :

Apr 23, 2020

Pycharm Professional Trial Reset

Pycharm Professional Trial Reset

For me => delete the following folder


Delete reg Key


Open the pycharm again.

Reference :

Apr 13, 2020

JAVA Installation in Linux Machine

JAVA Installation in Linux Machine


  1. Download installation script
  2. Download the JDK
  3. Apply Execute permission for the script
  4. Run the Script.

First download the installation script from this link

$ wget$ wget$ sudo chmod +x$ sudo ./ -f jdk-8u221-linux-x64.tar.gz

This script will do the magic for you...! 

For Uninstalling Java download the following script and run

$ wget $ sudo chmod +x $ sudo ./

Enjoy !.

If you are going to install JRE alone then you can download this


* Tips:
For Windows JAVA Environment Variable Setup follow this link:

* Shell script Credits

Jan 17, 2019

SailsJS Generate Report

SailsJS Generate Report :

1. Install NPM Module

Official NPM Link :

npm install pdfmake
2. Copy Font Folder to Your Directory

Download it from here.. Official Repository

3. Include the Fonts and Pdfmake Module.

The sample code is given bellow.

Nov 4, 2018

Make Ubuntu 18.04 looks as Windows 10

Make Ubuntu 18.04 looks as Windows 10 :

1. Install Gnome tweak tool.

sudo apt-get install gnome-tweak-tool

If you want to open this tool. just run gnome-tweaks or search in dash

2. Install necessary Gnome extensions by visiting
    First need to install browser extensions.
    if it not installed connector then install this

sudo apt-get install chrome-gnome-shell

    Then install the following extensions.
     2. Arc-menu
     3. Panel-osd
     4. User Themes

3. Install Windows 10 by visiting

   In that page Download Icons and theme. or click the bellow link to download
   ii) Icons Download  or Visit

4) Extract and then create two folder if not exists under the home directory.
     i) .themes
     ii) .icons

5) Copy to the extracted files into the appropriate folder.

6) Open gnome tweak tool and enable user themes and map the themes to the appropriate files.

7) Enjoy..!!

Sep 21, 2018

Telegram Message Automation for Your Channel

Telegram Message Automation for Your Channel

Requirements : 

1. Telegram Account
2. Account in

For Script :

Visit My GitHub at Telegram Automation
or Direct Download

Tutorial : 

1. Open a telegram Account

2. Create a bot using BotFather.

3. Create a channel if it doesn't exists 

4. Assign the Administrator Role for both BotFather and your bot

5. Copy the token from botfather and save it into safe place.

6. Also paste token and channelname into the php script i provided

7. Open the Account and see the FTP Credentials &
    Upload it into public_html folder.

8. Add the index.php into cron jobs.

For Details See this Video Tutorial.