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;


Note:
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 : https://gist.github.com/consti/8022703

Apr 23, 2020

Pycharm Professional Trial Reset


Pycharm Professional Trial Reset


For me => delete the following folder

C:\Users\Thiru\AppData\Roaming\JetBrains
C:\Users\Thiru\.PyCharm2016.1


Delete reg Key

HKEY_CURRENT_USER\Software\JavaSoft


Open the pycharm again.


Reference :

https://gist.github.com/suzp1984/a6b408e9f903f4e7611c8feb6a4075d1

https://gist.github.com/kyberdrb/85ed63f2a0ca6bd553090f8c22e9b947

Apr 13, 2020

JAVA Installation in Linux Machine


JAVA Installation in Linux Machine

Steps:

  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 https://archive.org/download/install-java/install-java.sh$ wget https://archive.org/download/jdk-8u221-linux-x64.tar/jdk-8u221-linux-x64.tar.gz$ sudo chmod +x install-java.sh$ sudo ./install-java.sh -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 https://archive.org/download/install-java/uninstall-java.sh $ sudo chmod +x uninstall-java.sh $ sudo ./uninstall-java.sh

Enjoy !.



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


$wget https://archive.org/download/jdk-8u221-linux-x64.tar/jre-8u221-linux-x64.tar.gz



* Tips:
For Windows JAVA Environment Variable Setup follow this link:
https://stackoverflow.com/questions/1672281/environment-variables-for-java-installation

* Shell script Credits
https://github.com/chrishantha/install-java






Jan 17, 2019

SailsJS Generate Report



SailsJS Generate Report :




1. Install NPM Module

Official NPM Link : https://www.npmjs.com/package/pdfmake


npm install pdfmake
2. Copy Font Folder to Your Directory

Download it from here.. Official Repository

https://github.com/bpampuch/pdfmake/tree/master/examples


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 https://extensions.gnome.org/
    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.
     1.Dash-to-panel
     2. Arc-menu
     3. Panel-osd
     4. User Themes

3. Install Windows 10 by visiting https://www.gnome-look.org/p/1013482/

   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 www.000webhost.com


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  www.000webhost.com 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.