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.