PostgreSQL pgAdmin 4 Installation

[日本語]

This is a note that summarizes what I learned from workplace and self-study.

  • PostgreSQL

Prof. Wiki: PostgreSQL, also known as Postgres, is a free and open-source relational database management system(RDBMS) emphasizing extensibility and technical standards compliance. It is designed to handle a range of workloads, from single machines to data warehouses or Web services with many concurrent users.

  • pgAdmin

Prof. Wiki: The pgAdmin package is a free and open-source graphical user interface(GUI) administration tool for PostgreSQL, which is supported on many computer platforms. The program is available in more than a dozen languages.

  • Download

1) Access the following URL.

※The latest version may exist, but the procedure is similar.

PostgreSQL Database Download

2) Check the latest version from “Windows x86-64” and press “Download” to download “postgresql-11.4-2-windows-x64.exe”.

PostgreSQLpgAdmin001

※In Windows32bit, normal operation has been confirmed with the following versions.

PostgreSQL 10.10

  • Installation

1) Double-click the downloaded “postgresql-11.4-2-windows-x64.exe”.

2) Click “Next>”.

PostgreSQLpgAdmin002

3) Enter the following information and click “Next>”.

Installation Directory : “C:\PostgreSQL\11”

PostgreSQLpgAdmin003

4) Select the following contents and press “Next>”.

– PostgreSQL
– pgAdmin 4
– Stack Builder
– Command Line Tools

PostgreSQLpgAdmin004

5) Click “Next>”.

PostgreSQLpgAdmin005

6) Set an arbitrary password(postgres) and click “Next>”.

PostgreSQLpgAdmin006

7) Click “Next>” without changing anything on the port setting screen.

PostgreSQLpgAdmin007

8) Click “Next>” without changing anything on the Advanced Option screen.

PostgreSQLpgAdmin008

9) Click “Next>”.

PostgreSQLpgAdmin009

10) Click “Next>”.

PostgreSQLpgAdmin010

11) Installation starts.

PostgreSQLpgAdmin011

12) When installation is complete, uncheck the following and press “Finish”.

– Launch Stack Builder

PostgreSQLpgAdmin012

13) Set environment variables with the following contents.

Add the following to “Path”.
C:\PostgreSQL\11\bin
※Add the PostgreSQL bin folder path.

Click HERE for how to set environment variables.

14) Execute the following command at the command prompt. If the version is displayed, it means installation was successfully completed.

psql ––version

PostgreSQLpgAdmineng013

  • Start pgAdmin 4

1) From “Start” > “All apps” > “PostgreSQL 11” run “pgAdmin 4” as an administrator and set an arbitrary password in “Set Master Password”.

PostgreSQLpgAdmin014

2) On “Connect to Server” Enter the password that you set in “Installation 6)” and press “OK”.

PostgreSQLpgAdmin015

3) Startup is complete when the following screen appears.

PostgreSQLpgAdmin016

  • Development Environment Setup(Java Web App.)

– Work environment:

Windows 10 Home(64bit)

– Settings Contents for each step:

  1. Java installation
  2. Apache Tomcat installation
  3. PostgreSQL pgAdmin 4 installation
  4. Eclipse installation
  5. First launch / setting of Eclipse(Java Web App.)

– Common setting method:

  1. Environment variables (Windows 10)

20190727