Skip to content

Latest commit

 

History

History
118 lines (63 loc) · 4.77 KB

installing-postgresql.md

File metadata and controls

118 lines (63 loc) · 4.77 KB
Raw

PostgreSQL Installation

Projected Time

30 minutes.

Objectives

Participants will be able to:

  • Install PostgreSQL.

Materials

Lesson

Choose one install method based on your operating system:

Install PostgreSQL and pgadmin on MacOSX:

  1. Follow the installation steps at the beginning of this tutorial up until the "Create a User" section: https://blog.logrocket.com/setting-up-a-restful-api-with-node-js-and-postgresql-d96d6fc892d8/

  2. Download the latest pgadmin for mac here: https://www.pgadmin.org/download/pgadmin-4-macos/. Open on your downloaded file and follow the steps in the dialog.

  3. There's no need for the materials section above. You can now skip to the Problems section below.

Install PostgreSQL and pgadmin through app on a PC.

You can follow along using these Techtonica slides: Installation steps for PC.

  • Step 1 - Go to postgreSQL downloads and select your platform (here Windows).

  • Step 2 - You are given two options:

  1. Interactive Installer by EnterpriseDB
  2. Graphical Installer by BigSQL

BigSQL currently installs pgAdmin version 3 which is deprecated. It's best to choose EnterpriseDB which installs the latest version 4.

  • Step 3 - You will be prompted to desired PostgreSQL version and operating system. Select the latest PostgreSQL version and OS as per your environment. Click the Download Button.

  • Step 4 - Open the downloaded exe and Click next on the install welcome screen.

  • Step 5 - Change the Installation directory if required, else leave it to default and click Next.

  • Step 6 - You may choose the components you want to install in your system. You may uncheck Stack Builder & click Next.

  • Step 7 - You may change the data location & click Next.

  • Step 8 - Enter super user password. Make a note of it & click Next.

  • Step 9 - Leave the port number default & click Next.

  • Step 10 - Check the pre-installation summary & click Next.

  • Step 11 - Wait for installation.

  • Step 12 - Once install is complete you will see the Stack Builder prompt, uncheck that option(for advanced tools). click Finish.

  • Step 13 - To launch PostgreSQL go to Start Menu and search pgAdmin 4.

  • Step 14 - You will see pgAdmin homepage.

  • Step 15 - Click on Servers > PostgreSQL 11 in the left tree.

  • Step 16 - Enter super user password set during installation & click OK.

  • Step 17 - You will see the Dashboard.

Install PostgreSQL Using Source Code [On Debian/Ubuntu].

You can follow along with Installation steps: Installation from Source Code.

  • Step 1 - First install required prerequisites such as gcc, readline-devel and zlib-devel using package manager.

# apt install gcc zlib1g-dev libreadline6-dev.

  • Step 2 - Download the source code tar file from the official postgres website using the following wget command directly on system (we using version 10 here for demonstration).

# wget https://ftp.postgresql.org/pub/source/v10.0/postgresql-10.0.tar.bz2.

  • Step 3 - Use tar command to extract the downloaded tarball file. New directory named postgresql-10.0 will be created.

# tar -xvf postgresql-10.0.tar.bz2.
# ll.

  • Step 4 - Next step for installation procedure is to configure the downloaded source code by choosing the options according to your needs.

# cd postgresql-10.0.

use ./configure --help to get help about various options.

  • Step 5 - Now create a directory where you want to install PostgreSQL files and use prefix option with configure.

# mkdir /opt/PostgreSQL-10/.
# ./configure --prefix=/opt/PostgreSQL-10.

  • Step 6 - After configuring, next we will start to build PostgreSQL using make command.

# make.

  • Step 7 - After build process finishes, now install PostgreSQL using following command.

# make install.

PostgreSQL 10 has been installed in /opt/PostgreSQL-10 directory.

Problems

Common issues users get while installing:

  • Using non english characters in password - Avoid using it.

Supplemental Materials

  • Commands - A list of PostgreSQL commands on a GitHub gist.