RDBMS-PostgreSQL/C2/Installation-of-PostgreSQL/English-timed - Revision history

Sandhya.np14 at 10:48, 4 February 2019

2019-02-04T10:48:31Z

Sandhya.np14 at 09:16, 4 February 2019

2019-02-04T09:16:10Z

PoojaMoolya: Created page with " {| border=1 | '''Time''' | '''Narration''' |- | 00:01 | Welcome to the''' Spoken Tutorial''' on''' Installation of PostgreSQL.''' |- | 00:07 | In this tutorial we wil..."

2019-01-30T10:54:26Z

Created page with " {| border=1 | '''Time''' | '''Narration''' |- | 00:01 | Welcome to the''' Spoken Tutorial''' on''' Installation of PostgreSQL.''' |- | 00:07 | In this tutorial we wil..."

New page

{| border=1
| '''Time'''
| '''Narration'''

|-
| 00:01
| Welcome to the''' Spoken Tutorial''' on''' Installation of PostgreSQL.'''

|-
| 00:07
| In this tutorial we will learn to install '''PostgreSQL '''on '''Ubuntu Linux OS '''and '''Windows '''operating system

|-
| 00:17
| We will also learn to Connect to '''PostgreSQL''' database and Set password for the database

|-
| 00:25
| To record this tutorial, I am using '''Ubuntu Linux 14.04''' operating system

'''Windows 7 '''operating system and a working '''Internet''' connection

|-
| 00:38
| To follow this tutorial, you should be familiar with either of the mentioned operating system

and have working knowledge of any programming language.

|-
| 00:49
| '''PostgreSQL''' is a relational database management software.

|-
| 00:54
| It is a powerful and most advanced open source database system.

|-
| 00:59
| It runs on various platforms such as '''Linux''', '''Windows '''and''' Mac Operating System'''.

|-
| 01:07
| First we will see how to install '''PostgreSQL''' on '''Linux'''.

|-
| 01:13
| Press '''CTRL + ALT +T '''keys''' '''simultaneously to open the '''terminal'''.

|-
|01:20
| In the '''terminal''' window, type '''sudo apt hyphen get update '''and''' '''press''' Enter.'''

Enter the '''administrative password''' if prompted.

|-
| 01:34
|This command will update the '''Ubuntu's''' default repositories.

Wait until it finishes all the updates.

|-
| 01:43
| Press '''Ctrl L''' to clear the screen.

|-
| 01:47
| Next, type '''sudo apt hyphen get install postgresql''' and press '''Enter'''.

|-
| 01:59
| We can see the installation process has begun.

|-
| 02:03
|Press ''''Y'''' wherever there is a prompt to confirm the configuration.

|-
| 02:09
|Installation will take sometime to complete, depending upon your '''Internet''' speed.

|-
| 02:15
| Now we can see that the installation has been completed successfully.

Press '''Ctrl + L''' to clear the screen.

|-
| 02:25
| By default, a '''user account''' called '''postgres''' is created during installation.

But there is no '''password''' set for this '''user account'''.

|-
| 02:37
| To set the '''password''', type '''sudo hyphen u postgres psql postgres '''and press''' Enter.'''

|-
| 02:49
| Enter your '''system password''' if prompted.

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

|-
| 02:59
| At the '''prompt''', type '''slash password postgres.'''

|-
| 03:05
| Immediately you will be prompted to set a new '''password''' for the '''Postgres user'''.

I'll enter the '''password''' as ''''postgres''''.

|-
| 03:15
|You can enter a password of your choice.

|-
| 03:19
| Enter the same '''password''' one more time.

|-
| 03:23
| Please remember this password for future use.

|-
| 03:27
| Next type, '''select version open bracket close bracket semicolon '''and press''' Enter.'''

|-
| 03:36
|Do not forget to put the '''semicolon''' at the end of each '''statement'''.

|-
| 03:41
| The '''PostgreSQL''' version that we have installed now, is displayed on the '''terminal'''.

|-
| 03:47
|This indicates that we have successfully installed '''PostgreSQL.'''

|-
| 03:52
| I have increased the '''terminal font size''' for this demo.

Hence the output is seen in a different window.

|-
| 04:00
|So I’ll hit the ‘'''q'''’ key to exit.

You may not require to do so.

|-
| 04:07
| Now let us see how to disconnect from the '''server'''.

|-
| 04:11
| Type '''slash q '''and press '''Enter '''to disconnect from the '''server'''.

|-
| 04:17
|Notice that we are back at the '''command prompt''' of the '''terminal'''.

|-
| 04:23
| Every time when you want to work with '''PostgreSQL''', you need to be connected to the '''server'''.

|-
| 04:29
| '''Psql''' is an interactive '''terminal''' program provided by '''PostgreSQL'''.

|-
| 04:35
|Using '''psql''' tool, we can execute '''SQL''' statements, manage '''database objects '''etc.,

|-
| 04:44
| Another way to connect to a database is using '''pgAdmin''' '''GUI '''application.

|-
| 04:51
|We can interact with '''PostgreSQL database server '''through this interface.

|-
| 04:57
|We will be demonstrating all features using '''pgAdmin '''in this series.

|-
| 05:03
| Switch back to '''terminal'''.

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

|-
| 05:11
| For this, type '''sudo''' '''psql hyphen capital U postgres hyphen h localhost hyphen capital W '''

and press '''Enter''' to connect to the '''server'''.

|-
| 05:29
|'''hyphen h''' is the '''hostname''' or '''IP''' of the '''local server'''.

|-
| 05:35
| Enter the password for '''postgres user '''which you have set after installation.

|-
| 05:41
| We can see the prompt changes to '''Postgres.'''

Press '''Ctrl + L''' to clear the screen.

|-
| 05:49
| Let us verify the '''PostgreSQL''' database and whether the '''server''' has been started by a simple query.

|-
| 05:57
| Type, '''Select current underscore user, now();'''

|-
| 06:05
| We can see the '''user name''' and current date as output.

Hit ‘q’ key to exit.

|-
| 06:13
| During installation, some sample '''databases''' are created automatically.

Let us have a look at them.

|-
| 06:21
| Type '''slash list '''or''' slash l''' and press '''Enter'''.

|-
| 06:28
| We can see the below database names that are available in '''PostgreSQL server '''by default.

Hit ‘q’ key to exit.

|-
| 06:38
| To change a '''database''', type '''slash c''' '''database '''name.

|-
| 06:45
| I will type '''' slash c postgres'''

Then type the '''postgres password'''.

|-
| 06:54
| We can see a message saying ' '''You are now connected to database “postgres” as user “postgres”'''

|-
| 07:02
| We can create our own '''database''' and '''tables''' as per our requirement.

|-
| 07:08
| All the '''database commands''' can be executed from the '''command line'''.

|-
| 07:13
| Type ''''slash q'''' to disconnect from the '''server'''.

|-
| 07:17
| Now let us see how to install '''PgAdmin.'''

|-
| 07:21
| '''PgAdmin''' can be installed by using any one of the following methods on '''Ubuntu Linux Operating System.'''

|-
| 07:30
| Go to '''Ubuntu Software Centre '''or''' Synaptic Package manager, '''search for''' PgAdmin '''and install.

|-
| 07:39
| For more details, refer to the ‘'''Linux'''’ '''spoken tutorials '''on our website.

|-
| 07:45
| Or in the '''Terminal''', type - '''sudo apt hyphen get install pgadmin3''' and press '''Enter'''

|-
| 07:56
| I have already installed '''PgAdmin''' in my machine.

I'll show how to open '''PgAdmin.'''

|-
| 08:03
| Click '''Dash Home '''on the top left corner of the desktop.

|-
| 08:08
| In the '''Search''' box, type '''PgAdmin'''.

|-
| 08:12
| The '''PgAdmin''' icon appears. Click on it.

|-
| 08:17
| The '''PgAdmin '''interface opens.

|-
| 08:21
| Now let us learn to install '''PostgreSQL''' on '''Windows OS.'''

|-
| 08:28
| Open your web browser and go to www.postgresql.org/download

Click on the '''Windows''' link.

|-
| 08:41
| Then, click on the''' Download the graphical installer''' link.

|-
| 08:46
| I have installed '''postgres''' version 9.3.x in '''Linux Operating System'''.

|-
| 08:53
| Now I would like to install the same version in '''Windows''' also.

You can also install the latest stable version.

|-
| 09:02
| So click on the '''Previous supported versions '''and look for version 9.3.x

|-
| 09:09
| Click the link near to the '''Windows''' icon.

|-
|09:13
| It will open a dialog box to save the file.

Click on the '''Save File''' button.

|-
| 09:20
| It will take sometime to download the file. Wait until it is finished.

|-
| 09:25
| I have already downloaded it in my machine in the '''Downloads''' folder.

|-
| 09:30
| Go to the '''Downloads''' folder and double-click on the downloaded file. It will open a window.

|-
| 08:37
| Click on the '''Run''' button.

|-
| 08:40
| In the '''setup''' window, click on the '''Next''' button.

|-
|09:44
| Select the '''components''' and click on the '''Next''' button.

In the '''Installation directory''', click on the '''Next''' button.

|-
| 09:52
| Enter the '''password''' for '''postgres''' and re-type one more time. Click on the '''Next''' button.

|-
| 10:00
| Installation has started. Wait until it finishes completely.

|-
| 10:06
| Next click on the '''Finish''' button to complete the installation.

|-
| 10:11
| Lastly, exit from the wizard.

|-
| 10:15
| Let us see how to open the '''PostgreSQL command line''' on '''Windows'''.

|-
| 10:20
| Click on '''Start, '''then''' All program '''then''' PostgreSQL '''and '''psql''' to open the '''command line'''.

|-
| 10:30
| We can see the '''postgres prompt'''.

|-
| 10:33
| Type '''select version() semicolon '''and press '''Enter '''to see the installed version of '''postgresql.'''

|-
| 10:42
| This indicates that we have successfully installed in '''Windows'''.

Close the window.

|-
| 10:49
| Let us open the '''PgAdmin''' from '''Windows'''.

|-
| 10:53
| Click on '''Start, '''then''' All program '''then''' PostgreSQL '''and '''PgAdmin3''' to open the '''GUI interface'''.

|-
| 11:04
| With this, we come to the end of this tutorial. Let us summarize.

|-
| 11:09
| In this tutorial, we have learnt to install '''PostgreSQL''' on '''Ubuntu Linux '''and '''Windows '''operating systems.

|-
| 11:18
| As an assignment, Connect to the '''server''' and list the default available '''database'''

Change to anyone of the available '''database'''

|-
| 11:28
| The video at the following link summarises the Spoken Tutorial project.

Please download and watch it.

|-
| 11:36
| The''' Spoken Tutorial Project''' Team

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

|-
| 11:45
| For more details, please write to us.

|-
| 11:49
| Do you have questions in THIS Spoken Tutorial?

Please visit this site

|-
| 11:54
| Choose the minute and second where you have the question

Explain your question briefly

|-
| 12:02
| Someone from our team will answer them

|-
| 12:06
| The Spoken Tutorial forum is for specific questions on this tutorial

|-
| 12:11
| Please do not post unrelated and general questions on them

|-
| 12:17
| This will help reduce the clutter

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

|-
| 12:25
| Spoken Tutorial project is funded by NMEICT, MHRD, Government of India.

More information on this mission is available at this link.

|-
| 12:38
| This is Nirmala Venkat from IIT Bombay, signing off. Thanks for watching.

|}

@@ Line 10: / Line 10: @@
 |-
 | 00:07
-| In this tutorial we will learn to install '''PostgreSQL '''on  '''Ubuntu Linux OS '''and  '''Windows '''operating system
+| In this tutorial, we will learn to install '''PostgreSQL '''on  '''Ubuntu Linux OS '''and  '''Windows '''operating system.
 |-
 | 00:17
-| We will also learn to Connect to '''PostgreSQL''' database and Set password for the database
+| We will also learn to connect to '''PostgreSQL''' database and set password for the database.
 |-
 | 00:25
-| To record this tutorial, I am using  '''Ubuntu Linux 14.04''' operating system
+| To record this tutorial, I am using:
-'''Windows 7 '''operating system and a working '''Internet''' connection
+'''Windows 7 '''operating system and
 |-
@@ Line 30: / Line 33: @@
 |-
 | 00:49
-|  '''PostgreSQL''' is a relational database management software.
+|  '''PostgreSQL''' is a '''relational database management software'''.
 |-
 | 00:54
-| It is a powerful and most advanced open source database system.
+| It is a powerful and most advanced '''open source''' database system.
 |-
 | 00:59
-| It runs on various platforms such as '''Linux''', '''Windows '''and''' Mac Operating System'''.
+| It '''run'''s on various platforms such as '''Linux''', '''Windows '''and''' Mac Operating System'''.
 |-
@@ Line 46: / Line 49: @@
 |-
 | 01:13
-| Press '''CTRL + ALT +T '''keys''' '''simultaneously to open the '''terminal'''.
+| Press '''CTRL + ALT +T '''keys simultaneously to open the '''terminal'''.
 |-
 |01:20
- | In the '''terminal''' window, type '''sudo apt hyphen get update '''and''' '''press''' Enter.'''
+| In the '''terminal''' window, type: '''sudo apt hyphen get update '''and press''' Enter.'''
 Enter the '''administrative password''' if prompted.
@@ Line 56: / Line 59: @@
 |-
 | 01:34
-|This command will update the '''Ubuntu's''' default repositories.
+|This '''command''' will update the '''Ubuntu's''' default '''repositori'''es.
-Wait until it finishes all the updates.
+Wait until it finishes all the '''update'''s.
 |-
 | 01:43
-| Press '''Ctrl L''' to clear the screen.
+| Press '''Ctrl L''' to clear the '''screen'''.
 |-
 | 01:47
-| Next, type '''sudo apt hyphen get install postgresql''' and press '''Enter'''.
+| Next, type: '''sudo apt hyphen get install postgresql''' and press '''Enter'''.
 |-
@@ Line 78: / Line 81: @@
 |-
 | 02:09
-|Installation will take sometime to complete, depending upon your '''Internet''' speed.
+|Installation will take sometime to complete, depending upon your internet speed.
 |-
@@ Line 88: / Line 91: @@
 |-
 | 02:25
-| By default, a '''user account''' called '''postgres''' is created during installation.
+| By default, a user account called '''postgres''' is created during installation.
 But there is no '''password''' set for this '''user account'''.
@@ Line 94: / Line 97: @@
 |-
 | 02:37
-| To set the '''password''', type '''sudo hyphen u postgres psql postgres '''and press''' Enter.'''
+| To set the '''password''', type: '''sudo hyphen u postgres psql postgres '''and press''' Enter.'''
 |-
@@ Line 104: / Line 107: @@
 |-
 | 02:59
-| At the '''prompt''', type '''slash password postgres.'''
+| At the '''prompt''', type: '''slash password postgres.'''
 |-
@@ Line 126: / Line 129: @@
 |-
 | 03:27
-| Next type, '''select version open bracket close bracket semicolon '''and press''' Enter.'''
+| Next, type: '''select version open bracket close bracket semicolon '''and press''' Enter.'''
 |-
 | 03:36
-|Do not forget to put the '''semicolon''' at the end of each '''statement'''.
+|Do not forget to put the semicolon at the end of each '''statement'''.
 |-
@@ Line 144: / Line 147: @@
 | I have increased the '''terminal font size''' for this demo.
-Hence the output is seen in a different window.
+Hence the '''output''' is seen in a different window.
 |-
 | 04:00
-|So I’ll hit the ‘'''q'''’ key to exit.
+|So, I’ll hit the ‘'''q'''’ key to exit.
 You may not require to do so.