PostgreSQL installation and setup - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the command to install PostgreSQL on Ubuntu.

PostgreSQL

sudo apt-get [1] postgresql

Drag options to blanks, or click blank then click option'

Aremove

Bupdate

Cinstall

Dupgrade

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'remove' instead of 'install' will uninstall packages.

Using 'update' only refreshes package lists, not install software.

The install command is used with apt-get to install new packages like PostgreSQL.

2fill in blank

medium

Complete the command to start the PostgreSQL service.

PostgreSQL

sudo systemctl [1] postgresql

Drag options to blanks, or click blank then click option'

Astatus

Brestart

Cstop

Dstart

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'stop' will turn off the service.

Using 'status' only shows if the service is running.

The start command launches the PostgreSQL service so it can run.

3fill in blank

hard

Fix the error in the command to switch to the PostgreSQL user.

PostgreSQL

sudo [1] -i -u postgres

Drag options to blanks, or click blank then click option'

Alogin

Bsu

Cswitch

Drun

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'login' or 'switch' are not valid Linux commands for this purpose.

Using 'run' does not switch users.

The su command is used to switch users in Linux, here to the 'postgres' user.

4fill in blank

hard

Fill in the blank to create a new PostgreSQL database named 'mydb'.

PostgreSQL

createdb [1]

Drag options to blanks, or click blank then click option'

Amydb

Bpostgres

Ctemplate1

Ddefault

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'postgres' or 'template1' will not create the intended database.

The createdb command followed by the database name creates a new database. Here, 'mydb' is the name.

5fill in blank

hard

Fill all three blanks to connect to the 'mydb' database as user 'postgres' on localhost.

PostgreSQL

psql -U postgres -[1] [2] -h [3]

Drag options to blanks, or click blank then click option'

AU

Bmydb

Clocalhost

Dd

Attempts:

3 left

💡 Hint

Common Mistakes

Mixing up the flags or using wrong host names.

Omitting the database or user flags.

The psql command uses -U postgres to specify the user, -d for the database, and -h for the host. Here, user is 'postgres', database is 'mydb', and host is 'localhost'.

Practice

1. Which of the following is the correct first step after installing PostgreSQL on your computer?

easy

A. Start the PostgreSQL service

B. Create a new database user

C. Write SQL queries immediately

D. Install a web browser

Solution

1. Step 1: Understand PostgreSQL service role

   PostgreSQL runs as a service that must be active to accept connections.

2. Step 2: Start the service after installation

   Before using PostgreSQL, you must start its service to enable database operations.

3. Final Answer:

   Start the PostgreSQL service -> Option A

4. Quick Check:

   Service must run before use = Start service [OK]

Hint: Always start the database service before using it [OK]

Common Mistakes:

• Trying to run queries before starting the service
• Assuming installation auto-starts PostgreSQL
• Skipping service start and expecting connection

2. Which command is used to start the PostgreSQL interactive terminal after installation?

easy

A. startpsql

B. psql

C. pgstart

D. postgresql

Solution

1. Step 1: Identify the PostgreSQL command-line tool

   The tool to interact with PostgreSQL databases is called psql.

2. Step 2: Confirm the correct command

   Typing psql opens the interactive terminal for running SQL commands.

3. Final Answer:

   psql -> Option B

4. Quick Check:

   Interactive terminal command = psql [OK]

Hint: Use 'psql' to open PostgreSQL terminal [OK]

Common Mistakes:

• Typing incorrect commands like 'startpsql' or 'pgstart'
• Confusing service start with terminal command
• Using 'postgresql' as a command

3. After installing PostgreSQL on Linux, which command correctly starts the PostgreSQL service?

medium

A. psql start

B. sudo start postgresql

C. service postgresql stop

D. sudo systemctl start postgresql

Solution

1. Step 1: Understand Linux service management

   Modern Linux uses systemctl to manage services like PostgreSQL.

2. Step 2: Use correct command to start service

   sudo systemctl start postgresql starts the PostgreSQL service properly.

3. Final Answer:

   sudo systemctl start postgresql -> Option D

4. Quick Check:

   Start service with systemctl = sudo systemctl start postgresql [OK]

Hint: Use systemctl to start services on Linux [OK]

Common Mistakes:

• Using 'service postgresql stop' which stops service
• Trying 'psql start' which is invalid
• Using 'sudo start postgresql' which is not a valid command

4. You installed PostgreSQL but get an error when running psql saying "could not connect to server". What is the most likely cause?

medium

A. PostgreSQL service is not started

B. You typed the wrong SQL command

C. Your computer is offline

D. psql command is deprecated

Solution

1. Step 1: Analyze the error message

   "Could not connect to server" means the client cannot reach the database server.

2. Step 2: Identify common cause

   The most common reason is the PostgreSQL service is not running, so no server is listening.

3. Final Answer:

   PostgreSQL service is not started -> Option A

4. Quick Check:

   Connection error = service not started [OK]

Hint: Check if PostgreSQL service is running when connection fails [OK]

Common Mistakes:

• Assuming SQL syntax error causes connection failure
• Thinking internet connection affects local server
• Believing psql is deprecated

5. You want to install PostgreSQL on Windows and start using it immediately. Which sequence of steps is correct?

hard

A. Install PostgreSQL -> Open psql terminal -> Start PostgreSQL service -> Download installer

B. Open psql terminal -> Download installer -> Install PostgreSQL -> Start service

C. Download installer -> Install PostgreSQL -> Start PostgreSQL service -> Open psql terminal

D. Start PostgreSQL service -> Download installer -> Install PostgreSQL -> Open psql

Solution

1. Step 1: Understand installation order

   You must first download and install PostgreSQL before starting its service.

2. Step 2: Start service before using psql

   After installation, start the PostgreSQL service to enable database access, then open psql.

3. Final Answer:

   Download installer -> Install PostgreSQL -> Start PostgreSQL service -> Open psql terminal -> Option C

4. Quick Check:

   Install -> Start service -> Use psql [OK]

Hint: Install first, then start service, then use psql [OK]

Common Mistakes:

• Trying to use psql before installation
• Starting service before installation
• Downloading installer after starting service