Atikh's DBA blog
  • Home
  • Oracle
  • MySQL
  • MongoDB
  • PostgreSQL
  • Snowflake
  • About Me
  • Contact Us

Installation of PostgreSQL 9.6 on Windows

 Atikh Shaikh     PostgreSQL     No comments   

Before starting the installation decide which version you want to install. In below example we are installing 9.6.11
go to official website of PostgreSQL to download required version
https://www.postgresql.org/download/windows/
once downloaded unzip the file and start the installation by clicking setup.exe 

You may like to see Introduction to PostgreSQL before installation 

Installation of PostgreSQL


Step 1: Welcome window, click Next

   techondba-postgresql-installation-step-1



Step 2: Select installation directory and click Next

             techondba-postgresql-installation-step-2


Step 3: Select data directory and click Next


   techondba-postgresql-installation-step-3


Step 4: Enter password for super user and click Next

    techondba-postgresql-installation-step-4



Step 5: Select port number and click Next


   techondba-postgresql-installation-step-5


Step 6: Select advanced option and keep [Default Locale] and click Next


techondba-postgresql-installation-step-6


Step 7: Next window will be "Ready to Install" click Next then Installation will begin and this will take few minutes

   techondba-postgresql-installation-step-7



Step 8: Once installation is finished, below window will appear, uncheck "Launch Stack Builder at Exit"  and click Finish
      techondba-postgresql-installation-step-8


You have finished installation successfully

Verification of installation



Step 1:  Search for pgAdmin 4 on your computer and click on it

techondba-postgresql-verification-step-1


Step 2: Below window will appear and it will start postgre in next window

techondba-postgresql-verification-step-2


Step 3: Click PostgreSQL 9.6 present on left side and enter required password and click OK
 
techondba-postgresql-verification-step-3
   

Step 4: We will able to see all the objects, verification is completed successfully.

techondba-postgresql-verification-step-4



All the best, enjoy play with PostgreSQL, keep checking this space, more will be coming on PostgreSQL, MongoDB. 

Please visit Introduction to PostgreSQL, Introduction to MongoDB
  • Share This:  
  •  Facebook
  •  Twitter
  •  Instagram
  •  Pin
  •  linkedin
  •  reddit
Email ThisBlogThis!Share to XShare to Facebook
Newer Post Older Post Home

0 comments:

Post a Comment

Author

Atikh Shaikh
View my complete profile

Categories

  • MongoDB (18)
  • Oracle 12c (30)
  • Oracle12cR2 New Feature (3)
  • PostgreSQL (20)
  • RMAN (10)
  • Snowflake (8)
  • mysql (23)
  • oracle (74)

Blog Archive

  • ▼  2018 (38)
    • ▼  November (25)
      • Introduction On MySQL
      • SQL Modes in MySQL
      • MySQL Version explained
      • MySQL Storage Engines (Part 1)
      • MySQL Storage Engines (Part 2)
      • Login to MySQL Database on Linux
      • Error Code: 1419. You do not have the SUPER privil...
      • Create MySQL database on Linux
      • Create New User in MySQL Database
      • MySQL Default database | MySQL System Database
      • Oracle ASM Basic Commands
      • Oracle Database Schema Refresh
      • Create User in Oracle Database Pre-12c and 12c
      • RMAN Disk backup and List or Report RMAN Backup
      • RMAN Backup of Single Datafile and List Backup
      • Difference Between User, Service account and Schem...
      • Create MySQL Database Backup | mysqldump mysqlbackup
      • Switching between ARCHIVELOG Mode and NOARCHIVELOG...
      • Introduction to MongoDB
      • Introduction to PostgreSQL
      • Installation of PostgreSQL 9.6 on Windows
      • Installation of MongoDB on Windows
      • Oracle DBA Scripts
      • Databases, Collections and Documents in MongoDB
      • CRUD (Create, Read, Update, Delete) Operations in ...
    • ►  December (13)
  • ►  2019 (33)
    • ►  January (15)
    • ►  February (6)
    • ►  March (2)
    • ►  April (5)
    • ►  May (5)
  • ►  2020 (5)
    • ►  April (1)
    • ►  May (2)
    • ►  July (2)
  • ►  2021 (8)
    • ►  June (3)
    • ►  July (3)
    • ►  August (1)
    • ►  December (1)
  • ►  2022 (33)
    • ►  May (3)
    • ►  June (10)
    • ►  July (3)
    • ►  August (4)
    • ►  September (8)
    • ►  October (3)
    • ►  November (2)
  • ►  2023 (14)
    • ►  February (1)
    • ►  April (5)
    • ►  May (2)
    • ►  June (1)
    • ►  September (1)
    • ►  October (1)
    • ►  December (3)
  • ►  2024 (5)
    • ►  January (2)
    • ►  March (3)
  • ►  2025 (6)
    • ►  March (1)
    • ►  April (3)
    • ►  May (2)

Popular Posts

  • ORA-29283: invalid file operation: unexpected "LFI" error (1509)[29437]
    I was trying to export the schema in my windows PC, it got stuck with below error    C:\Users\shaik\Videos\technodba exp>expdp userid...
  • PostgreSQL : How to get data directory location for PostgreSQL instance
    Sometimes, you start working on a PostgreSQL instance but forget about the data directory, here we will discuss different methods to know th...
  • Oracle 23ai : Use of NOVALIDATE Constraints in IMPDP
    While performing impdp operations in the Oracle database, Oracle performs validation checks for every constraint on the imported table, that...
  • ERROR 1221 (HY000): Incorrect usage of DB GRANT and GLOBAL PRIVILEGES
    In previous articles, we have learned about user creation and grants  in MySQL in detail, but there are a few privileges called global priv...
  • Oracle Dataguard Broker Configuration (DGMGRL)
    Data Guard Broker is a command-line interface that makes managing primary and standby databases easy. DBA can use a single command to switch...

Labels

oracle Oracle 12c mysql PostgreSQL MongoDB oracle 19c Oracle23c oracle19c Orale PDB-CDB oracle12c python AWS Oracle ASM Virtualbox pluggable database storage engine

Pages

  • Disclaimer
  • Privacy Policy

Follow TechnoDBA

Copyright © Atikh's DBA blog | Powered by Blogger