PostgreSQL installation and setup - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is PostgreSQL?

PostgreSQL is a free and open-source relational database system used to store and manage data efficiently.

beginner

Name the command to check if PostgreSQL is installed on your system.

You can check by running psql --version in the terminal or command prompt.

beginner

What is the default port number PostgreSQL listens on?

PostgreSQL listens on port 5432 by default.

beginner

After installing PostgreSQL, what is the first step to start using it?

You need to start the PostgreSQL server service and then connect using the psql command-line tool or a graphical client.

intermediate

What is the purpose of the pg_hba.conf file in PostgreSQL?

It controls client authentication, deciding who can connect to the database and how they must prove their identity.

Which command installs PostgreSQL on Ubuntu Linux?

A sudo apt install postgresql

B sudo yum install postgresql

C sudo pacman -S postgresql

D brew install postgresql

On Ubuntu, the package manager apt is used, so the correct command is sudo apt install postgresql.

What command starts the PostgreSQL service on a Linux system using systemd?

A service postgresql start

B systemctl start postgresql

C start postgresql

D pg_ctl start

The modern way to start services on Linux with systemd is systemctl start postgresql.

Which tool is used to interact with PostgreSQL from the command line?

A mysql

B pg_ctl

C pgadmin

D psql

psql is the command-line interface tool to interact with PostgreSQL databases.

What is the default username created during PostgreSQL installation?

A root

B admin

C postgres

D user

The default superuser account created is named postgres.

Where can you configure which IP addresses can connect to PostgreSQL?

A pg_hba.conf

B pg_ident.conf

C postgresql.conf

D pg_config

The pg_hba.conf file controls client authentication and allowed IP addresses.

Describe the basic steps to install and start PostgreSQL on a new Linux machine.

Think about commands and default settings.

Explain the role of configuration files in PostgreSQL setup, especially pg_hba.conf and postgresql.conf.

Focus on what each file controls.