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.

  

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

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

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.

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.

Unlock Wd My Passport External Harddisk

Here is the python script, Download it first.

wdunlock.py

Step 1:
 Save it in a folder

Step2:

Execute the following code

sudo apt-get install python-pip python-dev lsscsi
sudo pip install py_sg

Step 3:

Goto Location of the file wdunlock.py saved in your folder. open terminal

Step 4:

Run the following code:

sudo python wdunlock.py -u

Enter your Password of your Harddisk now.




Enjoy !!..

Reference : https://github.com/0-duke/wdpassport-utils

Nokia and out look sync

Nokia and out look sync :


Just watch this video tutorial .

Manage FTP Operation without Softwate

Manage FTP Operation without Softwate:

step 1:
 ftp://username:password@domain
write your ftp details like above.
then copy.

step 2:
open my comnputer ==>
right click on my computer empty space
Add a network location ===> choose FTP.

step 3:
paste the copied content and click next and finish.

step 4:

In my computer new shortcut will appear and double click it .

step 5:
 just use all the operation like windows explorer.


Watch this video :

How To Hide File In A JPG

How To Hide File In A JPG

====================
take one picture and
One compress file(.RAR) on desktop

whatever do you want to hide, please compress it as .rar

then

=====================


>start->run->cmd

>cd desktop

>copy /b picturename.jpg + foldername.rar outputfilename.jpg

eg: copy /b 1.jpg + 2.rar a.jpg

>done

now it has only picture


==========================
HOW TO OPEN:

>ren outputfilename.jpg outputfilename.rar

eg: ren a.jpg a.rar

=========================

thank you friends

UPDATE NOKIA PHONE TUTORIAL :

(sometimes you couldn’t update via mobile)

è ==>Use nokia latest software not ovi suite use nokia suite beta

è ==>Go to Click here to go to download page 

è ==>Sign in and download

è Or  you can update via nokia software updater  click here to download

 

è Better use nokia suite beta

 How to update (step 1):

è Goto tools-àsoftware update

è If update available for phone means open that update.

è Then give install

è After that phone software will download

 

 During the update(step 2):

 

 During the update (step 3):

 During the update (step 4):

 

 During the update (step 5):

 

  Sometimes error msg  because some drivers will not install in your pc .

  So restart the pc and go to step1 :

  You no need to download again ( the error msg like bellow)