Installing PostgreSQL on Windows using zip archive without the installer

postgresql-logo

 

  1. Download postgresql from https://www.enterprisedb.com/download-postgresql-binaries;
  2. Unzip it;
  3. Open a cmd;
  4. Enter into the ‘bin’ directory;
  5. Init the database:
    1. initdb.exe -D ../data –username=postgres –auth=trust
  6. Start the database:
    1. pg_ctl.exe start -D ../data
  7. Open another cmd;
  8. Enter into the ‘bin’ directory;
  9. Log into the database:
    1. psql –username=postgres
  10. Create a password for your user:
    1. ALTER USER postgres WITH PASSWORD ‘VeryVerySecret’;
  11. Install adminpack extension:
    1. CREATE EXTENSION adminpack;
Advertisements