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.

  

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.

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)

CREATING DIAL UP CONNECTION

CREATING DIAL UP CONNECTION HELP FOR NOKIA OR SAMSUNG:

Step 1:

>install the necessary modem .

            >Eg. Nokia means download nokia ovi suite

Step 2:

>connect mobile and pc via data cable.

>when you connect the mobile and pc . waiting for few min.

 After installing the modem.. or you can check

By start -> control panel -> phone and modem -> check modem is present or not

 

Step 3:

>Then goto 

            start

->control panel

-> Network Connections

-> File

 ->new connection

->next

->next (1^st option)

->select set up my connection manually and give next

->next  (1^st option)

->give ISP name in the text box

For docomo users TATA.DOCOMO.INTERNET

For uninor users uninor (for other operators dialing number and apn is given bellow )

->and give next

-> then give phone number .. mostly all operators in india use *99# only

            So you can use *99# in the text box  (for other operators dialing number and apn is given bellow )

->and give next

->don’t give user name and password.

And give next.

->finish

Step 4:

 Goto start -> control panel -> Network Connections -> you will see the created connection

Eg: TATA.DOCOMO.INTERNET

->Double click this

-> and give dial option

                ->you will connect the internet enjoy….

 

BSNL 3G
APN: bsnlnet
Access Number: *99#

Airtel
APN: airtelgprs.com
Access Number: *99#

Reliance
APN: rcomnet
Access Number: *99#

Docomo
APN: TATA.DOCOMO.INTERNET
Access Number: *99#


Idea
APN: internet
Access Number: *99#

Aircel
APN: aircelgprs
Access Number: *99***1#

MTNL 3G
Postpaid APN: mtnl3g
Prepaid APN: pps3g

Vodafone
APN: Vodafone www
Access Number: *99#

VIDEOCON

 APN: VINTERNET
Access Number: *99#

Reliance 2G and 3G both
APN: rcomnet
Access Number: *99#

TRACE IP ADDRESS USING AVAST INTERNET SECURITY :

TRACE IP ADDRESS USING AVAST INTERNET SECURITY :

STEP 1:
   GO TO AVAST


STEP 2:
   GO TO FIREWALL

STEP 3 :


  GOTO NETWORK UITILITY

STEP 4:


  U MUST CONNECTED TO INTERNET  AND THEN PROVIDE IP ADDRESS


LIKE BELLOW STILL

STEP 5:

   CLICK GET DETAILS.

STEP 6 :
THIS IS AN EXAMPLE .

THANK U FRIENDS