Difference between revisions of "RDBMS-PostgreSQL/C2/Installation-of-PostgreSQL/English"

Learning Objectives

• Ubuntu Linux OS and
• Windows operating system

Learning Objectives

• Connect to PostgreSQL database and
• Set password for the database

System requirement

• Ubuntu Linux 14.04 operating system and
• Windows 7 operating system and
• a working Internet connection

Pre-requisites

• be familiar with either of the mentioned operating system
  

• and have working knowledge of any programming language.

What is PostgreSQL?

• PostgreSQL is a relational database management software.
  

• It is a powerful and most advanced open source database system.
  

• It runs on various platforms such as Linux, Windows and Mac OS.

>sudo apt-get update

Press Enter.

sudo apt hyphen get update and press Enter.

Enter the administrative password if prompted.

This command will update the Ubuntu's default repositories.

Wait until it finishes all the updates.

Press Enter.

sudo apt hyphen get install postgresql

and press Enter.

Enter 'Y'

Press 'Y' wherever there is a prompt to confirm the configuration.

Installation will take sometime to complete, depending upon your Internet speed.

Press Ctrl + L to clear the screen.

But there is no password set for this user account.

sudo -u postgres psql postgres

sudo hyphen u postgres psql postgres and press Enter.

Point to the change in the prompt

Notice that the prompt has changed to postgres equal to hash.

I'll enter the password as 'postgres'.

You can enter a password of your choice.

Postgres=#> select version();

select version open bracket close bracket semicolon and press Enter.

Do not forget to put the semicolon at the end of each statement.

This indicates that we have successfully installed PostgreSQL.

Hence the output is seen in a different window.

So I’ll hit the ‘q’ key to exit.

You may not be required to do so.

Notice that we are back at the command prompt of the terminal.

Connect to PostgreSQL database using psql

• Psql is an interactive terminal program provided by PostgreSQL.
• We can execute SQL statements, manage database objects etc.

Using psql tool, we can execute SQL statements, manage database objects etc.,

Connect to PostgreSQL database using pgAdmin

• pgAdmin is a GUI application.
• Interact with PostgreSQL database server through this user interface.
• Demonstration of all features using pgAdmin in this series.

We can interact with PostgreSQL database server through this interface.

We will be demonstrating all features using pgAdmin in this series.

Let us again connect to the postgreSQL database from the command line.

sudo psql hyphen capital U postgres hyphen h localhost hyphen capital W

and press enter to connect to the server.

hyphen h is the hostname or IP of the local server.

Press Ctrl + L to clear the screen.

Select current_user, now();

Highlight the output

Select current underscore user, now();

We can see the user name and current date as output.

Hit ‘q’ to exit.

Let us have a look at them.

Point to the message

I will type ' slash c postgres;'

Then type the postgres password.

We can see a message saying ' You are now connected to database “postgres” as user “postgres”

All the database commands can be executed from the command line.

Install using anyone of the following methods

1. Go to Ubuntu Software Centre or Synaptic Package manager

1. For more details, refer to the Linux spoken tutorials on our website.

http://spoken-tutorials.org

1. Type on the terminal

sudo apt-get install pgadmin3

Go to Ubuntu Software Centre or Synaptic Package manager, search for PgAdmin and Install.

For more details, refer to the ‘Linux’ spoken tutorials on our website.

Or in the Terminal, type -

sudo apt hyphen get install pgadmin3 and press Enter

I'll show how to open PgAdmin.

The PgAdmin icon appears. Click on it.

https://www.postgresql.org/download

Click on the windows link.

Click on the Windows link.

Click on the Previous supported versions

Now I would like to install the same version in Windows also.

You can also install the latest stable version.

So click on the Previous supported versions and look for version 9.3.x

We can see the postgres=# prompt.

This indicates that we have successfully installed in Windows.

• Ubuntu Linux and
• Windows operating systems.

1. Connect to the server and list the default available database
2. Change to anyone of the available database

About Spoken Tutorial project

Please download and watch it.

Spoken Tutorial workshops

The Spoken Tutorial Project Team

• conducts workshops using spoken tutorials and
• gives certificates on passing online tests.

For more details, please write to us.

Forum for specific questions:

• Do you have questions in THIS Spoken Tutorial?
• Please visit this site
• Choose the minute and second where you have the question
• Explain your question briefly
• Someone from our team will answer them

Forum for specific questions:

• The Spoken Tutorial forum is for specific questions on this tutorial

• Please do not post unrelated and general questions on them

• This will help reduce the clutter

• With less clutter, we can use these discussion as instructional material

Acknowledgement

More information on this mission is available at

this link.